Building a Pivot Table

You can build a simple pivot table with the Data, PivotTable and PivotChart Report option, which displays a series of PivotTable Wizard dialog boxes. The wizard steps you through the process of creating a pivot table, and you get to see a basic breakdown of the data you have in your Excel list or database. A diagram with the labels PAGE, COLUMN, ROW, and DATA appears, and you just drag field buttons onto the diagram. This step tells Excel about the data you want to analyze with a pivot table.

Perform the steps in the following To Do exercise to create a pivot table from an Excel list. Get ready to use the Data Analysis workbook you used in Hour 17, “Analyzing Your Data.”

To Do: Build a Pivot Table

In Sheet2 in the Data ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.