How To Create Pivot Table In Excel?

Select the data range

Go to the Insert tab

Click PivotTable

Choose the table or range

Select where to place the PivotTable

Click OK

Drag fields to Rows

Drag fields to Columns

Drag fields to Values

Drag fields to Filters if needed

Adjust value settings if needed

Format the PivotTable if needed

Suggested for You

Trending Today