100+ AI Prompts for Excel (Just Copy Paste)

Table of Contents
1. What This Lesson Is About
2. Why Most People Waste Time With AI and Excel
3. Example 1: Restaurant Manager Analyzing Weekly Sales
4. Example 2: HR Coordinator Cleaning Employee Data
5. Example 3: Student Tracking Assignment Scores
6. Anatomy of a High-Quality Excel Prompt
7. Categories of Excel Prompts That Work
8. Making Your Prompts Even Better
9. Common Prompt Patterns You'll Use Repeatedly
10. Practice Tasks
View more

What This Lesson Is About

This lesson gives you a ready-to-use collection of AI prompts designed specifically for Excel work. Instead of spending hours figuring out formulas, cleaning messy data, or building reports from scratch, you'll learn how to communicate with AI tools like ChatGPT or Claude to generate exactly what you need for your spreadsheets. These aren't theoretical prompts-they're practical, copy-paste templates you can use immediately in real work situations.

You'll see how professionals across different industries use these prompts to solve actual Excel problems faster and more accurately. By the end, you'll have a mental library of prompt patterns that work, and you'll understand what makes a prompt effective for Excel tasks.

Why Most People Waste Time With AI and Excel

Many people try using AI for Excel help but get frustrated because they ask vague questions like "help me with Excel" or "create a formula." The AI then gives generic advice or asks clarifying questions, turning a quick task into a long conversation. The secret is being specific about three things:

• Context: What your data looks like and where it is
• Goal: Exactly what result you want
• Format: How you want the solution delivered (formula, steps, VBA code, etc.)

When your prompt includes all three, AI gives you working solutions on the first try. Let's see this in action through real examples.

Example 1: Restaurant Manager Analyzing Weekly Sales

The Real Task

Maria manages a small restaurant and tracks daily sales in Excel. She has columns for Date, Day of Week, Total Sales, and Food Cost. Every Monday, she needs to calculate which day had the highest profit margin and identify trends. She's comfortable with basic Excel but finds herself manually scanning numbers and using a calculator.

The Weak Approach

Maria asks the AI: "How do I find the best day in my sales data?"

The AI responds with general questions: "What do you mean by best? Highest sales? What does your data look like?" This back-and-forth wastes time, and when she finally gets an answer, it's a generic MAX function that doesn't account for profit margin calculations.

The Correct AI-Powered Approach

Maria uses this specific prompt:

"I have an Excel sheet with these columns: A (Date), B (Day), C (Total Sales), D (Food Cost). I need a formula in column E that calculates profit margin as (Total Sales - Food Cost) / Total Sales × 100. Then I need a formula that tells me which day of the week has the highest average profit margin. My data is in rows 2 through 50."

The AI immediately provides:

1. Profit Margin Formula for E2: =((C2-D2)/C2)*100
2. Instructions: Copy this formula down to E50
3. Day Analysis Formula: =INDEX(B:B,MATCH(MAXIFS(E:E,B:B,B2:B50),E:E,0)) with explanation of how to use AVERAGEIF for each day
4. Alternative approach: Create a pivot table summary with steps

What Made the Difference

The prompt specified exact column locations, the mathematical definition of profit margin, the data range, and the two-part goal (calculate margin, then find best day). The AI didn't need to guess or ask follow-up questions. Maria got a complete, working solution in seconds.

Example 2: HR Coordinator Cleaning Employee Data

The Real Task

James works in HR and receives employee timesheets from different departments. The problem is that some departments write dates as "12/5/2024," others use "Dec 5 2024," and some even write "5-Dec-24." He needs all dates in a standard format (YYYY-MM-DD) for the payroll system. He has 300 rows of mixed-format dates in column A.

The Weak Approach

James asks: "How do I fix date formats in Excel?"

The AI gives him general advice about the Format Cells dialog and TEXT functions, but these don't work because his dates are text strings in different formats, not actual Excel date values. He tries several suggestions and nothing works. He's now considering manually retyping 300 dates.

The Correct AI-Powered Approach

James uses this detailed prompt:

"I have dates in column A (rows 2-301) in mixed text formats: some are 'MM/DD/YYYY', some are 'MMM DD YYYY', and some are 'DD-MMM-YY'. I need a formula in column B that converts all of these to YYYY-MM-DD format. If a cell can't be converted, it should show 'CHECK'. Give me a formula that handles all three formats."

The AI provides:

1. Formula for B2:
   =IFERROR(TEXT(DATEVALUE(A2),"YYYY-MM-DD"),"CHECK")
2. Explanation: DATEVALUE converts text strings to dates, TEXT reformats them, IFERROR catches any entries that can't convert
3. Additional step: Instructions to copy B2 down to B301, then copy column B and paste values to replace column A if needed
4. Alternative for stubborn formats: A Power Query approach with M code if the formula misses some formats

What Made the Difference

James specified the exact problem (mixed text formats), listed the specific format variations he's dealing with, stated the desired output format precisely, and mentioned the data range. He also asked for error handling ("CHECK" for problematic entries). The AI gave him a robust solution that handles the complexity of real-world messy data.

Example 3: Student Tracking Assignment Scores

The Real Task

Priya is a university student tracking her assignment scores across five courses. She has columns for Course Name, Assignment Name, Score (out of 100), and Weight (percentage this assignment counts toward final grade). She wants to know her current weighted average in each course and her overall GPA if A = 90+, B = 80-89, C = 70-79.

The Weak Approach

Priya asks: "Calculate my grades in Excel."

The AI asks what grading system she uses, how her data is organized, what she means by "grades," whether she wants letter grades or percentages, etc. After several messages, she gets a simple AVERAGE formula that doesn't account for weighted scores at all.

