Excel·35 min

PivotTables: summarize data without rewriting it

Build a participation summary by department and week, select the correct aggregation, and try filtering and refreshing to see how the summary responds to its source.

The ideaThe stepsThe videoPracticeQuiz
The idea1 / 13

What are we solving today?

A PivotTable groups source records by fields you choose, such as department and week, and calculates a summary without changing the original data. A reliable summary depends on source quality, aggregation type, filtering, and refreshing, not just the table's appearance.

After this stop…

Build a participation summary by department and week, select the correct aggregation, and try filtering and refreshing to see how the summary responds to its source.

One step at a time. Your progress stays on your device.