Home > Excel Topics > Pivot Tables

Pivot Table Topics on Contextures

Use Excel Pivot Tables to quickly summarize data from a list or Excel table. See how to get started, then learn more about the power of pivot tables!

Pivot Table Layout

These Excel tutorials and videos show how to fine tune the pivot table layout, using pivot table settings, labels, report layout options, and much more.

The short video below shows the steps for creating a grand total at the top of the pivot table, and the written instructions are on the Pivot Table Grand Totals page.

Pivot Tables - Create

These tutorials show how to create an Excel pivot table, so you can quickly analyze Excel data.

Are you just getting started with Excel pivot tables? See how to plan, get ideas, and build what you need. Sample Excel file, written steps, and a video, on the Pivot Table Setup page.

Pivot Table Formulas

These tutorials show how to use pivot table formulas for calculated fields, calculated items, summary functions, and custom calculations.

In the video below, I show how to calculate a distinct count with the Excel Data Model, and there are written steps on the Excel Pivot Tables Count Unique Items page.

Pivot Charts

Create Excel pivot charts, for a graphic summary of pivot table data. When you change a pivot chart, its pivot table changes too.

In the video below, I show how to make a Cluster Stack pivot chart. It has stacked columns that are grouped into "clusters". There are written steps, and an Excel file, on the Cluster Stack Pivot Chart page.

Pivot Table Filters

Use Excel Pivot Table filters to quickly focus on specific data in your pivot table summary. Filter by date, value, top or bottom rankings, and more.

Use Pivot Table Top 10 Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data. Sample Excel file, written steps, and videos, on the Top 10 Filters page.

Pivot Table Macros

Use Excel Pivot Table macros to automate pivot table tasks. Create lists, change layouts, adjust option settings, and more.

Use these macros to create a list of the fields in a pivot table, and details for each field, such as caption and position. Sample Excel file, and written steps, on the List all Pivot Table Fields page.

Pivot Table Formatting

These tutorials show how to create an Excel pivot table, so you can quickly analyze Excel data.

Are you just getting started with Excel pivot tables? See how to plan, get ideas, and build what you need. Sample Excel file, written steps, and a video, on the Pivot Table Setup page.

Pivot Table Errors

These tutorials show how to create an Excel pivot table, so you can quickly analyze Excel data.

Are you just getting started with Excel pivot tables? See how to plan, get ideas, and build what you need. Sample Excel file, written steps, and a video, on the Pivot Table Setup page.