Select the sheet with the data you want to analyze. Select Insert > PivotTable. In the Create PivotTable dialogue, in the Table/Range field, select the range of data you want to analyze.

A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways. You can basically pick different fields from your spreadsheet, create a separate table out ...