To turn your big data set into a PivotTable, select any cell in the range, and in the Insert tab on the ribbon, click the top ...

Tip: If Excel has trouble understanding elements of your data set — for example, failing to recognize column headers as such — try converting your data to table format first.