20 AI prompts that turn Excel into a power tool

I still remember watching a founder burn a whole afternoon on VLOOKUPs that a single prompt could’ve written in seconds. It’s painful to watch. And it happens everywhere, from ops teams manually flagging duplicates to someone re-typing names just to merge two columns.

That’s exactly the frustration this LinkedIn creator called out in a post I couldn’t stop nodding at. The author’s point is simple but sharp: most people are still doing Excel by hand while AI sits right there, unused. I was genuinely impressed by how clearly the original poster framed the shift, so I broke down the whole thing for you.

The real shift the author spotted

Spreadsheets used to run half the operation. Revenue tracking. Ranking reps. Flagging outliers before they turned into real problems. And back then, analysts wrote every single formula by hand.

Now, as this expert points out, one prompt does what used to take a full afternoon. AI doesn’t just answer questions anymore. It writes the exact formula you need, instantly. The skill isn’t Excel anymore. It’s knowing how to prompt it.

Why it matters: the person who posted this nailed the mindset change. You don’t need to memorize function syntax. You need to describe the result you want in plain English and let AI hand you the formula.

The 20 prompts the creator put together

The author assembled 20 prompts that basically turn Excel into an AI-powered tool. I’ve kept the original list intact and added a quick note on each so you know when to reach for it. Save this one. You’ll come back to it.

1. Regional revenue totals Ask AI to sum revenue by region in one prompt instead of stacking SUMIFS by hand.
2. Find and highlight duplicates Spot repeated entries automatically, so bad data never sneaks into your reports.
3. Merge first and last names Combine two columns into one clean full-name field without retyping a thing.
4. Business days only Count working days while excluding weekends and holidays, perfect for deadlines and SLAs.
5. Standardize messy text Clean up inconsistent capitalization and spacing across a column in one shot.
6. Peak sales months per product Surface each product’s best-performing month so you can plan inventory and promos.
7. Letter grades with nested IF Turn raw scores into A through F using logic AI writes for you, no bracket-counting.
8. Extract day, month, year Pull each date part into its own column for cleaner filtering and pivots.
9. Replace formula errors Swap out ugly error values for clean, presentable results automatically.
10. VLOOKUP or INDEX MATCH across sheets Match data between tabs without wrestling with reference syntax.
11. Self-updating running total Build a cumulative column that recalculates itself as new rows land.
12. Count keyword mentions Tally how often a term shows up inside longer text strings, great for feedback and reviews.
13. Extract domains from emails Strip out the part after the @ to group contacts by company fast.
14. Convert text to real numbers Fix numbers stored as text so your sums and averages finally work.
15. Compound interest in one formula Model growth over time without hunting for the right financial function.
16. Rank without re-sorting Assign rankings while leaving your original row order untouched.
17. Flag outliers by percentage Highlight values that stray past a threshold you set, before they become problems.
18. Split full addresses Break one messy address field into clean street, city, and zip columns.
19. Weighted average across criteria Blend multiple factors into a single score that reflects what actually matters.
20. Pull values with GETPIVOTDATA Grab exact figures from a pivot table without clicking around manually.

My honest take

What I love about the creator’s list is that none of it is complicated once you know what to ask for. These aren’t advanced macros. They’re everyday tasks that used to eat hours and now take a sentence.

Here’s how I’d start if I were you, borrowing the original poster’s approach:

• Pick the one task you dread most, probably duplicates or messy text.
• Describe the result you want in plain words, not Excel jargon.
• Paste the formula AI gives you and tweak the cell ranges.
• Save your favorite prompts so they become a reusable playbook.

The mind behind this post said it best: the slow way isn’t necessary anymore. Send this to the teammate still doing it by hand, and think about which prompt you’ll try first.

Check out the full LinkedIn post for the author’s complete breakdown and every prompt in context.