Includes a hard-copy book and access to an online Learning Locker (ebook).  If you have taken the respective ProMark class within the past 3 months, you will also receive 90 days of on-call training support for that class. (Please add your class date in either of the text fields below.)


Price includes shipping and handling.


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 (course material only)