Google Sheets Roadmap
The lesson player with the free lesson Your first pivot table in the practice Google Sheets: a pivot table of revenue by region, the Pivot table editor beside it, and the lesson panel with the step "Click Add next to Values and choose Revenue" 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 Google Sheets in your browser, and every step is checked as you go. Free, with no sign-up.

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

The full Google Sheets course: 215 lessons, US$149.

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

See the Google Sheets course

In this lesson

  • Click inside the data, then Insert, then Pivot table.
  • 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.
Google Sheets Roadmap

Not affiliated with Microsoft or Google.