Pivot tabula

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.

Lai piekļūtu šai komandai...

From the menu bar:

Choose Data - Pivot Table.

Pivot tabula

Insert or Edit

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

Atsvaidzināt

Updates the pivot table.

Dzēst

Dzēš atlasīto pivot tabulu.

Pivot tabulas dialogs

Pivot tabula

Pivot tabulu izveidošana

Pivot tabulu filtrēšana

Pivot tabulu atjaunināšana

Formatting Pivot Tables

Pivot tabulu grupēšana

Pivot tabulu izvades diapazonu atlasīšana

Pivot tabulu dzēšana

Pivot Chart