Webinars > All COMPUTERS / SOFTWARE Categories > Office Software Webinars

Skillpath Seminars
SkillPath Seminars presents

Virtual Classroom (Live) One-Day Advanced Training for Microsoft® Excel® Webinar

This intensive training puts you in command of Excel's most advanced features and functions.

Course Description/Agenda


As an Excel user, you know that the software has nearly unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This LIVE, virtual workshop will teach you the most advanced features and functions Excel offers — taking your level of proficiency from mid-level to advanced. After a few hours of training you’ll be amazed at how this powerful program can work for you. 

This intensive training puts you in command of Excel’s most advanced features and functions. We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training.

What You Will Learn

  • Time-saving keyboard shortcuts
  • How to personalize the look of your tables, charts and more to give your work added pizazz
  • Insider secrets to creating even more amazing macros that do the hard work for you
  • Techniques that make sharing workbooks much easier for everyone

WORKSHOP AGENDA

Program time: 3 hours

Session 1: Easy Editing Techniques

  • Using the Advanced Filter and AutoFilter to display the information you need
  • Controlling multiple ranges with AutoFill
  • Extracting filtered ranges
  • Using multiple criteria for creating advanced filters, databases and list management
  • Time-saving keyboard shortcuts

Session 2: Sharing Workbooks

  • Setting up shared workbooks
  • View users sharing a workbook
  • Change the updated frequency
  • Merging shared files
  • Creating pull-down menus for shared workbooks

Session 3: More Than Your Basic Macro

  • Macro review: Running, stopping and pausing macros
  • Assign macros to buttons and objects
  • Starting Visual Basic® Editor (VBE)
  • Using VBE to create new macros and edit existing ones
  • Using variables in macros
  • Creating interactive macros
  • Debugging macros with the Step feature

Session 4: Editing Steps for Macros

  • Editing existing macros from the macros menu
  • Editing existing macros using Editor
  • Streamlining your access to VBA modules with Project Explorer
  • Where to find free Visual Basic code for macros

Session 5: Formulas and Functions

  • Building complex formulas quickly and easily
  • Using the Function Palette and cutting your work time in half
  • Using key logic functions IF, AND, OR and NOT to make data more usable
  • Creating conditional formulas
  • Using MATCH, INDEX, VLOOKUP and HLOOKUP in large worksheets
  • Manipulating text entries with Excel®’s extensive set of functions and formulas

Session 6: Using Analytical Options

  • Using Goal Seek and Solver
  • Working with the Analysis ToolPak
  • Working with scenarios to analyze data and equations
  • Working with view options

Session 7: Advanced Charting, Tables, Databases and Lists

  • Using auditing to create a visual map of your data
  • Creating custom charts for added interest and relevance to your reporting
  • Exploring database functions
  • Working with data forms
  • Creating data tables
  • How to create and manage PivotCharts and Tables

Session 8: Special Section: Data Exchange, the Web and Excel

  • How to do a quick Internet search for information—right from your Excel spreadsheet
  • Creating hyperlinks in your spreadsheet that will take users straight to a Web page
  • Importing and exporting text files and XML data
  • How to publish your Excel charts and data on the Web more quickly

 

More Webinar Information

SkillPath Seminars
Skillpath Seminars

Course Summary

This intensive training puts you in command of Excel's most advanced features and functions.

Delivery Method

Virtual Classroom (Live) Virtual Classroom (Live)

Who Should Attend

We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training.

 
Search similar training
Email this page
Print this document
 

Webinar Details

This date could not be found.


see all dates/times

 

Frequently Asked
Questions

Payment Options
Bill Me/Invoice
Credit Card

Register
Online
Fax Form

Availability
Select a date from the list at the bottom of the page for specific information about that class.

Other Information
Virtual Classroom (Live)

All Date/Location Information