Difficulty: Moderately Easy
Instructions
Things You'll Need:
- Microsoft Excel 2003
-
Step 1
Open your Excel worksheet. Under “Data” on the toolbar, select “PivotTable” in the dropdown menu.
-
Step 2
In the “PivotTable Wizard” box, select the data you want to analyze by clicking on the corresponding radio buttons. Click “Next.”
-
Step 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.”
-
Step 4
In the final screen, select whether you want the pivot table to appear in a new worksheet or an existing one.
-
Step 5
Click “Finish” to insert the pivot table. Save your work.
