The 4 Levels of Excel Mastery With AI

Raise your hand if you’ve ever lost an afternoon copying formulas off a YouTube tutorial, only to break the whole spreadsheet with one wrong cell reference. I’ve been there, and it’s painful. So when I stumbled onto a post from this LinkedIn creator laying out how to climb all four levels of Excel mastery in a single day, I had to stop scrolling and read every word.

The expert behind it breaks spreadsheet work into four clear stages, each with its own AI tool and its own job. What I love is that it’s not theory. It’s a practical ladder you can actually climb, even if you still build every sheet by hand today. Let me walk you through what the author shared.

✦ Level 1: Let AI build it for you

This first stage is about generating a spreadsheet from scratch. The original poster recommends using Claude’s Cowork feature, picking a strong reasoning model, and connecting your Google Drive so the AI can pull real data. Here’s the step-by-step the author lays out:

1. Install the Claude app and open the Cowork tab.
2. Select the Opus model with Adaptive Thinking turned on.
3. Connect Google Drive through Connectors so your files are in reach.
4. Stop describing your spreadsheet in three vague words.
5. Feed it a detailed, structured prompt instead.

That last step is the whole game. The creator’s point is sharp: most people type “make me a budget tracker” and stop there. According to this professional, that lazy ask leaves about 90% of the AI’s potential output sitting on the table.

Here’s the exact prompt template the author shared, which you can copy and adapt:

Create an Excel spreadsheet from [DATA]. Purpose: [who uses it, what decision, 1 sentence]. Sheets needed: [name + columns + formulas]. Formatting: [currency, dates, frozen rows, totals]. List your top 10 assumptions, then execute.

The rationale is simple. The more context you hand the AI up front, the closer the first draft lands to what you actually need. Specificity is the difference between a toy and a tool.

✦ Level 2: Edit with AI inside Google Sheets

Once your file exists, the second level is about editing it without touching a single cell manually. This industry pro suggests bringing AI directly into Google Sheets. Here’s the process:

1. Open your file in Google Sheets.
2. Go to Extensions, then Add-ons, then Get add-ons.
3. Install the official ChatGPT add-on from OpenAI, which is free.
4. Connect it and select the heavier, more capable model.
5. Tag your tabs with an @ symbol and give one-line commands.

The creator gives a few real examples of how this looks in practice:

• “Visualize @ Revenue as a stacked bar.”
• “Summarize @ Funnel in 5 bullets.”
• “In @ Assumptions, push Bull more optimistic.”

The rationale here is speed. The mind behind this post calls it the end of manual editing. Your changes become one line plus a tag, the way a senior analyst would direct a junior. No more clicking through menus for twenty minutes.

✦ Level 3: Iterate like a pro

Level three is where you go back to Claude’s Cowork for anything structural, the bigger changes that reshape the whole model. The author lists the kinds of requests that fit here:

• “Add a Dashboard tab with KPI tiles.”
• “Add Base / Bull / Bear scenarios.”
• “Add conditional formatting on margin %.”

Then comes the line the expert calls the real separator between amateurs and pros. Before any big build, you tell the AI:

List your top 10 assumptions before executing.

I think this is the smartest tip in the whole post. The reasoning is that one sentence forces the AI to show its thinking before it commits. It turns a blind guess into an actual model you can stress-test. You catch flawed logic before it gets baked into your decisions, not after.

✦ Level 4: Pick the right tool for the job

The final level isn’t about a new trick. It’s about knowing which AI to reach for. This is where, as the creator puts it, you become the person who decides which AI builds what. Here’s the tool map the author shared:

• Claude Cowork: best for creating a spreadsheet from scratch.
• ChatGPT in Sheets: best for editing files that already exist.
• Codex by OpenAI: high quality output, though it burns through tokens fast.
• Shortcut.ai: a spreadsheet-only AI where you can set Claude as the model. Worth it if Excel is your full-time job.

The takeaway from this contributor is that no single tool wins everything. The skill is matching the tool to the task: build, edit, iterate, decide.

Why this ladder works

What struck me most is the before-and-after the original poster paints. On Saturday, you’re hunting for formulas on YouTube. By Sunday, the AI is building your model, your scenarios, and your dashboard, while you simply choose the right tool. That’s all four levels, in a single day.

The bigger trend here is real. Spreadsheet work is shifting from manual labor to direction and judgment. The people who win aren’t the ones memorizing formula syntax anymore. They’re the ones who know how to prompt clearly, demand assumptions before execution, and pick the sharpest tool for each step.

If you want the full breakdown with every example, go check out the original LinkedIn post from this creator. It’s worth the read, and it might just change how you build your next spreadsheet.