# How to Create a Pivot Table in MS Excel

> To create a PivotTable in Excel, select your table cells, choose PivotTable or Recommended PivotTables under Insert, and click OK. Next, add your desired fields, drag them to organize the areas as needed, review the table, and begin analyzing your data efficiently.

Canonical: https://livedemo.ai/tutorials/how-to-create-a-pivot-table-in-ms-excel/
Apps: Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3797ab56e05a00fdd134/preview?step=1

## Steps

1. Select the cells in your table or range.
2. Click Insert , then select PivotTable or Recommended PivotTables .
3. Decide where you want the PivotTable to appear, then click OK.
4. Add the desired fields to your PivotTable.
5. Drag fields to different areas to organize them as needed.
6. Review your PivotTable and start analyzing your data efficiently!