How to Create a Pivot Table in MS Excel
- George Apostolov
How to Create a Pivot Table in MS Excel: step-by-step guide
Select the cells in your table or range.
Click Insert, then select PivotTable or Recommended PivotTables.
Decide where you want the PivotTable to appear, then click OK.
Add the desired fields to your PivotTable.
Drag fields to different areas to organize them as needed.
Review your PivotTable and start analyzing your data efficiently!
Quick answer: 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.
About this Excel tutorial
Quickly organize and analyze your data by creating a PivotTable in Microsoft Excel using this step-by-step guide. This guide shows how to create a Pivot Table in MS Excel in 6 steps, starting with "Select the cells in your table or range" and finishing with "Review your PivotTable and start analyzing your data efficiently!". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create a Pivot Table in MS Excel?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel. Related guides: How to Create a Power BI Report from Excel, How to create a report microsoft excel and How to Create a SharePoint List From Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
