PivotTables

Summarise larger datasets quickly by category, time, or owner.

Practical example

Rows: Region · Values: Sum of Revenue

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.