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.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Excel 2003

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.

Tips & Warnings

• Before creating a pivot table, select the cells you want to organize.