PivotTables are a great way to summarize, analyze, explore, and present your data, and you can create them with just a few clicks.
-
Start by selecting any cell within your data range.
-
To create a PivotTable, go to Insert > Recommended PivotTables.
Where is it?
-
For this exercise, select the first recommended PivotTable, then click OK.
Copy (Ctrl+C) and paste (Ctrl+V) this data to Excel.
Month |
Category |
Amount |
Purchaser |
January |
Transportation |
$74.12 |
Mom |
January |
Grocery |
$235.23 |
Mom |
January |
Household |
$175.08 |
Dad |
January |
Entertainment |
$100.03 |
Mom |
February |
Transportation |
$115.68 |
Mom |
February |
Grocery |
$240.62 |
Dad |
February |
Household |
$225.17 |
Mom |
February |
Entertainment |
$125.94 |
Dad |
March |
Transportation |
$90.76 |
Mom |
March |
Grocery |
$260.53 |
Dad |
March |
Household |
$200.13 |
Mom |
March |
Entertainment |
$120.48 |
Dad |