Excel: Pivot Tables
Date:
January 21, 2027
Time:
9:00 am-11:00 am
Place:
Zoom
Registration:

Thursday, January 21, 2027, 9:00 - 11:00am

This hands-on course is intended to teach employees advanced features of Excel, including the following topics. Completion of Excel: Intermediate or similar familiarity with Excel is strongly encouraged. The class is PC-based.

Learn to analyze and summarize worksheet data using pivot tables and pivot charts.

  • What Is a Pivot Table?
  • What Is a Pivot Chart?
  • What Is the Power Pivot Add-in?
  • Why Summarize List Data?
  • Preparing a List for Analysis
  • Working with Fields
  • Creating a Pivot Table Using the Recommended PivotTables Feature
  • Creating a Blank Pivot Table
  • Formatting a Pivot Table
  • Sorting Pivot Table Data
  • Filtering Data in a Pivot Table
  • Filtering with Slicers
  • Filtering with Timelines
  • Refreshing Pivot Table Data
  • Changing the Data Source
  • Grouping Dates in Pivot Tables.
  • Using Drill Down
  • Creating Pivot Charts
  • Setting Pivot Table Options

 

Please note that the class is PC-based.  You can attend using a Mac, but there may be some slight differences.