How to Create a Pivot Table in Excel 2003

1. Create a spreadsheet in Excel with all of the data you want to place in your PivotTable.
2. Open a new a workbook for your PivotTable report.
3. Click on 'Data' in the menu bar, and then 'PivotTable and PivotChart Report.' This launches the PivotTable and PivotChart Wizard.
4. Select the option to use data from one Excel list or database. Click 'PivotTable.'
5. Select your data range. This is the actual data for your PivotTable. Click on the 'Browse' button and select the file and datasheet for your PivotTable. Click 'Finish.'
6. Drag your fields from the PivotTable Field List into the 'Column' and 'Row' sections of the PivotTable. Put the field that you want totaled into the 'Data Items' section.
7. Right-click anywhere on the table and click on 'Table Options' to change or add options for totals. Right-click on a field and click on 'Field Settings' to rename a field and change its count settings.
8. Drag the fields in the columns and rows to rearrange the data within the table. Switching the columns will change how the table reports the totals.