Creating PivotTables

Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.

Creating a PivotTable report

If you use the sample spreadsheet to create a PivotTable, you can see that the column headings are salesperson, region, account, order amount, and month. When you create a PivotTable, each column label in your data becomes a field that can be used in the report. The Field List appears on the right side of the report, while the layout area appears on the left.

Pivot Table View

To create a PivotTable report (Part 2):

Pivot Table Example

If you change any of the data in your source worksheet, the PivotTable will not update automatically. To manually update it, select the PivotTable and then go to OptionsRefresh.

To add a report filter: