Excel Roadmap
The lesson player with the free lesson Your first pivot table in the practice Excel: a pivot table of revenue by region, the PivotTable Fields pane beside it, and the lesson panel with the step "Drag Revenue into Values" checked.
How a lesson looks on a computer.

Confident · 10 min · 13 steps · checked as you go

Your first pivot table

Turn 200 rows of sales into totals by region, read the answer, and re-ask the question by rep or product.

Do this lesson on your computer.

It runs beside a practice Excel in your browser, and every step is checked as you go. Free, with no sign-up.

On your computer, go tolearnford.com/go/XDKQ

The full Excel course: 217 lessons, US$149.

Lifetime access, a practice Excel in your browser, and new lessons as we add them.

See the Excel course

In this lesson

  • Click inside the data, then Insert, then PivotTable.
  • Rows = what you group by. Values = what you add up (Sum by default for numbers).
  • Move fields in and out to ask a new question. The totals recalculate instantly.
Excel Roadmap

Not affiliated with Microsoft or Google.