📊 Excel
beginner
⏱ 10 min
Build a pivot table by describing it in plain English
Tell AI exactly what insight you need from your data and get step-by-step pivot table instructions — no more guessing which fields go where.
Tools used:
ChatGPT
Microsoft Excel
Step-by-step walkthrough
-
1
Describe your dataset
Tell the AI what columns your spreadsheet has and what question you are trying to answer.
💬 Prompt to use:My spreadsheet has columns: Date, Region, Salesperson, Product, Revenue, Units Sold. I want to see total Revenue by Region and by Product for Q1 only.
-
2
Follow the setup instructions
The AI will tell you exactly which field to put in Rows, Columns, Values, and Filters. Follow each step.
-
3
Apply a filter
Use the Date filter in the pivot table to limit results to Q1 (Jan–Mar).
-
4
Format the output
Ask the AI: "How do I format the Values column as currency?" and follow the instructions.
💡 Pro tip: Ask it to also suggest a chart type that best visualizes this pivot data.