Pivot table practice that checks the numbers, not the clicks
Most pivot table tutorials walk you through one example with screenshots, and you follow along by clicking where the arrows point. A week later you open a new dataset and cannot remember whether the month goes in Rows or Columns. Pivotdrill was built around one rule: the only way through an exercise is a pivot that produces the right table.
Your pivot is calculated and compared with the expected one, number by number, with value fields accepted in any order. If something is off, the feedback says what: a field in the wrong area, the wrong calculation, a missing filter or the wrong sort. That is the difference between recognizing a pivot table and being able to build one when someone is waiting.
Excel pivot table exercises, right in your browser
There is nothing to download and no sample workbook to find. Each exercise shows its source data and a pivot builder with the same four areas Excel uses: Filters, Columns, Rows and Values. You add fields, choose Sum, Count, Average, Max or Min, group dates, switch Show values as and sort, and the PivotTable updates as you go.
What you practice carries straight over to Excel and to Google Sheets, because the areas, the calculations and the percentage options are the same. Progress is saved in your browser, and a free account keeps it across devices.
Pivot table practice data from five real businesses
Each exercise uses one of five datasets you could meet at work: sales orders by region, rep and product; expense claims by department, category and status; a staff list with location, level and salary; support tickets with priority, channel and hours to resolve; and online store orders by channel, country and customer type.
The requests are the ones that land in an inbox: revenue by region, how many orders per product, approved spending only, ticket volume per month, each region's share of revenue, the average salary by department and level. Nothing is invented to pad the list.
Learn pivot tables in six levels
The 31 exercises are organized into levels, and each level only adds one idea on top of what you already know.
- Basics: revenue by region, orders per product with Count, average salary by department, a region by product grid, the slowest ticket per team.
- Sorting and filtering: best region first, approved spending only, office staff headcount without remote workers, high priority workload with two filters.
- Dates: revenue by month, spending by quarter, year over year by department, ticket volume per month by channel, the fourth quarter only.
- Show values as: share of revenue, product mix inside each region, where each channel sells, headcount share by level.
- Several values, nested rows: units and revenue together, region then rep with subtotals, count, total and average of the same field, pay by department and level.
- Real work: a commission check sorted highest first, approved spend per quarter and department, resolution time by priority on closed tickets, payroll share by location, returning customer value.
Within a level the exercises get harder one notch at a time. By the end of Dates you have grouped a date field by month in Rows, put years across the top and filtered on a quarter, not because you read about it, but because the exercise would not pass until you did.
Open the exercise list
Show values as: the percentages everyone gets backwards
The three percentage options are where most pivot table mistakes happen. % of Grand Total divides every cell by the overall total, so the whole table adds up to 100%. % of Row Total answers how each row is split, so every row adds up to 100%. % of Column Total answers how each column is split. Pick the wrong one and the report looks fine but says something else.
Pivotdrill gives these a level of their own, with exercises where only one option produces the expected table. After four of them the question of which total to divide by answers itself.
Learn pivot tables by getting them wrong first
A hint is one click away, but the worked setup opens only after your second attempt. That is on purpose. Building a pivot, seeing the numbers come out wrong, reading the hint and moving the field yourself is the part that sticks. Copying a solution before you have tried does not.
Every exercise also explains the idea behind it: why Rows decide the groups and Values decide the calculation, why a subtotal for averages is not the average of the averages, why a report filter keeps the table small.
Excel pivot table test practice for interviews and skills checks
Analyst, operations and finance roles often include a short Excel assessment, and pivot tables are a standard part of it: summarize this data by month, show each region's share, find the top rep. The questions are not hard once you have built a few dozen pivots. They are hard the first time, with a clock running.
Pivotdrill's timed mode puts a clock on each exercise with hints and solutions locked until time is up, so you get used to building under pressure. Run through the first four levels the week before an assessment and the test will feel like one more drill.
Try a timed exercise
Why hands-on beats watching
You can watch a ten-minute video on pivot tables and feel like you understand them. Then you open a dataset, click Insert PivotTable and stop at the empty field list. The gap between recognizing and producing is the whole problem, and the only thing that closes it is reps.
A Pivotdrill session is five to fifteen minutes of building pivots, each one slightly different from the last. Ten sessions in, the four areas, the calculations and the date grouping are automatic.
Pivot table exercises for beginners and for daily Excel users
If you have never built a pivot table, the Basics level starts with one field in Rows and one in Values and does not assume anything. If you already use pivots every day, skip to Show values as or Real work and look for the gaps: most experienced users have one option they have always avoided, and the drills find it quickly.
Every exercise is independent, so you can jump to the one you need for today's report and come back to the rest later.
Pivotdrill
