An interactive hands-on Copilot lesson: it walks through four Excel workflows (formula generation, charts, data cleaning, pivot tables), showing the real prompt and result for each, and has the learner catch a formula error, build a chart prompt, and pick the safe move on the data-cleaning and pivot gotchas.
Copilot Mastery · Lesson 02 · ProStep 1 of 7 · ~14 min
Build a real dashboard in 15 minutes.
Excel is where Copilot's value really shows. Get good at four workflows — formulas, charts, data cleaning, and pivot tables — and a CFO-grade dashboard goes from a 2-hour project to a 15-minute one. All from plain English.
This is hands-on. You'll catch a formula error, build a chart prompt, and make the calls that keep your data safe. About 14 minutes.
The reframe that unlocks it
Most people prompt Copilot in Excel like a tutor: "how do I do a VLOOKUP?" That wastes it. Copilot in Excel is a fast-typing analyst who already knows Excel cold — it's there to do the work, not teach you. You bring the question and the data; it brings the execution.
Spot the move that uses it right
Which prompt actually puts Copilot to work?
01 · Formulas from plain English
Basic
Where: Highlight your range → open the Copilot panel → describe what you want. It writes the formula and explains it.
Your promptColumn A is the date, B is the salesperson, C is the amount. Add a column with each salesperson's running 30-day total.
What Copilot drops in=SUMIFS(C:C, B:B, B2, A:A, ">="&A2-29, A:A, "<="&A2)
Before you trust the whole column…
What's the right move with a Copilot-generated formula like this?
~30 min → ~60 sec per formula · the Excel power-user edge, democratized
02 · A dashboard chart in one sentence
Intermediate
Where: Copilot panel → describe the chart. It picks the type, formats it, and inserts it — no chart wizard.
A vague ask gets a vague chart. Tap each piece to build the prompt that gets the chart you actually pictured:
Your promptMake a chart of product revenue.
Specificity:
vague
What Copilot returnsThe stacked bar chart, typed and formatted, inserted in ~30 seconds.
Gotcha: Copilot's formatting is decent, not magazine-quality. For customer-facing charts, tidy labels, legend position, and colors after.
03 · Clean messy data without macros
Advanced
Where: Copilot panel → tell it what "clean" means for your data. It writes the transforms.
Your promptColumn D has dates in five formats ("3/14/26", "Mar 14 2026", "2026-03-14", "14-Mar-26", "03/14/2026"). Normalize them all to YYYY-MM-DD.
The one habit that saves you
Before running a big transformation on real data:
04 · Pivot tables on demand
Power user
Where: Copilot panel → describe the breakdown. The pivot appears, configured — no Field List wrestling.
Your promptPivot this to show total revenue by region (rows) and product line (columns), with quarter as a filter. Add a % of total column.
Quick check
Your pivots keep breaking when the source data changes shape. The fix that keeps them alive?
✓
Lesson complete
Four workflows — formulas, charts, cleaning, pivots — and the dashboard that took two hours now takes about fifteen minutes.
The 15-minute rebuild
Pick a spreadsheet you once spent 60+ minutes building — a report, tracker, or forecast. Open a blank sheet beside it and rebuild it using only these four workflows. Time it: most people land at 12–18 minutes, and the skill compounds across every Excel task after.
What you can do now
Generate any formula from plain English, build charts and pivots faster than describing them, clean messy data without macros, and spot-check for the date-logic and reshape gotchas.
Up next in Copilot Mastery
Lesson 03 · Copilot in Word — from blank page to draft in 5 prompts
Hey! I'm your AI Coach for this lesson. Ask me anything about Copilot in Excel — formulas, charts, cleaning data, pivots, or how to phrase a prompt for your own sheet. What's on your mind?
Free lesson coaching is limited to 3 questions. Upgrade to Pro for unlimited coaching on every lesson.