My manager walked into our team meeting in March 2026 and announced that everyone’s Microsoft 365 accounts now had Copilot enabled. “It’ll save you hours,” she said, with the confidence of someone who’d read a press release. Then she looked at us and added, “IT will send a guide.” The guide never came. What followed was three weeks of people either ignoring the new Copilot button entirely, or clicking it once, getting confused by the blank prompt box, and never opening it again.
That’s the real Copilot story for most office workers right now — not that it doesn’t work, but that nobody shows you where to actually start. So that’s what this guide is. No jargon, no abstract demos. Just how to use Copilot in Word and Excel, from the first click, explained the way a colleague would explain it if they actually had time.
First Things First: Do You Actually Have Copilot?
Before you go hunting for the Copilot button, check whether your plan includes it. This is where a lot of confusion starts.
For individuals: Copilot Pro costs $20/month and works inside Word, Excel, PowerPoint, and Outlook if you have a Microsoft 365 Personal or Family subscription. You can get it at microsoft.com/copilot.
For businesses: Microsoft 365 Copilot Business is currently $18/user/month (promotional rate through June 30, 2026 — it goes up to $21/user/month after that). It requires a qualifying base Microsoft 365 Business plan on top of the Copilot add-on cost. There’s also an Enterprise tier at $30/user/month for larger organizations.
The free version of Microsoft Copilot — the one built into Bing and Edge — doesn’t connect to your Word or Excel files. That’s a completely separate product. If you’re clicking the Copilot button in desktop Word and nothing useful is happening, it’s almost certainly a licensing issue, not a bug.
Once you’ve confirmed your access, open any desktop Word or Excel document, and look for the Copilot icon in the top right of the Home ribbon. That’s your entry point into everything below.
Microsoft Copilot in Word: What It Can Actually Do
🔗 Get started with Copilot in Word — Microsoft Support
Honestly, Word is where Copilot earns its keep faster than anywhere else. The use cases are immediate and obvious — drafting, rewriting, summarizing — and you don’t need to understand anything technical to get value from it in the first five minutes.
How to Open Copilot in Word
Click the Copilot icon in the Home ribbon (top right area). A sidebar opens on the right side of your document. You’ll see a text box at the bottom with a prompt like “Ask me anything about this document” or “Draft with Copilot.” That text box is everything.
Drafting a Document from Scratch
Click into a blank document and open Copilot. Type something like: “Draft a 300-word project proposal for a new employee onboarding process. Include sections for goals, timeline, and resources needed.” Copilot will generate a full draft directly into your document within about 10–15 seconds. It won’t be perfect — the thing nobody tells you is that Copilot’s first drafts are starting points, not finished work — but it’ll give you a solid structure you can edit rather than a blank page you’re staring at.
The more specific your prompt, the better the output. “Write a proposal” gets you something generic. “Write a proposal for a 90-day onboarding program for remote customer support hires, with weekly check-in milestones and a final assessment” gets you something actually useful.
Rewriting and Tone Adjustment
Select any block of text in your document, right-click, and look for the Copilot option in the context menu. From there you can ask it to rewrite more formally, make it shorter, simplify the language, or change the tone entirely. I tested this on a performance review I’d written that was coming across as harsher than intended. I selected the paragraph, asked Copilot to make it “more constructive and encouraging while keeping the key feedback points,” and the rewrite was genuinely better than what I had. That took about 20 seconds.
Summarizing Long Documents
Open any long Word document — a report, a contract, a meeting transcript — and open the Copilot sidebar. Type: “Summarize the key points of this document in 5 bullet points.” Copilot reads the entire file and returns a summary. For a 40-page document this takes maybe 30 seconds. It’s not always perfectly accurate on very dense technical material, so always skim-check the summary against the original on anything important. But for getting the gist of a document you’ve been handed at 4:45pm? It works.
The New Agent Mode in Word (April 2026)
As of April 22, 2026, Microsoft launched Agent Mode in Word, Excel, and PowerPoint — a significant upgrade from the previous Copilot Chat experience. Instead of just answering questions about your document, Agent Mode can take multi-step actions: draft a document, apply formatting, insert a table of contents, and save it, all from a single instruction. To access it, open Copilot and look for the Agent selector in the Copilot Chat panel inside Microsoft 365. It’s available to Microsoft 365 Personal, Family, and Business subscribers — no separate upgrade required.
Microsoft Copilot in Excel: The One That Surprises People Most
🔗 Get started with Copilot in Excel — Microsoft Support
Excel is where I’ve seen the biggest “wait, it can do that?” reactions from people who’d been skeptical of Copilot. If you’ve ever spent 45 minutes Googling an Excel formula for something that should be simple, this section is for you.
Before You Start: Format Your Data as a Table
This is the single most important setup step and almost nobody mentions it upfront. Copilot in Excel works best — sometimes only — when your data is formatted as an Excel Table (not just rows and columns, but an actual named Table). Select your data, go to Insert → Table, confirm the range, and make sure “My table has headers” is checked. Once it’s a Table, Copilot can read and work with it reliably.
Generating Formulas in Plain English
Here’s the feature that changes everything for people who aren’t formula experts. Open Copilot (Home ribbon, top right). Type something like: “Add a new column that calculates the percentage change between the Sales 2024 and Sales 2025 columns.” Copilot will write the formula for you and offer to insert it directly into the spreadsheet. No more hunting through formula documentation. No more trial and error with syntax. You just describe what you need in plain English — like you’d describe it to a colleague — and it builds it.
I tested this with a moderately complex request: “Create a column that flags any row where the Q4 revenue is more than 20% below the average of Q1, Q2, and Q3.” The formula Copilot generated was correct on the first try. It also explained what the formula was doing in plain English below the suggestion, which is genuinely useful for learning.
Asking Questions About Your Data
Have you ever looked at a spreadsheet with 2,000 rows and just wanted to know what’s going on in it without building a pivot table? Type into the Copilot sidebar: “What are the top 5 products by total revenue in this spreadsheet?” or “Are there any months where expenses exceeded revenue?” Copilot reads the data and answers in plain text, sometimes with a chart or pivot table it offers to insert.
This is genuinely useful for data that you’ve inherited from someone else and need to understand quickly. The accuracy is solid when the data is clean and well-structured. If your spreadsheet has merged cells, blank rows scattered through it, inconsistent formatting, and three different date formats — you’ll want to clean that up first, or the results will be unreliable. Garbage in, garbage out, even with AI involved.
Highlighting and Filtering Data
You can ask Copilot to highlight data based on conditions. Try: “Highlight all cells in the Revenue column where the value is below $10,000 in red.” It applies conditional formatting based on your instruction, no menu-diving required. For filtering: “Filter this table to show only rows where the Region is ‘North’ and the Status is ‘Open’.” Done in seconds, with an option to clear the filter just as easily.
Spotting Trends and Outliers
Copilot can surface things in your data you might have missed. Ask: “Are there any outliers in the Monthly Sales column?” or “Show me the trend in customer complaints over the last 12 months.” It returns charts, summaries, or formatted tables you can drop into a report. In my experience this works best on clean, complete datasets — if you’ve got a lot of missing values or inconsistent entries, the analysis gets shaky.
Prompt Tips That Actually Make a Difference
The quality of what Copilot gives you is almost entirely determined by how you ask. Here are the patterns that work:
Be specific about format: Instead of “summarize this,” try “summarize this in 5 bullet points under 20 words each.” Instead of “help me with this column,” try “add a new column called ‘Growth Rate’ that shows the year-over-year percentage change.”
Give it context: “Rewrite this paragraph for a client who has no technical background” lands better than “simplify this.” The context helps Copilot calibrate the output level.
Use positive instructions: Say “include only Q1 2026 data” rather than “don’t include data from other quarters.” Microsoft’s own documentation confirms that Copilot responds better to what you want than what you don’t want — it’s a pattern that holds up in real use.
Keep prompts focused: One task per prompt. If you want Copilot to rewrite, summarize, AND reformat a document section, break those into three separate prompts. Stacking too much into one instruction gets messy results.
What Copilot Still Can’t Do Well — Being Honest About the Limits
I’d push back on anyone presenting Copilot as a complete replacement for human judgment in documents or data work. It’s not. Not yet.
In Word, it sometimes generates content that sounds plausible but is factually wrong — especially if you ask it to write about specific events, statistics, or regulations. Always fact-check anything Copilot drafts that will be shared externally. It’s a drafting assistant, not a research engine.
In Excel, it struggles with complex multi-sheet workbooks, messy or inconsistent data, and highly specialized financial models with nested logic. If your spreadsheet has been built up over years by different people with different conventions — named ranges in one tab, raw references in another, formulas that reference other workbooks — Copilot will sometimes misread the structure and produce wrong results. Test its formula outputs before relying on them.
And both apps require your files to be saved to OneDrive or SharePoint for Copilot to work with full access to the document. Local files work to a degree, but some features simply won’t engage until the file is cloud-saved. That’s a setup detail that catches people out constantly — you get the idea.
Who Should Prioritize Learning This — and Who Can Wait
Start using Copilot this week if you: write reports or proposals regularly, spend time cleaning up formatting in Word documents, build basic Excel dashboards or trackers, or frequently summarize long documents for other people. The time savings in these specific tasks are real and immediate.
You can probably wait if you: primarily use Excel for complex financial modeling with specialized logic, work mostly in Excel files that other tools or scripts generate automatically, or your Word work is mainly quick emails and memos. Copilot’s value scales with complexity and volume — light users won’t feel the difference as much.
For small business owners and freelancers: Copilot Pro at $20/month is worth a one-month trial if you write proposals, client reports, or invoices regularly. At $20/month, saving just two hours a month on writing and formatting easily covers the cost. Cancel if it doesn’t click for your workflow — there’s no annual commitment required on the Pro plan.
Where to Go Next
Microsoft has a free prompt library called Copilot Lab — it’s worth bookmarking. You’ll find it at copilot.cloud.microsoft/prompts. It’s organized by app and use case, and it gives you real tested prompts you can copy and adapt for your own work. It’s the resource I wish I’d found in week one instead of week four.
For the official Microsoft support pages covering each app:
- Copilot in Word — Official Microsoft Support
- Copilot in Excel — Official Microsoft Support
- Microsoft 365 Copilot Plans and Pricing
So here’s what I want to know from you: which specific task in Word or Excel has been taking you the longest every week — the one you’re most hoping Copilot can actually help with? Drop it in the comments. I read every one, and if there’s a prompt or workflow that addresses it, I’ll share it directly.