Microsoft Excel Advanced

If you enjoyed our Microsoft Excel Basics class, join us for more hands-on activities to help you absorb the material. We will delve into more advanced features of Excel. Class modules include:

Managing Multiple Workbooks and Worksheets

Using 3-D References in formulas
Using links and External References in formulas
Applying cell and range names
Consolidating data using the Consolidate command

Analysis Tools

Applying advanced Conditional Formatting
Determining potential outcomes with Data Tables
Performing What-if Analysis using Goal Seek and Scenarios
Exploring the basics of PivotTables and PivotCharts

Managing Worksheet Functionality

Adding Data Validation criteria
Creating and editing a basic macro
Working with forms and controls
Examining invalid data and formula errors


PLEASE NOTE: Registration is required for this event. Use the "Register" link on this page.