Pivot Table

Opens a submenu to create or edit a pivot table. A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.

To access this command...

From the menu bar:

Choose Data - Pivot Table.

Pivot Table

Insert or Edit

Opens a dialog where you can select the source for your pivot table, and then create or edit your table.

Refresh

Updates the pivot table.

Delete

Deletes the selected pivot table.

Pivot table dialog

Pivot Table

Creating Pivot Tables

Filtering Pivot Tables

Updating Pivot Tables

Formatting Pivot Tables

Grouping Pivot Tables

Selecting Pivot Table Output Ranges

Deleting Pivot Tables

Pivot Chart