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, 9:00 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)

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