Select your data range
Make sure your data has headers
Click the Insert tab
Click 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 after data changes
Format the PivotTable if needed