Select the data range you want to analyze
Make sure the data has clear column headers
Go to the Insert tab
Click PivotTable
Choose the table or range
Select where to place the PivotTable
Click OK
In the PivotTable Fields pane, drag fields to Rows, Columns, Values, and Filters
Adjust the value calculation if needed
Sort, filter, and format the PivotTable as required
Refresh the PivotTable when the source data changes