How to Create a Pivot Table in Excel 2003

Get the information you need from your data in Excel 2003.

Microsoft's Excel software creates spreadsheets for keeping track of data, and its PivotTable feature helps you to make sense of that data. In a PivotTable report, you create your own categories for sorting data. For example, if you're using Excel 2003 to record sales for your small business, your PivotTable report can break down the figures by month or type of goods sold. The PivotTable and PivotChart Wizard in Excel 2003 helps you to create the PivotTable.

Instructions

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.

Tips & Warnings

• You can also create a PivotTable report from multiple Excel spreadsheets.

References

• Office.com: PivotTable Reports 101