20 AI prompts that turn Excel into a power tool

Picture this. It’s a Tuesday afternoon and someone on the team is still hand-typing a VLOOKUP for the fourth time, squinting at two columns that refuse to line up. Meanwhile, an AI assistant sits one tab over, completely idle. That gap is exactly what caught my eye in a sharp LinkedIn post I came across recently.

The author makes a simple, almost uncomfortable point: most people are still doing Excel manually while AI sits right there, unused. Founders burning hours on lookups. Ops teams flagging duplicate entries by hand. Someone re-typing names just to merge two columns. According to this savvy professional, none of that needs to happen anymore.

I was genuinely nodding along when I read it, because I’ve watched people do all three.

Why this shift matters

The original poster frames it as a real change in what the job actually is. 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 a single prompt does what used to eat a full afternoon. As the expert puts it, 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.

That line stuck with me. The person who shared this isn’t saying spreadsheets are dead. They’re saying the leverage moved. The people who win now are the ones who know what to ask for.

The 20 prompts the author put together

To make the point practical, this contributor assembled 20 prompts that turn Excel into an AI-powered tool. I’ve laid them out below with a quick note on what each one actually saves you, so you can spot the ones that match your own messy spreadsheets.

1. Regional revenue totals: add up sales by region in one prompt instead of building nested SUMIFs.
2. Find and highlight duplicates: surface repeated entries automatically before they skew your numbers.
3. Merge first and last names: combine two columns into one clean field without retyping anything.
4. Business days between dates: count working days while excluding weekends and holidays.
5. Standardize messy text: fix inconsistent capitalization and spacing across a whole column instantly.
6. Peak sales months per product: spot the strongest month for each item without eyeballing the data.
7. Letter grades with nested IF logic: assign A through F bands without hand-writing the IF chain yourself.
8. Split dates into parts: pull the day, month, and year out of any date field.
9. Clean up formula errors: replace those ugly error cells with clean, usable values.
10. VLOOKUP or INDEX MATCH across sheets: connect data between tabs without wrestling the syntax.
11. Self-updating running total: build a cumulative sum that recalculates as new rows come in.
12. Count keyword mentions: tally how often a word shows up inside longer text strings.
13. Extract domains from emails: pull the part after the @ from a full list of addresses.
14. Fix text-stored numbers: convert numbers trapped as text into real numbers you can calculate on.
15. Compound interest in one formula: run the whole calculation without setting up a manual schedule.
16. Rank without re-sorting: score data by position while leaving the original order untouched.
17. Flag outliers by percentage: mark values that fall outside a threshold you set.
18. Split full addresses: break a single address field into clean street, city, and state columns.
19. Weighted average across criteria: blend multiple factors into one score with proper weighting.
20. Pull exact pivot values: grab a specific number straight out of a pivot table with GETPIVOTDATA.

What I’d actually do with this

Here’s my honest take. You don’t need all 20 on day one. Pick the one chore that annoys you most this week and let AI write that formula for you. For a lot of ops folks, that’s the duplicate finder or the messy-text cleaner. For finance types, it’s the weighted average or the compound interest one.

The mind behind this post said something that I think is the real lesson: none of this is complicated once you know what to ask for. The formulas were always the hard part. Now the hard part is describing what you want in plain language, and that’s a skill anyone can pick up fast.

A quick tip from watching people try this: be specific in your prompt. Tell the AI your column letters, your date format, and what a “good” result looks like. Vague requests get vague formulas. Clear requests get something you can paste straight in.

The takeaway

I love finding posts like this because they reframe a boring task into a genuine advantage. The creator isn’t selling magic. They’re pointing at a tool most of us already have open and saying, use it better.

If you’ve been grinding through spreadsheets the slow way, this is your nudge to try one prompt today. Check out the full LinkedIn post from the original author for the complete breakdown, then send it to the teammate still doing it by hand. Which one are you trying first?