How Do You 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. Open your Excel worksheet. Under “Data” on the toolbar, select “PivotTable” in the dropdown menu. In the “PivotTable Wizard” box, select the data you want to analyze by clicking on the corresponding radio buttons. Click “Next.” 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.” In the final screen, select whether you want the pivot table to appear in a new worksheet or an existing one. Click “Finish” to insert the pivot table. Save your work.
