Excel Intermediate Class

With an impressive array of automated functions and tools to display data graphically, Microsoft Excel is the premier spreadsheet software application used by businesses, organizations and professionals worldwide. AcademyX's Microsoft Excel training covers the powerful set of features which will enable you to accomplish more with this industry-standard application. This hands-on class will prepare you to link workbooks to manage larger data sets, work with table data and name ranges, create custom filters to target specific data for analysis and use PivotTables to explore different relationships among data. Your instructor brings a wealth of experience using these advanced Excel techniques, and will work with you to make sure you leave class with a new set of skills ready to apply immediately.


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

Managing Workbooks

  • Managing Worksheets
  • Customizing Excel

Name Ranges

  • Using Names In Formulas


  • Sorting
  • Filtering Tables
  • Structured References
  • Validation
  • Trasposing 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

Intermediate Excel classes are offered at four locations: