How To Make A Pivot Table In Excel?

Select the data range, including 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

Format the PivotTable as desired

Refresh the PivotTable when the source data changes