Select your data range, including column headers
Go to the Insert tab
Click PivotTable
Confirm the table or range
Choose where to place the PivotTable
Click OK
In the PivotTable Fields pane, drag fields to Rows, Columns, Values, and Filters
Adjust the value field settings if needed
Use the filter dropdowns to refine the results
Refresh the PivotTable when the source data changes