To make a pivot table in Excel, follow these steps:
- Select your data
Click any single cell inside the data range or table you want to analyze. Make sure your data has clear headers and no blank rows or columns
- Insert the PivotTable
Go to the Insert tab on the Excel ribbon, then click PivotTable in the Tables group. This opens the Create PivotTable dialog box where Excel automatically selects your data range
- Choose the location for the PivotTable
Decide whether to place the pivot table in a New Worksheet (recommended for clarity) or an Existing Worksheet (you specify the location). Click OK to create a blank pivot table
-
Configure the PivotTable fields
A PivotTable Fields pane appears. Drag and drop fields into the four areas to build your table:- Filters : to filter data by a field
- Columns : to display fields as column headers
- Rows : to display fields as row labels
- Values : to summarize data (sum, count, average, etc.)
- Analyze and customize
You can sort, filter, group, and summarize the data as needed. You can also add slicers or create Pivot Charts for better visualization
Summary
- Select data
- Insert > PivotTable
- Choose location
- Drag fields to Filters, Columns, Rows, Values
- Customize and analyze
This process allows you to quickly summarize large data sets and gain insights with minimal effort