The Correct AI-Powered Approach

Priya uses this comprehensive prompt:

"I have grade data in columns A-D: Course Name (A), Assignment Name (B), Score out of 100 (C), Weight as decimal (D, like 0.15 for 15%). Data is in rows 2-30. I need: (1) A formula in column E that calculates weighted score (Score × Weight), (2) A summary table showing each unique course name and its total weighted average, (3) A formula that converts weighted averages to letter grades where A≥90, B≥80, C≥70, D≥60, F<>

The AI delivers:

1. Weighted Score formula for E2: =C2*D2
2. Summary table instructions: Create a list of unique course names in column G, then use SUMIF for each course:
   =SUMIF($A$2:$A$30,G2,$E$2:$E$30)
3. Letter Grade formula for column H:
   =IF(G2>=90,"A",IF(G2>=80,"B",IF(G2>=70,"C",IF(G2>=60,"D","F"))))
4. Verification tip: Check that weights sum to 1.0 for each course using SUMIF on column D

What Made the Difference

Priya's prompt included her data structure with column letters, explained what the decimal weights meant, broke down her need into three specific numbered requirements, and provided the exact grade thresholds. The AI understood the complete picture and delivered a multi-part solution that works together as a system.

Anatomy of a High-Quality Excel Prompt

Based on these examples, here's the template structure that consistently gets you working solutions:

1. Data Description: "I have [data type] in column [letter] from rows [start] to [end]"
2. Current State: "The data looks like [example]" or "The format is [description]"
3. Desired Outcome: "I need [specific result]"
4. Output Preference: "Give me a formula" or "Provide step-by-step instructions" or "Write VBA code"
5. Edge Cases: "If [situation], then [how to handle it]"

Not every prompt needs all five elements, but the more complex your task, the more helpful it is to include these details.

Categories of Excel Prompts That Work

Formula Generation Prompts

When you need formulas, specify the calculation logic in plain language:

• "Create a formula that calculates the number of business days between column A and column B, excluding holidays listed in sheet2 column A"
• "I need a formula that looks up the employee name in C2, finds it in the Staff table (columns F-H), and returns their department"
• "Give me a formula that counts how many times the word 'completed' appears in column D for rows where column B equals 'March'"

Data Cleaning Prompts

For messy data, describe the problem and the clean state you want:

• "Column A has phone numbers in formats like (555) 123-4567, 555-123-4567, and 5551234567. Convert all to XXX-XXX-XXXX format in column B"
• "Remove all text after the comma in column C and trim extra spaces"
• "Column E has prices like '$45.99' and '32 dollars'. Extract just the number in column F"

Analysis and Reporting Prompts

For insights and summaries, state what patterns you're looking for:

• "I have sales data with Date (A), Product (B), Quantity (C). Show me how to create a monthly summary showing total quantity per product"
• "Find the top 5 customers by total purchase value where column A is customer name and column D is purchase amount"
• "Calculate the moving 7-day average of column C (daily temperature) and put results in column D"

Automation and Macro Prompts

For repetitive tasks, describe the sequence of actions:

• "Write VBA code that copies all rows where column G equals 'Approved' from Sheet1 to Sheet2, starting at row 2 in Sheet2"
• "Create a macro that sorts my data by column B, then adds a filter to column A, then freezes the top row"
• "I need VBA that loops through column A, checks if each cell contains '@gmail.com', and highlights those cells yellow"

Making Your Prompts Even Better

Three techniques elevate good prompts to great ones:

Include a Sample

When your data structure is unusual, show a few rows:
"My data looks like this: Row 2 is 'Jan-2024 | 450 | West', Row 3 is 'Jan-2024 | 320 | East'. I need to split this into separate columns."

Request Explanations

Add "Explain how this formula works" to learn while you work:
"Give me a SUMIFS formula for this scenario and explain each argument so I can modify it later."

Ask for Alternatives

When accuracy matters, request multiple approaches:
"Show me both a formula-based solution and a pivot table approach for calculating average sales by region."

Common Prompt Patterns You'll Use Repeatedly

Here are templates you can adapt to dozens of situations:

• Conditional Calculation: "Calculate [result] in column [X] where column [Y] meets [condition]"
• Lookup and Match: "Find [value] from column [X] in [table/range] and return corresponding [value] from column [Y]"
• Date Operations: "Calculate [days/months/years] between [date column 1] and [date column 2] considering [business days/weekends/holidays]"
• Text Manipulation: "Extract [first/last/middle] [N characters/words] from column [X] into column [Y]"
• Conditional Formatting Logic: "Highlight rows where [column] is [condition] and [column] is [condition]"

Practice Tasks

Practice Task 1: Medical Office Appointment Tracking

You work at a dental clinic. Your spreadsheet has these columns: Patient Name (A), Appointment Date (B), Appointment Time (C) in format "2:30 PM", Service Type (D), and Duration in Minutes (E). You need to calculate what time each appointment ends and identify any appointments that would run past 5:00 PM. Write a prompt that would get you formulas to solve both parts of this problem.

Practice Task 2: Small Business Inventory Alert

You run an online shop and track inventory in Excel: Product Name (A), Current Stock (B), Minimum Stock Level (C), Supplier Email (D). You want to create a system that shows "REORDER" in column E when current stock falls below minimum level, and shows nothing otherwise. You also want a separate list that shows only product names that need reordering. Write a prompt that would generate both the formula and the filtered list solution.

Practice Task 3: Teacher Grade Book with Dropped Scores

You're a teacher with student names in column A and ten quiz scores in columns B through K. Your grading policy drops each student's lowest two quiz scores and averages the remaining eight. Write a prompt that would give you a formula for column L that calculates this correctly for each student.