Select the data range you want to analyze
Make sure the data has headers in the first row
Click the Insert tab
Click PivotTable
Confirm the table or range selection
Choose where to place the PivotTable
Click OK
In the PivotTable Fields pane, drag fields to Rows, Columns, Values, and Filters
Adjust value settings if needed
Use the filter and sort options to refine the results
Refresh the PivotTable when the source data changes