Pivot Tables

Aggregation

When you wish to show different aggregation on your Pivot Table fields than what is provided by default.

Running Totals

When you need to display a running total on your Pivot Table.

Percent of x Calculations

When you need to display a value as the % of another value on your Pivot Table.

Difference From Calculations

When you need to display values that are a difference from another value in a Pivot. This is very useful for showing growth/decline from previous periods.

Percentage Difference From Calculations

When you need to display values that are a percentage of difference from another value in a Pivot. This is very useful for showing growth/decline from previous periods.

Top and Bottom x Items

When you want to filter your Pivot Table to show the top/bottom x items or top/bottom x% of items in the data set.

Calculated Fields

Understanding how to create calculated fields in a Pivot Table.

Calculated Items

Understanding how to create calculated items in a Pivot Table.

Value Field Formats

Various ways to display numbers in the values area of a Pivot Table.

Preserving Cell Formats on Update

How to force a Pivot Table to preserve cell formats and column widths when it is updated.

Pivot Table Styles

Using pre-defined styles with a Pivot Table.

Custom Pivot Table Styles

Creating your own style to use with a Pivot Table.

Conditional Formatting on Pivot Tables

Basics of applying conditional formats to a Pivot Table.

Basic Sorting

Basic sorting of row and column headers in a Pivot Table.

Custom Sorting

Creating Custom Sort Orders for a Pivot Table.

Sorting Values

Sorting the values area of a Pivot Table.

Report Filters

Using Report Filters to narrow down results in a Pivot Table.

Built in Filter Controls

Using row and column filters to narrow down results in a Pivot Table.

Slicers

Slicers are user-friendly filters for Pivot Tables.

Filtering Multiple Pivot Tables

Filtering multiple Pivot Tables at once with Slicers.

Show Details

Using Show Details to extract details from a summarized value.

GETPIVOTDATA

Using the GETPIVOTDATA function to extract specific fields from a Pivot Table.

Creating Pivot Charts

Creating Pivot Charts out of a Pivot Table.

Automating Refresh

Automating Pivot Table refresh operations.

Pre-release Considerations

Items to consider before releasing your file to users.