Section 10.3.6 : Microsoft Copilot in Microsoft 365
🎯 Learning objective
Leveraging Microsoft Copilot integrated into Microsoft 365 (Word, Excel, PowerPoint, Outlook, Teams) to transform daily workplace productivity. Understanding the differences between Copilot Pro and Copilot for M365, and data governance implications for enterprises.
Microsoft Copilot: AI in your everyday tools
Microsoft Copilot integrates GPT-5 directly into the Microsoft 365 applications used by 1.5 billion people every day. It's the most ubiquitous AI in the enterprise world — and for many employees, it's their first contact with generative AI, embedded in tools they already know.
Microsoft's strategy is radically different from OpenAI's, Google's, or Anthropic's: rather than creating a new product, they inject AI into existing products. No need to learn a new interface — Copilot appears where you're already working.
Copilot by application — Detailed guide
Word — Document writing and analysis
| Feature | Example prompt | Result |
|---|---|---|
| Writing from scratch | "Write a 5-page report on AI trends in professional training" | Structured document with introduction, chapters, conclusion |
| Document summary | "Summarize this 40-page contract in 10 key points" | Structured synthesis with essential elements |
| Targeted rephrasing | "Rewrite this paragraph for a non-technical executive committee" | Simplified version without jargon |
| Tone change | "Make this message more diplomatic and less directive" | Version adapted to the desired tone |
| Professional translation | "Translate this paragraph into business English" | Contextual translation (not word-for-word) |
| Writing from files | "Write a sales proposal based on client_brief.docx and our case_reference.pptx" | Document cross-referencing multiple sources |
Excel — Natural language data analysis
| Feature | Example prompt | Result |
|---|---|---|
| Quick analysis | "What is the revenue by quarter and by product?" | Cross-table + automatic chart |
| Complex formulas | "Add a column calculating MoM growth handling zero months" | Auto-generated IF/IFERROR formula |
| Anomaly detection | "Are there any unusual values in the March sales?" | Identification and explanation of outliers |
| Smart charts | "Create a combo chart: revenue as bars, margin as line, by quarter" | Formatted, readable chart |
| Conditional formatting | "Color cells red where margin is < 20%" | Formatting rules applied |
| Pivot tables | "Create a pivot table showing sales by region and category" | Pivot table generated with the right fields |
PowerPoint — Automatic presentations
| Feature | Example prompt | Result |
|---|---|---|
| Full creation | "Create a 12-slide presentation on our ESG strategy 2026" | Deck with structure, content, and images |
| From a document | "Transform this Word report into an 8-slide presentation" | Automatic extraction of key points |
| Adapted design | "Apply a professional design with our blue palette" | Consistent formatting |
| Speaker notes | "Add speaker notes for each slide (3 min/slide)" | Detailed notes for the presenter |
| Condensation | "Reduce this 30-slide presentation to 10 essential slides" | Selection and merging of key slides |
Outlook — Intelligent email management
- →Conversation summaries: a thread of 30 emails summarized in 3 sentences — no more scrolling to understand context
- →Contextual drafting: Copilot writes responses adapted to the conversation's tone and your historical style
- →Tone coaching: "Make this email more assertive" or "Soften the tone of this follow-up"
- →Prioritization: suggests which emails require your immediate attention
- →Catch-up: after vacation, "Summarize the important emails I received during my 2-week absence"
Teams — Augmented meetings
- →Real-time transcription: automatic multilingual transcription during meetings
- →Live summary: arrive late → "What did I miss?" → instant summary
- →Action capture: Copilot automatically identifies decisions made and assigned actions
- →Post-meeting summary: sent to participants with the list of decisions and actions
- →Smart chat: after the meeting, ask questions about what was said ("What was Marie's position on the budget?")
Data governance — Critical point for enterprises
Copilot respects existing Microsoft 365 permissions (it can only access what the user can already see). But here's a subtle trap: in many companies, permissions are too broad by default. Copilot could surface sensitive information that the user technically had the right to see but would never have found manually.
Preventive actions before deploying Copilot:
- →Audit SharePoint and OneDrive permissions
- →Implement sensitivity labels (Microsoft Purview)
- →Enable DLP (Data Loss Prevention) policies
- →Train users on what Copilot can and cannot see
- →Disable Copilot on SharePoint sites containing ultra-sensitive data (HR, legal, M&A)
Copilot Pro vs Copilot for Microsoft 365
| Feature | Copilot Pro ($20/month) | Copilot for M365 ($30/user/month) |
|---|---|---|
| ChatGPT-like on the web | ✅ | ✅ |
| Word, Excel, PPT, Outlook | ✅ (personal/family version) | ✅ (enterprise version) |
| Teams | ❌ | ✅ |
| Microsoft Graph (enterprise data) | ❌ | ✅ (access to SharePoint, email, calendar data) |
| Administration and security | ❌ | ✅ (admin controls, audit logs) |
| Copilot Studio (customization) | ❌ | ✅ (create custom Copilot agents) |
| Minimum users | 1 | 300 (then 1 with Business Basic) |
| Typical use case | Freelancers, small businesses, personal use | SMEs and large enterprises |
Recommendation: if you're a freelancer or small business, Copilot Pro at $20/month is excellent for Word, Excel, and PowerPoint. If you're in a company with Microsoft 365, ask your IT department to deploy Copilot for M365 — the integration with Teams and Microsoft Graph justifies the extra $10/month.
Advanced Copilot techniques
1. Document chaining: Copilot can cross-reference multiple files from your OneDrive/SharePoint: "Write a sales proposal using the client_brief.docx, the references from success_cases.pptx, and the pricing from price_grid_2026.xlsx"
2. Tone iteration: never validate the first version. Systematically ask: "This is too generic. Make it more specific to our sector (fintech) with concrete figures"
3. Personal template: save your best Copilot prompts in a reference Word document and copy-paste them as needed — create your own "Copilot prompt library."
Practical exercise with Copilot
Duration: 30 minutes (requires Copilot Pro or M365)
- →Word: request an executive summary of a document you have in progress
- →Excel: ask 3 natural language questions about an existing data file
- →PowerPoint: create an 8-slide presentation from a Word document
- →Outlook: use conversation summary on a long email thread
- →Compare: do the same task (writing a report) on Copilot Word and on ChatGPT — note the differences
According to the Microsoft study (31,000 employees), what is the average time saved per day with Copilot?
What is the main governance risk associated with deploying Copilot in an enterprise?