Pivot table learning path

Excel Pivot Tables Guide

Learn how to summarize, filter, and analyze large Excel datasets with Pivot Tables, calculated fields, grouping, and refresh best practices.

Start with a clean source table

  • Use one header row, no blank rows inside the dataset, and consistent column names.
  • Convert the source range to an Excel Table so new rows are included when the Pivot Table refreshes.
  • Place text fields in Rows or Columns and numeric fields in Values for most summary reports.

Common Pivot Table fixes

  • Refresh the Pivot Table after the source data changes.
  • Use grouping for dates and numbers when you need monthly or range-based summaries.
  • Use calculated fields or SUMIFS when the metric is not already in the source data.