Veltitafla

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.

Til að nálgast þessa skipun...

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.

Endurlesa

Updates the pivot table.

Eyða

Deletes the selected pivot table.

Gluggi veltitöflu

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