2007 Microsoft® Office System Plain & Simple

Summarizing the Data with a PivotTable

A PivotTable is a dynamic and powerful analysis tool that lets you look at relationships among your data and enables you to extract only the portions of the data that are of interest to you. It can sometimes be a bit difficult to figure out the proper arrangement of the data fields, but once you’ve created the PivotTable, you’ll find it easy to work with and very useful.

Create the PivotTable

1. Select the range of cells you want to use as the data for the PivotTable.

2. On the Insert tab, click the PivotTable button ...