skill~120 mindifficulty

PivotTables & Summarization

PivotTables let you summarize thousands of rows into an answer in seconds without writing a single formula.

1

Learn it

A PivotTable drags fields into Rows, Columns, Values, and Filters to compute grouped aggregates (counts, sums, averages) on the fly. It is the spreadsheet equivalent of SQL's GROUP BY. Learning which field belongs in which area is how you reshape raw records into a summary that answers a business question.

By the end you’ll be able to

  • Build a PivotTable to aggregate by category
  • Slice a summary across two dimensions

Free resources

2

Practice

Take a sales table and build a PivotTable of total revenue by region and month, then add a filter by product category.

3

Build it — your output

A PivotTable (and pivot chart) summarizing a dataset across at least two dimensions.

4

Prove it — check yourself

You’re ready to move on when you can honestly say yes to each:

  • Can you place fields into Rows, Values, and Filters to get a needed summary?
  • Can you change an aggregation from sum to average or count?
  • Can you explain how a PivotTable relates to GROUP BY?

Do it with AI

Use a free AI tool as your tutor and pair-programmer. Copy a prompt below into Claude, ChatGPT, or Gemini (for building, try Cursor or Copilot).

The habit: Try it yourself first — a little struggle is where the learning actually happens. Then ask for a hint before the answer — never copy blindly.

  • Understand itClaude / ChatGPT / Gemini

    I'm a beginner learning "PivotTables & Summarization". Explain it in simple terms with a real-world analogy, then ask me ONE question to check my understanding — don't reveal the answer.

  • PracticeClaude / ChatGPT / Gemini

    Give me 3 short practice problems on "PivotTables & Summarization" (my goal: build a pivottable to aggregate by category), from easy to hard. Don't include the solutions yet — I'll try them first, then ask you to check.

  • Get unstuckClaude / ChatGPT / Gemini

    I'm stuck on this exercise about "PivotTables & Summarization": [paste your attempt here]. Give me ONE small hint to move forward — do NOT give me the full solution.

  • Build & reviewCursor / Copilot

    Here is my work for a "PivotTables & Summarization" task: [paste your code or answer]. Review it: point out what's wrong and WHY, and suggest improvements — but let me make the fixes myself.

  • Prove itClaude / ChatGPT / Gemini

    Quiz me on "PivotTables & Summarization". Ask me 5 questions one at a time, wait for my answer each time, then tell me if I'm right and briefly why.

My notes