Summarize a large list: group by a field and calculate sums and counts without formulas.
What a PivotTable is and how it works
PivotTable: the idea and the four areas
A PivotTable is a tool that automatically builds totals from a large flat list. You don't need to write formulas like SUMIF for each group — just drag fields into the right areas, and Excel calculates sums, counts, or averages for you.
The four areas of a PivotTable: “Rows” — the field you group the data by (for example, manager); “Columns” — an extra dimension (for example, month); “Values” — what you calculate (total sales, number of deals, average); “Filters” — filters the whole table by one field (for example, just one region). The same data set produces completely different summaries depending on which fields go where.
Source data requirements: a single flat list with a header row (column names), no blank rows, and no merged cells. A blank row inside the table breaks the range — the PivotTable won't pick up the data below it. A standard scenario: you have a table with Manager, Month, and Amount columns — you build a PivotTable to see each manager's total sales broken down by month in seconds.
Lesson notes
PivotTable: the idea and the four areas
A PivotTable is a tool that automatically builds totals from a large flat list. You don't need to write formulas like SUMIF for each group — just drag fields into the right areas, and Excel calculates sums, counts, or averages for you.
The four areas of a PivotTable: “Rows” — the field you group the data by (for example, manager); “Columns” — an extra dimension (for example, month); “Values” — what you calculate (total sales, number of deals, average); “Filters” — filters the whole table by one field (for example, just one region). The same data set produces completely different summaries depending on which fields go where.
Source data requirements: a single flat list with a header row (column names), no blank rows, and no merged cells. A blank row inside the table breaks the range — the PivotTable won't pick up the data below it. A standard scenario: you have a table with Manager, Month, and Amount columns — you build a PivotTable to see each manager's total sales broken down by month in seconds.