How to Use Microsoft Office Excel 2007 to Create a Pivot Table

Pivot tables are an advanced function of Microsoft Excel. These types of tables are separate from the original spreadsheet. If you create or download reports at work using Excel, then knowing how to create a pivot table will help you to summarize and analyze your data -- especially data in lists and tables. Excel 2007 includes a built-in feature for creating a pivot table.

Laptop computer and numbers
A pivot table can help you make sense of your data.
credit: Ablestock.com/AbleStock.com/Getty Images

Step

Click in the Excel worksheet in which you want to create a pivot table. Your data should have column headings before using it in a pivot table. If it doesn't, add column headings.

Step

Click the "Insert" tab and click "PivotTable" in the Tables grouping. Click "PivotTable" again. A dialog box opens.

Step

Type the cell range or table name that you want to analyze with your pivot table into the Select a Table or Range text box.

Step

Click the radio button next to "New Worksheet" or "Existing Worksheet," depending on your preference. If the latter, enter the first cell where you want to display your pivot table report.

Step

Click "OK."