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.