1. Select your data range (including headers).
2. Go to the Insert tab.
3. Click PivotTable.
4. Choose where to place the Pivot Table (new or existing sheet).
5. Click OK.
6. Drag fields into Rows, Columns, and Values areas.
7. Customize as needed.