Select the data range
Go to the Insert tab
Click PivotTable
Choose the table or range
Select where to place the PivotTable
Click OK
Drag fields to Rows
Drag fields to Columns
Drag fields to Values
Drag fields to Filters if needed
Adjust value settings if needed
Format the PivotTable if needed
