PivotTable

Pivot Table Exercises (Drill)

Build and summarize pivot tables in a virtual Excel in your browser. Just like the real thing, insert a PivotTable and drag fields to Rows, Columns, and Values in the field list on the right. Practice on a computer.

Read "How to Create a Pivot Table" first →

Cleared 0 / 9

  1. 1Create a PivotTable
  2. 2Add Branch to Columns for a cross-tab
  3. 3Switch from sum to count
  4. 4Show the average per item with separators
  5. 5Sort by amount, largest first
  6. 6Group dates by month
  7. 7Filter to New York with a slicer
  8. 8Reflect a source data fix
  9. 9Build a sales table by branch and month