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

By Techwalla Contributor

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.

Step 1

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 2

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

Step 3

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 4

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 5

Click "OK."

Tips & Warnings

  • Save your work.