Question: do a pivot table in excel?
Answer: Click a cell in the source data or table range.
Go to Insert > Recommended PivotTable.
Excel analyzes your data and presents you with several options, like in this example using the household expense data.
Select the PivotTable that looks best to you and press OK.