How to Use the Pivot Table Wizard in Excel 2003
Excel 2003's "PivotTable Wizard" can organize hundreds of rows of data in seconds. The wizard will set up a pivot table in several easy steps, described here.
Instructions
-
-
1
Open your Excel worksheet. Under "Data" on the toolbar, select "PivotTable" in the dropdown menu.
-
2
In the "PivotTable Wizard" box, select the data you want to analyze by clicking on the corresponding radio buttons. Click "Next."
-
-
3
In the next screen, select the "range" you want to analyze. To define the range, drag your left mouse over the cells you want sorted. Click "Next."
-
4
In the final screen, select whether you want the pivot table to appear in a new worksheet or an existing one.
-
5
Click "Finish" to insert the pivot table. Save your work.
-
1
Tips & Warnings
Before creating a pivot table, select the cells you want to organize.