Home > Pivot > Create > Topics

# Pivot Table Topics

Learn how to use Microsoft Excel pivot tables to analyze and organize your data. The tutorials listed below will show you how to create, customize and format pivot tables. You'll find easy-to-follow steps, videos, expert tips, and examples.

## Get Started with Pivot Tables

These step-by-step tutorials show how to get started with Excel Pivot Tables, so you can organize, summarize, and analyze your data like a pro.

-- 5) Pivot FAQs

## Pivot Charts

These tutorials show how to get started with Excel Pivot Charts, and fix a few simple problems you might have when you build them.

### A ) Create a Pivot Chart

-- 1) Create a Pivot Chart

-- 3) Compare Years

### B ) Change a Pivot Chart

-- 2) Data Source, Change

-- 3) Layout, Change

-- 4) Number Formatting

## Pivot Filters and Slicers

Working with Excel pivot table filters and slicers allows you to dynamically control and refine the data that's summarized in your pivot table.

-- 3) Label Filters

-- 5) Report Filters

-- 7) Pivot Table Slicers

-- 8) Value Group Slicers

## Pivot Table Calculations

Use the following types pivot table calculations to extend the capabilities of your pivot tables.

### A) Calculated Fields & Calculated Items

Excel pivot table calculated items and calculated fields are powerful features that allow you to perform advanced calculations and analysis within your pivot tables.

-- 2) Calculated Field

-- 5) Calculated Item

-- 6) Custom Calculations

### B) Summary Functions

With the built-in summary functions, you can calculate and display various statistical measures such as sums, averages, counts, minimum and maximum values, and more.

-- 2) Summary Functions

-- 3) Count Blanks

-- 4) Count Unique Items

### C) Show Values As

The "Show Values As" feature lets you choose different ways to calculate the data summaries. For example, you can show values as percentage of a total, difference from a specific value, running total, rank, and more.

-- 1) Show Values As

-- 2) Difference From

### D) Formulas and Functions

Use formulas in your source data, to get better results in your pivot table. Or, use the GetPivotData function to extract specific data from a pivot table.

## Pivot Table Layout

By adjusting the layout of a pivot table, you can quickly see your data at different levels of detail and summarization. Analyze your data from multiple angles and get a clearer understanding of the underlying trends and patterns.

### A) Pivot Fields

-- 2) Pivot Table Layout

-- 3) Report Layout

-- 5) Field Settings

### B) Pivot Items

-- 1) Remove Old Items

-- 2) Show/Hide Items

### Value Fields

-- 1) Data Fields

-- 2) Show Text Values

-- 3) Time Values

## Pivot Macros

Use these macros with your pivot tables, to automate repetitive tasks, streamline data analysis, and enhance the functionality of your pivot tables.

### A) Pivot Table Macros

-- 8) Report Layout Macro

-- 10) Pivot Power Free Add-in

### B) Source Data Macros

-- 1) Source Data Macros

### C) Pivot Chart Macros

-- 1) Pivot Chart Macros

## Source Data and Refresh

By properly preparing and managing your source data, you can ensure the accuracy and reliability of your pivot table analysis, making it easier to derive meaningful insights and make informed decisions based on your data.

-- 3) Filter Source Data

-- 7) Recreate Source Data

-- 10) Unpivot, Power Query

-- 11) Pivot Cache

-- 12) Pivot Table Refresh

## Totals and Grouping

Use Excel's pivot table totals and grouping features to present and analyze your data in a more structured and meaningful way. With these toos, you can quickly identify patterns, spot trends, and gain valuable insights from your data.

-- 4) Grand Totals

## Formatting and Printing

By formatting and printing your pivot tables effectively, you can create visually appealing reports that are easy to read, understand, and share with others

### A) Formatting

Use these settings to customize the appearance of your pivot table

### B) Printing

Use these settings to ensure that your printed pivot table is well-structured and easy to follow

-- 1) Pivot Table Printing

## Troubleshoot & Protection

Working with Excel pivot table protection and troubleshooting helps ensure the integrity and smooth functioning of your pivot tables.

-- 3) Pivot Table Errors

## Power Pivot & Power Query

Working with Excel Power Pivot and Power Query opens up advanced data modeling and transformation capabilities within Excel

Last updated: May 18, 2023 3:14 PM