If you work with Excel regularly, you already know it can do incredible things — but getting it to do those things often requires deep knowledge of formulas, pivot tables, VBA, and more. What if you had an AI assistant that could handle the heavy lifting for you?

That is exactly what ChatGPT can do. By combining the power of AI with Excel, you can dramatically cut the time you spend on repetitive tasks, complex formulas, and data analysis. Here are five ChatGPT prompts that will change the way you work with spreadsheets forever.

1. The Formula Builder Prompt

The Prompt: “I have an Excel spreadsheet with [describe your columns]. I need a formula that [describe what you want to calculate]. Please write the Excel formula and explain how it works step by step.”

This is probably the single most useful way to use ChatGPT with Excel. Instead of searching Google for 30 minutes trying to piece together a nested IF statement or a complex VLOOKUP, just describe what you need in plain English. ChatGPT will write the formula and walk you through every piece of it.

Real-world example: Say you have a sales report with columns for Region, Product, Revenue, and Date. You need a formula that calculates total revenue for the East region in Q1 only. ChatGPT will hand you a SUMIFS formula tailored to your exact column layout — no guesswork required.

This approach works beautifully for INDEX/MATCH combinations, array formulas, conditional formatting rules, and even the newer dynamic array functions like FILTER and UNIQUE.

2. The Data Cleaning Prompt

The Prompt: “I have messy data in Excel with [describe the problems — duplicates, inconsistent formatting, extra spaces, mixed date formats, etc.]. Give me a step-by-step process to clean this data, including any formulas or Power Query steps I should use.”

Dirty data is the number one productivity killer in Excel. Names spelled differently, dates in three different formats, trailing spaces that break your VLOOKUP — sound familiar? ChatGPT can give you a custom cleaning plan that addresses your specific data issues.

You will get targeted advice on using TRIM, CLEAN, PROPER, and SUBSTITUTE functions. If your dataset is large, ChatGPT can also walk you through Power Query transformations that handle the cleanup automatically and repeatably every time you refresh.

3. The Dashboard Design Prompt

The Prompt: “I want to create a professional dashboard in Excel that shows [describe your KPIs and metrics]. I have data in [describe your data structure]. Give me a complete plan including which chart types to use, how to set up the layout, and any formulas I need for summary calculations.”

Building a dashboard from scratch can feel overwhelming. ChatGPT acts like a dashboard consultant — it will recommend the right chart types for your data (bar charts for comparisons, line charts for trends, KPI cards for headline numbers), suggest a logical layout, and provide the summary formulas you need to power each visual.

The key is being specific about your audience. Tell ChatGPT whether this dashboard is for your CEO, your sales team, or your own personal tracking. The recommendations will change based on who is looking at the data and what decisions they need to make.

4. The VBA Macro Generator Prompt

The Prompt: “Write a VBA macro for Excel that [describe the task you want to automate]. The macro should work on [describe your worksheet setup]. Include comments explaining each section of the code.”

VBA is incredibly powerful, but most people never learn it because the syntax feels intimidating. ChatGPT removes that barrier entirely. Describe what you want to automate in everyday language, and ChatGPT will write the VBA code with clear comments so you can understand what each line does.

Some of the most popular automation tasks include: formatting reports automatically, sending emails from Excel based on cell values, consolidating data from multiple worksheets, and creating custom data entry forms. Each of these would take hours to code from scratch — ChatGPT can generate a working starting point in seconds.

Pro tip: Always ask ChatGPT to include error handling in the macro. Add “Include error handling so the macro fails gracefully” to your prompt, and you will get much more robust code.

5. The Data Analysis and Trend Prompt

The Prompt: “I have a dataset in Excel with [describe columns and rows]. Analyze this data and tell me: What are the key trends? Are there any outliers? What insights would be most valuable for [your business context]? Suggest pivot table configurations and charts that would reveal these patterns.”

This prompt turns ChatGPT into your personal data analyst. Copy and paste a sample of your data (or describe its structure), and ChatGPT will suggest specific pivot table configurations, point out patterns you might miss, and recommend the visualizations that will tell the clearest story.

For example, if you share monthly sales data, ChatGPT might identify seasonal patterns, flag months with unusual drops, suggest year-over-year comparisons, and recommend a specific pivot table layout that groups data by quarter and region. It is like having a business analyst on call 24/7.

Bonus Tips for Getting Better Results

To get the most out of these prompts, keep these principles in mind. First, always include context about your data — column names, sample values, and the business purpose behind your question. Second, ask ChatGPT to explain its reasoning so you actually learn as you go. Third, iterate — if the first answer is not quite right, refine your prompt and ask again.

The combination of ChatGPT and Excel is one of the most practical AI use cases available today. You do not need to be a programmer or a data scientist. You just need to know how to describe what you want.

Ready to Level Up Your Excel Skills?

If you want to go deeper and see these techniques in action with live demonstrations, check out our upcoming webinars at pcwebinars.com. We offer live training sessions on Excel, ChatGPT, Claude, CoPilot, Power BI, and more — designed specifically for busy professionals who want to work smarter, not harder.

Browse our upcoming sessions and register today at pcwebinars.com.

5 ChatGPT Prompts That Will Transform How You Use Excel