Excel Intermediate 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

Name Ranges

  • Using Names In Formulas

Tables

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

Summarizing Data

  • Consolidation
  • Subtotals

PivotTables

  • Creating And Formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts

Presentation Features

  • Conditional Formats
  • Custom Formats
  • Graphics

Advanced Charts

  • Special Chart Types
  • Sparklines
  • Quick Analysis

Collaboration

  • Permissions
  • Shared Workbooks

Prerequisites:

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

Intermediate Excel classes are offered at four locations: