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.”
In Sheet2 in the Data ...