PivotTables: practice exercises
PivotTables summarize thousands of rows in a few clicks, and the only way to get comfortable with them is to build several. These exercises ask you to place fields in rows, columns and values, switch between sum, count and average, and produce cross-tab reports from a sales table. The checker compares your pivot with the expected totals, so you learn to spot a wrong field or aggregate quickly. Short, focused and very practical.
16 exercises · level: Confident User
Showing 16 of 16
PivotTables
Build a PivotTable: the sum of sales by rep, with the result in F1.
Build a second PivotTable: the average deal amount by city, with the result in F8.
Build a PivotTable in F1: cities in rows, products in columns, the number of deals.
Build a PivotTable in E1: the sum of sales by month (dates grouped by month).
Build a PivotTable in E10 by quarter, with the values shown as "% of grand total".
Build a PivotTable in H5: the share of each channel in sales (% of grand total).
Check the PivotTable with a formula: in H2, calculate the March sales using SUMIFS and DATE.
Build a PivotTable: the sum of sales by destination. Location: F1 (the window suggests it).
Build a second PivotTable: the average sale of each agent. Location: F9.
Build a cross-tab PivotTable in I1: destinations in rows, tour types in columns, the number of sales.
In I15, use a formula to find the name of the top destination in the first PivotTable.
Calculations and Visualization
Build a PivotTable in F1 by category with a calculated field "Average price" = Revenue / Qty.
Build a PivotTable in F7: the sum of revenue by category for the "Online" channel only.
Check the PivotTable with a formula: in I8, calculate the online revenue of the category in F8 using SUMIFS.
Build a PivotTable in F1: the sum of revenue by category.
Build a column chart from the PivotTable without the "Grand Total" row: F1:G4.
No exercises match these filters.