Priority 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.

DataPilot

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 DataPilot table.

Delete

Deletes the selected DataPilot table.

DataPilot

Creating DataPilot Tables

Filtering DataPilot Tables

Updating DataPilot Tables

Formatting Pivot Tables

Grouping DataPilot Tables

Selecting DataPilot Output Ranges

Deleting DataPilot Tables

Pivot Chart