Turn any raw data dump into clear summaries in minutes using pivot tables in Excel and Google Sheets.
Data & AnalyticsPDF · 12 pages· v1.0
4.6Pivot tables are the fastest way to summarize data in a spreadsheet, and the most underused. If you have ever copied a column into a calculator, written a forest of SUMIF formulas, or manually counted rows, this guide will change how you work. It teaches pivot tables from scratch and through to the techniques pros use daily, in both Microsoft Excel and Google Sheets. It is for anyone comfortable opening a spreadsheet who wants to stop doing summarization by hand: analysts, operations staff, finance, founders, students. No formulas knowledge required. You will learn the one data layout pivot tables require (and why exports often violate it), how the four zones (Rows, Columns, Values, Filters) work, how to switch a value between Sum, Count, and Average, how to group dates into months and quarters, how to show values as a percentage of the total, and how to add calculated fields. The guide covers both Excel and Sheets side by side, calling out where they differ. It also covers the things that frustrate people: why your numbers show as Count instead of Sum, how to refresh when source data changes, why blank rows break the range, and how to keep a pivot from breaking when you add new data. The outcome: you can take a messy 10,000-row export and produce a clean, grouped, percentage-of-total summary in two minutes, in either spreadsheet program.
Both. Every technique is shown for both programs side by side, with notes wherever they differ (menu names, date grouping, calculated fields). Buy once, use either.
No. The whole point of pivot tables is to summarize without writing formulas. The optional calculated-fields section introduces light formula syntax, clearly explained.
Almost always because the value column contains text or blanks, so the spreadsheet defaults to counting. The troubleshooting section walks through finding and fixing this, it is the single most common pivot problem.
Yes, if you set it up correctly. The guide shows how to base a pivot on a full-column range or an Excel Table so new rows are included automatically, and how to refresh.
Read the full refund policy and trust & safety terms.