In-person, instructor-led class open to the public at TriHealth's Norwood location.  Electronic training material will be provided.  You may purchase a hardcopy training manual to take home ($25) by selecting the option listed.  Marking in or damaging classroom-use training material will result in a charge.  Class will be cancelled 2 business in advance if a minimum # of students is not reached.


Address: 4750 Wesley Ave, 1B Education Center, Norwood, OH 45212.


Course Length: 1/2 day, 8:30 AM to 12:30 PM or 1:00 PM to 5:00 PM (varies by day)


Course Objectives

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data.


You will:

  • Prepare data for PivotTable reporting and create PivotTables from various data sources.
  • Analyze data by using PivotTables.
  • Work with PivotCharts.


Course Content

Lesson 1: Preparing Data and Creating PivotTables

 Topic A: Prepare Data

 Topic B: Create a PivotTable from a Local Data Source

 Topic C: Create a PivotTable from Multiple Local Data Sources

 Topic D: Create a PivotTable from an External Data Source


Lesson 2: Analyzing Data by Using PivotTables

 Topic A: Summarize PivotTable Data

 Topic B: Organize PivotTable Data

 Topic C: Filter PivotTable Data

 Topic D: Format a PivotTable

 Topic E: Refresh and Change PivotTable Data


Lesson 3: Working with PivotCharts

 Topic A: Create a PivotChart

 Topic B: Manipulate PivotChart Data

 Topic C: Format a PivotChart


Excel Pivot Tables (TriHealth)

Class Dates
Purchase hardcopy training material?
What version of MS Office are you using?