Select your data range
Make sure the data has headers
Click the Insert tab
Select PivotTable
Choose the table or range
Choose where to place the PivotTable
Click OK
Drag fields to Rows
Drag fields to Columns
Drag fields to Values
Drag fields to Filters
Change the value summary if needed
Sort or filter the PivotTable
Refresh the PivotTable when data changes
Format the PivotTable if needed