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