Lesson 4 of 4 · 12 min

Pivot tables

A pivot table summarises large data sets by dragging fields into Rows, Columns, Values and Filters.

Change the Values aggregation from Sum to Count or Average to answer different questions instantly.

Practice

Pivot a sales list by region (rows) and product (columns) with total revenue as values.

Optional resources

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Practice formulas and charts in a browser spreadsheet.

Free web version · Microsoft account required; desktop features may need a paid plan.

Explore further spreadsheet and business-analysis courses.

Pricing and free access vary by course; certificates may cost extra.