Course
Pivot table exercises
Ten exercises, from a simple total by region to filters, Max, averages by channel and formulas that read the pivot. Each sheet is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 10
Total sales by region
Build a PivotTable from A1:C13 that shows the total sales of each region. Select the table with its headers, click PivotTable, keep the location E1, then put Region in Rows and Sales ($) in Values.
| Region | Product | Sales ($) |
| East | Laptop | 1,200.00 |
| West | Monitor | 450.00 |
| North | Laptop | 1,350.00 |
| East | Keyboard | 80.00 |
| South | Monitor | 520.00 |
| West | Laptop | 1,180.00 |
| North | Keyboard | 95.00 |
| East | Monitor | 610.00 |
| South | Laptop | 1,250.00 |
| West | Keyboard | 110.00 |
| North | Monitor | 480.00 |
| East | Laptop | 1,300.00 |