PivotdrillAll 31 pivot table exercises
Pivotdrill is pivot table practice in your browser. Every exercise gives you a dataset and a request phrased the way a manager would ask it. You drop fields into Rows, Columns, Values and Filters, the table updates as you go, and the result is checked number by number. The exercises are listed here level by level. 8 are free without an account; Pro unlocks the rest.
Level 1: Basics
Rows, columns and values. Sum, Count, Average, Max and Min, and your first cross-tab.
Level 2: Sorting and filtering
Sort by value to rank items, and report filters that combine like AND.
Level 3: Dates
Group days into months, quarters and years, and filter on a grouped date.
Level 4: Show values as
% of Grand Total, % of Row Total and % of Column Total, and when to use each.
Level 5: Several values, nested rows
Two fields in Rows with subtotals, and the same field summarized more than one way.
Level 6: Real work
Requests from Sales, Finance, Support and HR: commission lists, budget tracking, resolution times and payroll shares.
Try the first eight exercises free.
No sign-up needed for the first eight, which include filters, dates and percentages. If it works for you, Pro unlocks all 31, and a free account saves your progress across devices.
Start practicing free