Microsoft 365 Copilot for Beginners: Excel, Word, Outlook, Teams
Updated · By Robert Breen
The problem
Priya manages operations for a 30-person distributor. After a week off she has 140 unread emails, missed two Teams meetings and owes her boss a one-page update by noon. Reading everything takes most of the day.
What you’ll be able to do
You will know what Copilot can and cannot do in each app, whether your plan includes it, how to ask for exactly what you need, and the two checks that stop an AI mistake reaching your boss.
What Copilot is
Copilot is the AI assistant built into the Microsoft 365 apps. It drafts, summarizes and answers questions using the file, email thread or meeting you have open, and at work it can also draw on other content you already have access to. It does not see files you could not open yourself. The AI glossary page on Microsoft Copilot covers the product family; this lesson is about using it inside the apps.
What it does in each app
| App | Good first requests | Watch out for |
|---|---|---|
| Outlook | Summarize a long thread; draft a reply; coach the tone of your draft | Promises or dates it adds that nobody agreed to |
| Teams | Recap a meeting from its transcript; list decisions and action items; catch up on a chat | Meetings without a transcript or recording give it little to work with |
| Word | Draft from an outline or another file; summarize a long document; rewrite a paragraph shorter | Facts and figures it was not given |
| Excel | Suggest a formula column; highlight, sort or filter; spot trends in a table | The data must be a table (or a clean range) in a file saved to OneDrive or SharePoint |
Which plans include it
At work, Copilot in the apps comes with a Microsoft 365 Copilot license that your company adds. At home, Microsoft 365 Personal and Family plans include Copilot features in the apps. The free web apps do not. Plans and names change often, so check Microsoft’s Where can I get Microsoft Copilot? page before you buy anything.
Priya’s morning, with Copilot
- In Outlook, open the longest thread and select Copilot > Summarize (the Copilot button sits at the top of the message). Read the summary, then open the two emails it says need a decision.
- In Teams, open each missed meeting’s recap, or open Copilot in the meeting chat, and ask: "List the decisions made and the action items assigned to me, with who asked."
- In Word, open a blank document, select the Copilot icon and ask: "Draft a one-page update for my manager using these notes," then paste the decisions and action items. Ask for "five bullet points, plain language, no more than 150 words" if the first draft runs long.
- In Excel, open the open-orders workbook (saved in OneDrive, formatted as a table), select Copilot on the Home tab and ask: "Highlight orders over 14 days old." Review the description of what it will change, then apply it.
Word your request like a brief
Copilot does better with the same things a new colleague needs: the goal, the source to use, who it is for and the format. "Summarize this" works; "Summarize this thread for my manager in three bullets, then list any open questions" works better. The AI glossary has a short guide to this pattern, Role, Context, Task, Format.
Two checks before you send
Check every number and name against the source. AI tools can state something wrong with total confidence; the AI glossary calls this a hallucination. If Copilot says the order count is 212, look at the table.
Check what it left out. A summary is a choice of what matters. Skim the original for anything with a date, a dollar amount or a customer name, because those are the details that cause trouble when missed.
Check your understanding
What does Copilot in Excel need before it can work on your data?
Show the answer
A table or clean range in a file saved to OneDrive or SharePoint. Microsoft’s guidance is to format the data as a table (or a supported range) in a cloud-saved workbook with AutoSave on.
Can Copilot show you a file you do not have permission to open?
Show the answer
No. Copilot works with content the signed-in person can already access. It does not bypass permissions.
Copilot’s summary says a customer agreed to a 10% discount. What do you do?
Show the answer
Find that point in the original email before using it. Always check numbers, names and commitments against the source; AI summaries can be wrong or missing context.
Sources
Written from these official help pages. Menus change, so if a button has moved, the help page has the current wording.
- Microsoft Learn: What is Microsoft 365 Copilot?
- Microsoft Support: Where can I get Microsoft Copilot?
- Microsoft Support: Format data for Copilot in Excel
- Microsoft Support: Highlight, sort and filter your data with Copilot in Excel