Save Hours in Excel with AI (Your Copilot Blueprint)
6 steps to transform your Excel workflow
Disclaimer
From our next newsletter, the publication name will change to Grow With AI due to confusion with other similar publications.
Nothing else changes you’ll continue to get the same value, on the same schedule, with the same AI playbooks to grow your income and audience.
Next time, the sender name will appear as Grow With AI.
That’s it, now let’s move on to this super-valuable guide we’ve prepared for you.
Excel just got a serious upgrade.
An in-cell =COPILOT() function now understands plain English—then fills cells with summaries, categories, even full tables.
Yes, it’s still rolling out, with usage caps and staged availability.
But the payoff is immediate: less grunt work, faster decisions.
In this guide, you’ll set it up and start shipping value today.
Onward to the steps →
What You’ll Learn in This Blueprint
Prep data so Copilot “gets it”
Open Copilot in chat or cells
Write formulas in plain English
Summarize and clean data fast
Get formulas explained in simple words
Turn tables into charts instantly
Respect limits and avoid pitfalls
Make reports repeatable with Copilot
Bonus: Copy-paste prompt pack
Note: Google Sheets alternatives
Getting Started
Why this matters: You’ll turn messy sheets into clean insights without learning gnarly formulas.
What you need
Excel with the new
=COPILOT()function (rolling out to recent Windows and Mac builds) or access to the Copilot chat sidebar.A Copilot plan: Microsoft 365 Copilot (org add‑on) or Copilot Pro (individuals).
Tip: You can use the chat sidebar for explain‑this‑formula, quick summaries, and chart suggestions while the in‑cell function rolls out.
▸ Step 1: Prep your data so Copilot “gets it”
Why: Clear structure = better AI results.
Convert your range to an Excel Table (Ctrl/Cmd + T).
Keep headers simple (Customer, Date, Region, Amount).
Avoid merged cells and mixed data types.
Pro Tip: Newer context awareness can infer likely ranges—but neat tables still produce cleaner output.
Done! You’ve set Copilot up for accuracy.
▸ Step 2: Open Copilot where you work
Why: You’ll use both chat and formulas.
Click the Copilot icon on the Home ribbon to open the sidebar.
Or write the in‑cell
=COPILOT()formula when you want results to live in cells and recalc with the sheet.
Done! You can now choose chat or in‑cell prompts.
▸ Step 3: Turn plain English into formulas (cell by cell)
Why: Skip syntax hunting—describe the outcome.
Paste this into a new column (adjust the range to your sheet):
=COPILOT("Classify each feedback as Positive, Neutral, or Negative.
Return just one of those words.", D4:D200)Works like a normal formula; recalculates with data changes.
Combine with
IF,SWITCH,LAMBDA, orWRAPROWSfor post‑processing.
Pitfall: The function can’t pull web/external systems it uses only your workbook and referenced ranges.
Done! You just automated a tedious column.
▸ Step 4: Summarize and clean data in one pass
Why: Fast insights beat manual wrangling.
Use the function or the sidebar with simple, direct prompts:
“Summarize sales by region for Q2 and list top 3 trends.”
“Standardize all dates to YYYY‑MM‑DD in this range.”
“Find duplicate customer names and suggest merges.”Pro Tip: Clean one column at a time, confirm, then apply across the sheet.
Done! Your sheet is readable and analysis‑ready.
▸ Step 5: Ask for formulas—then learn them
Why: Move faster today and smarter tomorrow.
In the sidebar:
“Explain the formula in B2 in plain English. What does each part do?”
“Suggest a formula to calculate month‑over‑month customer churn from this table.”Copilot can explain and draft formulas referencing your grid. On the web, you can also type = and ask in natural language to generate a formula from the grid.
Done! You learned while shipping work.
▸ Step 6: Visualize instantly (charts, pivots, highlights)
Why: Polished output sells your insights.
Ask:
Keep reading with a 7-day free trial
Subscribe to Grow With AI 📈 to keep reading this post and get 7 days of free access to the full post archives.