Contents
Rearrange data in a Pivot Table by right-clicking a
field name
Rearrange data in a Pivot Table by dragging a field
name into the Pivot Table
Rearrange data in an existing Pivot Table.
To Add a Field to the Pivot Table
To Remove a Field from the Pivot Table
Hide a Single Field using the Pivot Table Fields Pane
Hiding an Item using Selected Items
Creating Multiple Reports from one Pivot Table:
Using Excel preset calculations
Create calculated fields within a Pivot Table
Create a calculated item within a Pivot Table
Modifying/Deleting Calculated Fields and Items.
To Format individual parts of the PivotTable
Creating a Pivot Chart from Excel Data
Creating Pivot Chart from a Pivot Table
Pivot Charts in earlier Excel versions
Automatically update your Pivot Table with new data