How to Insert a Pivot Table in Excel 2007

If you have data that you've entered into a spreadsheet for the Microsoft Office Excel 2007 application that you want to analyze or summarize, then it is helpful to add a pivot table to your worksheet. A pivot table is used to create a report for your data that makes comparisons and illustrates trends or patterns. To insert a pivot table into your worksheet, first prepare a list of data for the report.

Instructions

1. Open the Microsoft Excel 2007 file on your computer that contains that data that you want to use for a pivot table report.

2. Use your mouse to select the data in your spreadsheet that you want to include in your report. Click on the "Insert" tab from the top toolbar menu.

3. Click on the "PivotTable" option from the "Tables" group and then click on the "PivotTable" button.

4. Click on the "New Worksheet" option if you want to place the pivot table at the beginning of a new worksheet or click on the "Existing Worksheet" option if you want to insert the pivot table at the beginning of the worksheet you have open.

5. Click the "OK" button, and the pivot table will be added to your worksheet. The "PivotTable Field List" will appear on the right side of the application; use the list to add new fields for the table.

References

• Microsoft Office: Create or Delete a PivotTable or PivotChart Report
• Microsoft Office: Overview of PivotTable and PivotChart Reports