Yes. You can start learning on Learnr for free. Learnr Pro unlocks higher daily limits and extra features.

Learn Excel Pivot Tables

Summarize thousands of rows in a few drags, then slice them any way you like.

Free to start. Built from a single prompt. No credit card.

A pivot table summarizes a large table of records by dragging fields into four areas: Rows, Columns, Values and Filters. In seconds you can see revenue by region and month, count orders by product, or compare years, without writing a formula. The skill has two halves. The first is preparing source data in a clean tabular layout, one header row and one record per row, ideally formatted as an Excel Table. The second is shaping the summary with value settings, date grouping, Show Values As, slicers and calculated fields. Learnr builds an Excel pivot table course around your own reporting needs, in short lessons you can follow in a workbook.

How to learn Excel Pivot Tables, step by step

Fix the source data first. Make sure there is a single header row, no blank rows or merged cells, and one record per row. Press Ctrl+T to convert the range into a Table, so new rows are picked up automatically when you refresh.
Build a first summary by dragging fields. Insert a PivotTable on a new sheet, drag a category to Rows, a date to Columns and an amount to Values. Swap fields between areas to see how the same data answers different questions.
Change what the values show. Switch a field from Sum to Count or Average in Value Field Settings, and use Show Values As for percent of grand total, percent of row total or difference from the previous month. Format numbers there too.
Group, sort and filter with intent. Group dates by month, quarter and year, group ages or prices into bands, and sort by value rather than alphabetically. Add slicers and a timeline so others can filter the report with clicks.
Visualize and refresh. Create a PivotChart tied to the pivot, then add rows to the source Table and click Refresh to watch both update. Short Learnr practice sessions help you remember which setting lives in which menu.
Go further with calculated fields and the Data Model. Add a calculated field such as profit margin, and learn why it sums before dividing. For related tables like orders and customers, add them to the Data Model and pivot across both without VLOOKUP.

What you'll learn

Prepare source data as a clean Excel Table ready for pivoting
Build pivot tables using the Rows, Columns, Values and Filters areas
Change summaries with Summarize Values By and Show Values As
Group dates and numbers and filter with slicers and timelines
Create PivotCharts and refresh reports when the data changes

What's inside your Excel Pivot Tables course

A sample path Learnr builds for Excel Pivot Tables. Your real course adapts to your goal and level.

1. Preparing tidy source data
2. Your first pivot table
3. Value field settings and percentages
4. Grouping, sorting and filtering
5. Slicers, timelines and PivotCharts
6. Calculated fields and multi-table data models

How long does it take to learn Excel Pivot Tables?

Building useful pivot tables takes most people a few hours of practice, and comfort with grouping, Show Values As, slicers and PivotCharts comes within 1 to 3 weeks of regular use. The Data Model and Power Pivot take longer.

What you need before you start

Basic Excel skills: selecting ranges, sorting and simple formulas like SUM. No advanced formulas are needed, which is part of what makes pivot tables approachable.

Common mistakes to avoid

Pivoting messy data with merged headers, subtotal rows or blank cells, which produces odd categories and wrong totals. Clean the source into one tidy table first.
Forgetting to refresh after the data changes. Pivot tables do not recalculate automatically, so refresh, or set the file to refresh on open.
Seeing Count where you expected Sum because a numeric column contains text or blanks. Fix the column so Excel treats it as numbers.

How Learnr builds your course

Type your topic

Tell Learnr you want to learn Excel Pivot Tables, or get as specific as you like.

Get a personalized course

Learnr instantly builds a full Excel Pivot Tables course tailored to your goal and skill level.

Learn and level up

Move through bite-sized lessons and interactive practice, earning XP and keeping your streak.

Excel Pivot Tables questions, answered

Are pivot tables hard to learn?

No. The basic drag and drop takes minutes, and the main early hurdle is having clean source data. Advanced features like calculated fields and the Data Model take more time but are optional.

What is the difference between a pivot table and SUMIFS formulas?

Both summarize data by conditions. A pivot table is faster to build and rearrange for exploration, while SUMIFS gives precise control over a fixed report layout and updates without a refresh.