Tutorials · Beginner How to use Microsoft Copilot at work: Word, Excel, Teams and Outlook with AI Practical guide to using Microsoft Copilot at work from day one: activate it, write in Word, analyze in Excel, summarize meetings in Teams and manage email in Outlook.
Using Microsoft Copilot at work is no longer optional if you have Microsoft 365: the AI assistant has arrived in Word, Excel, Teams and Outlook so you can write faster, analyze without complex formulas and never lose track of a meeting. This guide shows you, step by step, how to activate it and get the most out of it from day one, without being technical.
Tap each step to open and follow it.
Before you start: Copilot requires a Microsoft 365 Copilot license on top of your Microsoft 365 base plan. If you’re not sure your company has it, ask your IT admin. Pricing is in the right column.
1 Verify you have Copilot access
- Open any Microsoft 365 app: Word, Excel, Outlook or Teams.
- Look for the Copilot icon (a silhouette with sparkles or a colored “C”). It usually appears in the top toolbar or as a floating button.
- If you don’t see the icon, your account may not have the Copilot license. Talk to your company’s IT admin or visit https://www.microsoft.com/en-us/microsoft-365-copilot/pricing to see available plans.
If you work independently (freelancer or small business), you can purchase the license directly from the Microsoft 365 portal for your account.
2 Use Copilot in Word: write and improve text
Copilot in Word is your personal writer and editor. It can create drafts from scratch, improve what you’ve already written and summarize long documents.
To create a new draft:
- Open a document in Word.
- Click the Copilot icon in the top bar or the “Draft with Copilot” button that appears at the start of an empty document.
- Describe what you need in the text field. For example: “Write a formal email to a supplier requesting a 30-day payment extension”.
- Copilot generates the text. You can accept it, ask for adjustments or edit it yourself.
To improve existing text:
- Select the paragraph or section you want to improve.
- Click the Copilot icon that appears next to the selection.
- Choose an option: Rewrite, Summarize, Change tone or write your own instruction.
To summarize a long document:
- Open the document.
- Click Copilot in the right sidebar.
- Type: “Summarize the main points of this document” and Copilot gives you a summary without you having to read it all.
3 Use Copilot in Excel: analyze data without complex formulas
Copilot in Excel helps you analyze tables, create formulas and generate charts using natural language. You don’t need to know advanced formulas.
- Open your Excel sheet. Data should be in a table with clear column headers.
- Click the Copilot icon in the toolbar (Home tab).
- A side panel opens. Type your question or instruction. Examples:
- “Which month had the most sales?”
- “Create a column showing % growth compared to the previous month”
- “Make a bar chart with sales by region”
- Copilot responds with the analysis, formula or chart. You can insert it into your sheet with one click.
Tip: Make sure your table has no merged cells or empty rows in the middle; Copilot works best with clean, well-organized data.
To go deeper, check out the tutorial How to use AI in Microsoft Excel.
4 Use Copilot in Teams: summarize meetings and chats
Copilot in Teams is probably where you save the most time: you’ll never have to take notes in a meeting again.
During a live meeting:
- Join the meeting as usual.
- Click the three dots (…) in the controls bar and select Copilot.
- A side panel appears. You can ask at any time:
- “What points have been discussed so far?”
- “What decisions have been made?”
- “List the next steps mentioned”
- Copilot responds based on the real-time transcript.
The meeting must have transcription enabled for Copilot to work in live mode. The organizer can enable it from the meeting settings.
After the meeting:
- In the meeting chat, click the Summary tab or the Copilot icon.
- Choose Generate meeting notes or ask a specific question about what was discussed.
In chats and channels:
- Open a long chat thread or a channel with many messages.
- Click the Copilot icon in the upper corner of the chat.
- Ask: “Summarize the last 3 days of conversation” or “Are there any pending tasks for me?”.
5 Use Copilot in Outlook: manage your email with AI
Copilot in Outlook helps you draft emails, summarize long threads and respond faster.
To draft a new email:
- Click New Mail.
- In the body area of the email, click the Copilot icon (or “Draft with Copilot” if it appears in the toolbar).
- Describe what you need: “Write a friendly follow-up to client Acme about the proposal sent last week”.
- Copilot generates the draft. Adjust it or send it as is.
To summarize a long thread:
- Open the email thread.
- Click Summarize (or the Copilot icon at the top of the email).
- Copilot gives you a summary of the key points without you having to read every message.
To improve an email you already wrote:
- Write your draft.
- Click the Copilot icon inside the email.
- Choose: Make more formal, Make shorter, Change tone or write your own instruction.
For more AI email management tips, check out the tutorial How to automate and organize your email with AI.
Tips to get more out of Copilot
- Be specific in your instructions. The more context you give (“write in formal tone”, “maximum 3 paragraphs”, “for a client who doesn’t know about technology”), the better the result.
- Iterate. If the first result isn’t perfect, ask for adjustments: “make it shorter”, “use bullet points”, “change the tone to be more friendly”.
- Use Copilot to start, you to finish. Copilot generates the quick first draft; you review and add your judgment. That combo is what multiplies your productivity.
- Copilot in Business Chat (BizChat). There’s a unified interface at teams.microsoft.com/copilot where you can ask things that cross applications: “find emails from last week about project X and give me a summary”.
If something doesn't work
| Problem | Fix |
|---|
| I don’t see the Copilot icon in any app | Ask the IT admin to verify that the Copilot license is assigned to your account | | Copilot says “Not enough data” in Excel | Convert your range to an official table (Insert > Table) and make sure headers are clear | | Teams transcription doesn’t work | The organizer must enable transcription; if the meeting already ended, it can’t be enabled retroactively | | Copilot in Outlook doesn’t appear | Make sure you’re using the updated web version or desktop app; the old Outlook version doesn’t support Copilot |
Frequently asked questions Is Microsoft Copilot the same as Copilot (the free chatbot)? No. The chatbot at copilot.microsoft.com is free but limited. Microsoft 365 Copilot is the paid add-on that integrates inside Word, Excel, Teams and Outlook with access to your documents and conversations. Do I need to know how to code to use Microsoft Copilot? Not at all. Copilot works with natural language: you type what you want and it does it. No commands or code required. Can Copilot access my private files? Copilot respects Microsoft 365 permissions: it only accesses the files and conversations you already have access to. It won't touch data you don't have permission for. Does it work in Spanish? Yes. You can give instructions in Spanish and Copilot responds in the same language you use. It can also translate and adapt text between languages. Does Copilot replace human assistants? No. Copilot automates repetitive text and data tasks, but reviewing, judgment and decisions remain yours. It frees up time for what matters. |