The Complete Excel Pivot Table Guide — Beginner to Advanced

8 structured chapters that build logically from basics to advanced — no jumping around, no assumed knowledge, no gaps.

Covers the complete Pivot Table workflow from raw data all the way to a finished, interactive report including slicers and Pivot Charts.

Full breakdown of all four Pivot Table areas — Rows, Columns, Values and Filters — with clear explanations of when and why to use each one.

All 11 Value Field calculation types explained including Sum, Count, Average, Max, Min and more — plus the full Show Values As options covering percentage of total, running totals, rankings and month-on-month difference.

Step-by-step instructions for creating slicers, connecting a single slicer to multiple Pivot Tables, and using Timeline slicers for date filtering — the foundation of any interactive Excel dashboard.

Calculated Fields section showing how to create new metrics like profit margin, cost per unit and target percentage directly inside your Pivot Table without touching the source data.

A dedicated troubleshooting reference table covering the 8 most common Pivot Table problems — dates that will not group, formatting lost after refresh, incorrect grand totals, old items still showing, and more — each with a clear cause and fix.

Introduction to Power Pivot explaining what it does, how it differs from standard Pivot Tables, and how to enable it — so you know exactly when you have outgrown the basics.

Professional layout with colour-coded sections, real-world examples, and a format built for scanning and quick reference rather than reading cover to cover.

Compatible with Excel 2016, 2019, 2021 and Microsoft 365 on both Windows and Mac.

If you are a complete beginner — start at Chapter 1 and work through in order. Each chapter builds on the previous one and by Chapter 3 you will have built your first working Pivot Table.

If you know the basics — jump straight to the chapter you need. Use the Table of Contents on page 2 to navigate directly. Chapter 5 for slicers, Chapter 6 for calculation types, Chapter 7 for calculated fields, Chapter 8 for troubleshooting.

As an ongoing reference — save the PDF to your desktop or bookmark it in your browser. When you hit a problem or need a reminder of how something works, open it, go to the relevant chapter, and find what you need in under a minute.

For teams — share the download link with colleagues. It works as a quick onboarding resource for anyone new to data reporting in Excel, and as a refresher for experienced users who want to fill in gaps.

Recommended workflow: Read Chapter 2 before you do anything else if you are working with existing data. Getting your data structure right before building a Pivot Table saves hours of frustration later. Then follow Chapters 3 and 4 step by step with your actual data open in Excel alongside the guide.