Summarizing and Slicing Data

An introduction to the use of pivot tables in Excel
Get started with one of the learning modules:
To get started, click on one of the topics above. Although the modules have sequence, from preparation through interactive use, it is not necessary to experience them in sequence. You may begin where you like or skip around.

A short, informal Quiz is offered on the Lesson pages. It can be used to review the main points of the topic, as desired.

Preparation is about how to layout data in a proper tabular format. If your data already comes in this format, then skip to the Build/Create module.

The Build/Create module illustrates the basics of creating a pivot table from tabular data.

If your staff prepares pivot tables, then it may be appropriate to begin with the Interact module.