Excel Intermediate Training Class

This course builds on the basic concepts and skills of our Excel Intro course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users. You will benefit most from this course if you want to use Excel to perform real-world tasks, such as rearranging and presenting complex data.

Managing Workbooks

  • Managing Worksheets
  • Customizing Excel

Named Ranges

  • Using Names In Formulas


  • Sorting
  • Filtering Tables
  • Structured References
  • Validation
  • Transposing Data

Summarizing Data

  • Consolidation
  • Subtotals


  • Creating And Formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts

Presentation Features

  • Conditional Formats
  • Custom Formats
  • Graphics

Advanced Charts

  • Special Chart Types
  • Sparklines
  • Quick Analysis


  • Permissions
  • Shared Workbooks


  • Familiarity with the Microsoft Office Ribbon.
  • Understanding of cell references, formulas and functions.

Intermediate Excel classes are offered at four locations: