ChatGPT Prompts for Learning Excel (That Work)

The short version: ChatGPT is a brilliant Excel tutor if you prompt it with your actual data problem rather than asking it to "teach me Excel", because specific prompts get specific formulas while vague ones get generic waffle. Below are the exact prompts I'd use for formulas, pivot tables, VBA and troubleshooting, plus a worked example showing the difference between a weak prompt and a strong one.

Why most people prompt ChatGPT for Excel badly

Here's what nobody tells you: typing "teach me Excel" into ChatGPT is a waste of your time. You'll get a bullet list covering SUM, VLOOKUP and conditional formatting, which is the Excel equivalent of someone explaining how to drive by listing the parts of a car. You already know Excel exists. What you need is Excel applied to your mess of a spreadsheet, right now, with your column headers and your actual numbers.

The fix is embarrassingly simple: paste your real problem in. Not "how do pivot tables work" but "I have a spreadsheet with columns Date, Region, Rep Name and Sales Value, 4,000 rows, and I want to see total sales by region per month, what pivot table setup do I need and what do I put in each box." That prompt gets you an answer you can use in the next two minutes.

Formula prompts that teach you something

Use these as templates, swapping in your own column names and goal:

• "I have data in columns A to F with headers Order ID, Customer, Product, Quantity, Price, Date. Write a formula to calculate total revenue per customer and explain each part of the formula in plain English."
• "Explain the difference between VLOOKUP, INDEX MATCH and XLOOKUP using this scenario: I need to pull a customer's phone number from a separate sheet based on their account number. Give me the formula for all three and tell me which one I should use and why."
• "I keep getting a #N/A error with this formula: [paste your formula]. Walk through what's causing it step by step, don't just give me the fix."
• "Write a formula using IF and AND that flags any row where Quantity is over 100 and Price is under £5, and explain how to adjust the thresholds myself."

Notice the pattern: every prompt names real column headers, a real goal, and asks for an explanation alongside the answer. That last bit matters more than people think. If you only ask for the formula, you'll copy it in, it'll work, and you'll have learned nothing. Asking "explain each part" forces ChatGPT to teach rather than just solve, which is the whole point if you're trying to get better at Excel rather than just finish one task.

A worked example: turning a vague ask into a usable one

Say you run a small online shop and you've exported a year of orders into Excel: 3,200 rows, columns for Order Date, Customer Email, Product Category, Order Value, and Shipping Country. A weak prompt would be "help me analyse my sales data." You'll get back a generic paragraph about pivot tables and charts that doesn't touch your spreadsheet.

A strong prompt looks like this: "I have an Excel sheet with 3,200 rows, columns Order Date, Customer Email, Product Category, Order Value, Shipping Country. I want to build a pivot table showing total Order Value by Product Category, broken down by month, with Shipping Country as a filter. Tell me exactly what to drag into Rows, Columns, Values and Filters in the PivotTable Fields pane, and what to do if my Order Date column is showing as text instead of a date."

That second prompt gets you a step-by-step answer naming the actual fields, plus it pre-empts the single most common pivot table failure: dates stored as text, which silently breaks grouping by month and is the reason half the "my pivot table isn't working" questions online exist in the first place. ChatGPT can't see your spreadsheet, so the detail you put in is the detail you get back.

Pivot tables, step by step

If pivot tables are new to you, this is the prompt sequence that works better than any tutorial video:

1. "I've never built a pivot table. Using a sales dataset with Date, Region, Product and Revenue columns, explain step by step how to insert a pivot table in Excel, including which menu to use."
2. "Now explain the difference between putting a field in Rows versus Values versus Filters, using the same dataset."
3. "My pivot table shows 'Sum of Revenue' but I want it to show percentage of total instead. How do I change that calculation?"
4. "How do I add a slicer so I can filter the pivot table by Region with a single click, instead of using the dropdown filter?"

Four prompts, each building on the last. That's closer to how a decent in-person lesson works, and it's a lot more useful than one giant "explain pivot tables" prompt that tries to cover everything at once and ends up teaching nothing.

VBA and macros without the panic

VBA is where most Excel users give up, because the error messages are unhelpful and the syntax looks nothing like a formula. ChatGPT is good here because it can explain line by line what a macro does, which almost nobody does for you on a forum.

• "Write a macro that goes through column C and deletes any row where the value is blank. Explain what each line of the code does."
• "I recorded a macro using the Macro Recorder and this is the code it gave me: [paste code]. Clean it up and explain which parts are unnecessary."
• "I want a macro that runs automatically every time I open the workbook and refreshes all pivot tables. Where do I put this code and what is the Workbook_Open event?"

One uncomfortable truth worth saying plainly: ChatGPT will sometimes write VBA that looks correct, runs without errors, and still gives you the wrong numbers, because it can't see your actual workbook and doesn't know your sheet names or your data quirks. Always test any macro on a copy of your file first, never your original, and check the output against a manual calculation on a small sample before you trust it on the whole sheet. That's not a ChatGPT weakness specifically, it's true of any code you didn't write yourself, but people trust AI-generated formulas more than they should simply because the explanation sounds confident.

Prompts for troubleshooting and speed

A lot of Excel learning isn't new skills, it's fixing the daily friction that eats time:

• "My spreadsheet has 50,000 rows and is running slowly every time I make a change. What are the most common causes and how do I check for them?"
• "I need to clean a column of customer names that has inconsistent capitalisation and extra spaces. Give me a formula to fix it and explain what each function does."
• "Explain how to use Conditional Formatting to highlight duplicate values in column B, and how that's different from using the COUNTIF formula to find duplicates."
• "I have data split across three sheets with the same columns. What's the cleanest way to combine them into one sheet, and what are the risks of doing it wrong?"

These are the real questions people ask on forums at 11pm on a Sunday, and ChatGPT answers them faster than scrolling through a ten-year-old thread full of Excel 2010 screenshots that don't match your version.

Building this into an actual learning habit

The mistake people make is treating this as a one-off homework session instead of a standing habit. If you want to get better at Excel rather than just solve today's problem, set yourself a rule: every time a formula or pivot table does something you don't fully understand, ask ChatGPT to explain it before moving on, even if the result already looks right. That five-minute habit, repeated over a few weeks, teaches you more Excel than any course, because every explanation is tied to a problem you had, which is also exactly how beginner-friendly ChatGPT prompts work best across any skill, not just spreadsheets.

If you're trying to build out a wider study routine around Excel certifications or exams, the same prompting logic applies, and it's worth looking at how ChatGPT prompts for exam revision and study plans are structured, because spaced, specific prompts beat one big "explain everything" request every time. Teachers building Excel into their curriculum might also find it quicker to adapt some of the prompts teachers use to save marking time, since a lot of the structure transfers directly to marking spreadsheet-based coursework.

Worth saying too: don't bother hunting for so-called jailbreak prompts promising to open up some secret "advanced Excel mode" in ChatGPT. There isn't one. The reasons to avoid jailbreak prompts apply here exactly as they do everywhere else: you're not missing a hidden feature, you're just not prompting specifically enough yet.

For businesses, this same skill set scales up. If you're using Excel as part of a wider push on reporting, forecasting or client-facing documents, the prompting approach is identical to what works for using ChatGPT for business development, which is to say: specific data in, specific answer out, every time.

If your Excel problems are really a symptom of a bigger gap in how your team uses AI day to day, that's usually when it's worth getting outside input rather than muddling through with prompts alone, and that's exactly where working with an AI consultant for small business tends to pay for itself.

Frequently asked questions

Can ChatGPT teach me Excel from scratch?

Yes, but only if you give it real data and a real goal rather than asking it to explain Excel in general, because specific prompts produce usable formulas while vague ones produce generic tutorials you could find on any blog.

Is ChatGPT reliable for writing VBA macros?

It's a good starting point but not a guaranteed-correct one, since it can't see your workbook, so always test macros on a copy of your file and check the output manually before trusting them on live data.

What's the best ChatGPT prompt for learning pivot tables?

Give it your actual column headers and ask it to name exactly what goes into Rows, Columns, Values and Filters for your specific goal, then ask follow-up prompts about calculations and slicers rather than one giant explain-everything request.

Why does ChatGPT sometimes give me a formula that doesn't work?

Usually because it's guessing at your data format, most often dates or numbers stored as text, so always mention your column types and paste the exact error message rather than just the formula.