Your first pivot table

A pivot table sums up a long list in seconds. Put a field in Rows (one line per region, say) and one in Values (what to add up). Excel sorts and totals for you.

5 exercises in this lesson are part of ExcelHero Pro.