Pivot Tables 1

A PivotTable summarises a table in seconds: pick a field for Rows (what to group by) and a field for Values (what to add up, count or average). Click inside your data, open PivotTable, choose the fields and where to put it.