Question: how to do a pivot table?
Answer: Select the cells you want to create a PivotTable from. ...  Select Insert > PivotTable. Under Choose the data that you want to analyze, select Select a table or range. In Table/Range, verify the cell range.