How to Create a Pivot Table in MS Excel

Quick summary

A Pivot Table in Microsoft Excel lets you quickly summarize and analyze large datasets by grouping, sorting, and aggregating data without writing formulas. This step-by-step demo walks you through selecting your data range, inserting a PivotTable, and organizing fields to generate meaningful insights instantly.

Steps

1. Select the cells in your table or data range to define the source data for your PivotTable.
2. Click Insert, then choose PivotTable or Recommended PivotTables from the menu.
3. Decide where you want the PivotTable to appear in your workbook, then click OK.
4. Add the desired fields to your PivotTable using the field panel on the right.
5. Drag fields to different areas — Rows, Columns, Values, or Filters — to organize and structure your data as needed.
6. Review your completed PivotTable and begin analyzing your data efficiently.