Cover of Microsoft Copilot Made Crystal Clear
← Back to the series

Microsoft Copilot

Made Crystal Clear

By Christophe Paka · Updated November 13, 2026

A Visual Beginner's Guide to AI at Work in Excel, Word, and Teams

Soon on Amazon
Give feedback

Who this book is for

In plain words: Copilot is the AI assistant in your Microsoft work account: it drafts and summarizes in Outlook, Teams, Word and Excel, and only opens files you can already open.

  • Busy professionals whose company gave them Copilot and who want real time back
  • Newcomers on free Copilot Chat who wonder how far it goes without a license
  • IT leads and managers rolling it out without risking company data
  • Not for: Not for you if you want GitHub Copilot, the AI that helps you write code. Try GitHub Made Crystal Clear.

Your company switched on Copilot, you asked it something, and the answer was vague, so now you wonder whether it is worth the effort. This visual beginner's guide shows you which Copilot you have, how to ask it well, and how to check what it gives back. Inside, you will learn to: tell Copilot Chat, included with your work plan, from the paid license, and read the label under your name that says which one you have; write a four part brief (goal, context, source, expectations) and check every answer against the file or email it cites; summarize long email threads and meetings, draft replies in Outlook, and draft documents and decks in Word and PowerPoint that you still check before they leave; question a budget in Excel and approve a change before Copilot makes it; keep company data safe: what Copilot stores, who can see your history, and why it never opens a file you could not already open; and know what Copilot costs, seats and metered credits alike, what independent government trials found, and whether a seat pays back for your team. Fifteen chapters, 45 diagrams and 30 step by step recipes. Every idea has a diagram, every recipe is numbered with the result you should see, and every chapter ends with a Try it to check yourself. The words stay plain, and the real terms stay in. Whether you are a busy professional, a newcomer on Copilot Chat, a manager or the IT lead who rolls it out, one sample project, the Spring Launch, runs through every chapter, and you finish knowing where Copilot saves you time and where you should not trust it yet.

Pages
192
Level
Beginner to advanced
Updated
November 13, 2026

12 real pages. Click a page to enlarge it.

Page 7: each layer needs the one below
Page 20: where you can open Copilot Chat
Page 22: on free Chat, your work reaches Copilot through four doors, and the web is always open
Page 39: anatomy of a brief
Page 50: asking about your inbox works on every label
Page 72: edit mode or Chat only
Page 82: chat, Plan, Edit
Page 96: the template and the Brand Kit, under the draft, set the look of a Copilot deck
Page 114: what an agent reads decides who can use it
Page 126: where your prompt goes, and what stays
Page 130: oversharing: Copilot reaches only what you can open, so an overshared folder becomes easy to find, while a...
Page 146: seats, active users and prompts are counts (blue)

Is this you?

  • You are not sure if you have free Copilot Chat or the paid licenseChapter 1: Which Copilot Do You Have?
  • You tried one vague prompt and decided Copilot was hypeChapter 4: Prompts That Work: Write a Brief, Not a Wish
  • Copilot says it cannot read your Excel file, or it guesses your formulasChapter 8: Excel: Analyze Data and Check Every Edit
  • Copilot could not recap your meeting, and you do not know whyChapter 6: Teams: Meetings, Recaps, and Chats
  • You fear Copilot will show people files they should never seeChapter 12: Your Data: What Copilot Sees, Keeps, and Shares
  • Your company bought seats, and you must prove they are worth the moneyChapter 14: Is Copilot Worth It? Costs, Evidence, and Alternatives

15 chapters · 50 diagrams · 30 recipes · 41 checklists · 154 glossary terms · 163 sources

Inside the book

  1. 01Which Copilot Do You Have?
  2. 02Your First Hour in Copilot Chat
  3. 03How Copilot Answers, and How to Check It
  4. 04Prompts That Work: Write a Brief, Not a Wish
  5. 05Outlook: Tame Your Inbox
  6. 06Teams: Meetings, Recaps, and Chats
  7. 07Word: Draft, Rewrite, and Summarize
  8. 08Excel: Analyze Data and Check Every Edit
  9. 09PowerPoint and OneNote: From Document to Deck
  10. 10Pages, Notebooks, Memory, and Scheduled Tasks
  11. 11Agents: Use Microsoft's, Build Your Own
  12. 12Your Data: What Copilot Sees, Keeps, and Shares
  13. 13Roll It Out: Pilot, Guardrails, and Adoption
  14. 14Is Copilot Worth It? Costs, Evidence, and Alternatives
  15. 15Your First 30 Days and the Cheat Sheet

You'll leave with

  • Tell free Copilot Chat from the paid license, and read the label that says which one you have
  • Write a four part brief (goal, context, source, expectations) and check each answer against its source
  • Summarize email threads and meetings, and draft replies you still check before you send
Christophe Paka, author of Microsoft Copilot Made Crystal Clear

About the author

Christophe Paka writes every book on the shelf. He spent years in technical support at Salesforce and Microsoft, where the job was to make complex systems clear to customers who needed them working the same day. He has since built and run software as a founder and lead developer, worked as a Salesforce consultant, and grown a YouTube channel on tech careers past one million views.

This book was last updated on November 13, 2026.

Connect on LinkedIn →

For teams

Put Microsoft Copilot on every desk at your company.

One licence, every book in the series, one link for everyone. From $250 a year.

See the team licences

Sources

Every source cited in Microsoft Copilot Made Crystal Clear. Each number matches the [n] marker next to that link in the book's "Go deeper" lists, so you can trace any claim back to its origin.

  1. [1]What is Microsoft Copilot? (Learn overview)
  2. [2]Microsoft Copilot requirements
  3. [3]How Copilot Chat works with and without a Microsoft 365 Copilot license
  4. [4]The Microsoft 365 app transition to the Microsoft Copilot app
  5. [5]Partner Center announcements, August 2026
  6. [6]Introducing the new Copilot with Home, Code and Autopilot (2026-09-25)
  7. [7]Introducing Microsoft Copilot Studio and new features in Copilot for Microsoft 365 (2023-11-15)
  8. [8]Furthering our AI ambitions: Bing Chat Enterprise and Microsoft 365 Copilot pricing (2023-07-18)
Show all 163 sources
  1. [9]Microsoft Copilot plans and pricing, business
  2. [10]Microsoft Copilot plans and pricing, enterprise
  3. [11]License options for Microsoft Copilot
  4. [12]Compare Copilot in E3, E5, and E7
  5. [13]Microsoft 365 E7 and Agent 365 are now generally available (2026-05-01)
  6. [14]Microsoft 365 Copilot Business: the future of work for small businesses (2025-12-02)
  7. [15]Copilot pricing plans for individuals
  8. [16]Copilot is now included in Microsoft 365 Personal and Family (2025-01-16)
  9. [17]Microsoft Copilot for individuals
  10. [18]Meters for Microsoft Copilot pay-as-you-go services
  11. [19]Usage-based billing and cost management for Copilot Credits
  12. [20]Semantic indexing for Microsoft Copilot
  13. [21]Application card: Microsoft Copilot (for organizations)
  14. [22]Data, privacy, and security for Microsoft Copilot
  15. [23]Data, privacy, and security for web search in Microsoft Copilot and Microsoft Copilot Chat
  16. [24]Data protection and auditing for Microsoft Copilot
  17. [25]Supported languages for Microsoft Copilot
  18. [26]Standard versus priority access to features in Microsoft 365 Copilot Chat
  19. [27]Welcome to Copilot in Word
  20. [28]How Copilot Chat works in Microsoft 365 apps
  21. [29]Get started with Copilot in Excel
  22. [30]Frequently asked questions about Copilot in Excel
  23. [31]Get an advanced data analysis using Copilot in Excel with Python (retired)
  24. [32]Draft, analyze, and present with Microsoft Copilot (MS-4018 learning path)
  25. [33]Welcome to Copilot in PowerPoint
  26. [34]Create a new presentation with Copilot in PowerPoint
  27. [35]Create a presentation from existing files
  28. [36]Welcome to Copilot in OneNote
  29. [37]Summarize an email thread with Copilot in Outlook
  30. [38]Draft an email message with Copilot in Outlook
  31. [39]Frequently asked questions about Copilot in Outlook
  32. [40]Get started with Copilot in Microsoft Teams meetings
  33. [41]Use Copilot without transcribing or recording a Teams meeting or call
  34. [42]Use Copilot in Microsoft Teams chat and channels
  35. [43]Facilitator in Microsoft Teams meetings
  36. [44]Learn about Copilot prompts
  37. [45]Write a great prompt in Microsoft 365 Copilot
  38. [46]Write prompts that get results (Learn unit)
  39. [47]Get ready to work with Microsoft Copilot (Learn module)
  40. [48]Write effective prompts to achieve optimal results (Learn module)
  41. [49]Write an effective prompt (Learn unit)
  42. [50]Review prompting best practices (Learn unit)
  43. [51]Discover, share, and save prompts with Prompt Lab (Learn unit)
  44. [52]Save your favorite prompts to use again
  45. [53]Understand Prompt Gallery in Copilot (admin)
  46. [54]Get started with Microsoft Copilot Pages
  47. [55]Frequently asked questions about Copilot Notebooks
  48. [56]Extending Microsoft 365 Copilot with plugins (landing)
  49. [57]Microsoft Copilot documentation hub
  50. [58]Ways to extend Microsoft 365 Copilot
  51. [59]What Is a Microsoft 365 Copilot Plugin?
  52. [60]Compare declarative and custom engine agents
  53. [61]Declarative agents for Microsoft 365 Copilot
  54. [62]Microsoft 365 Copilot connectors overview
  55. [63]Build agents in Agent Builder
  56. [64]Add knowledge sources to an agent in Agent Builder
  57. [65]Share and manage agents built in Agent Builder
  58. [66]Choose between Agent Builder and Copilot Studio
  59. [67]Copy an agent from Agent Builder to Copilot Studio
  60. [68]Agents built by Microsoft
  61. [69]Microsoft Copilot Researcher agent FAQ
  62. [70]Set up your development environment (Agent capabilities and licensing models)
  63. [71]Plan licensing and cost for Microsoft 365 Copilot extensibility
  64. [72]Microsoft Copilot pay-as-you-go service overview
  65. [73]Copilot Studio billing rates and management
  66. [74]Agent Registry in Microsoft 365 admin center
  67. [75]Agent settings in Microsoft 365 admin center
  68. [76]Manage Copilot personalization and memory
  69. [77]Customize how Microsoft 365 Copilot responds to you
  70. [78]Schedule your most used Copilot prompts
  71. [79]How Microsoft 365 Copilot Notebooks works
  72. [80]Enterprise data protection in Microsoft Copilot and Microsoft Copilot Chat
  73. [81]Privacy and protections (Copilot Chat)
  74. [82]Secure and govern Microsoft Copilot: Foundational deployment guidance
  75. [83]Copilot controls overview
  76. [84]Copilot controls security and governance
  77. [85]What is SharePoint Advanced Management?
  78. [86]Restrict discovery of SharePoint sites and content
  79. [87]Restricted SharePoint Search
  80. [88]Data access governance reports for SharePoint and OneDrive sites
  81. [89]Microsoft Purview data security and compliance protections for generative AI apps
  82. [90]Learn about using Microsoft Purview Data Loss Prevention to protect interactions with Microsoft 365 Copilot, Copilot Chat, and Cowork
  83. [91]Learn about retention for Copilot & AI apps
  84. [92]Audit logs for Copilot and AI applications
  85. [93]Microsoft Copilot adoption guide and overview for IT admins
  86. [94]Assign or unassign licenses for users in the Microsoft 365 admin center
  87. [95]Configure Microsoft Copilot settings in the Microsoft 365 admin center
  88. [96]Manage Copilot Chat
  89. [97]Welcome users, create organizational messages, and enable feedback for Microsoft Copilot
  90. [98]Change the Microsoft 365 Apps update channel for devices in your organization
  91. [99]Upcoming channel unification: Semi-Annual Enterprise Channel to Monthly Enterprise Channel
  92. [100]Microsoft Copilot adoption (adoption.microsoft.com)
  93. [101]Microsoft Copilot usage report
  94. [102]Microsoft Copilot reporting options for admins
  95. [103]Copilot controls measurement and reporting
  96. [104]Connect to the Microsoft Copilot Dashboard for Microsoft 365 customers
  97. [105]Microsoft 365 Copilot Experiment: Cross-Government Findings Report (GDS, June 2025)
  98. [106]The Evaluation of the M365 Copilot Pilot in the Department for Business and Trade (August 2025)
  99. [107]Discover DBT's M365 Copilot evaluation report (DBT blog, September 2025)
  100. [108]UK government trial of M365 Copilot finds no clear productivity boost (The Register, September 2025)
  101. [109]Evaluation of a trial of generative AI (Copilot) in the Treasury, summary (ACE, February 2025)
  102. [110]Evaluation of a trial of generative AI (Copilot) in the Treasury, publication page
  103. [111]Treasury M365 Copilot review estimates 13 minute efficiency gain needed (iTnews, February 2025)
  104. [112]Gov Copilot trial unsettled by usage metrics and unmet expectations (iTnews, October 2024)
  105. [113]Shifting Work Patterns with Generative AI (arXiv v3, July 2025; Microsoft Research led)
  106. [114]NBER Working Paper 33795
  107. [115]Gartner: Microsoft Copilot hype offset by ROI and readiness realities (techpartner.news, June 2025)
  108. [116]Microsoft 365 Copilot rollouts slowed by data security, ROI concerns (Computerworld, September 2024)
  109. [117]Why AI assistants still face barriers at scale (Computerworld, January 2026)
  110. [118]EchoLeak: The First Real-World Zero-Click Prompt Injection Exploit in a Production LLM System (arXiv, September 2025)
  111. [119]EchoLeak in Microsoft Copilot: What it Means for AI Security (Varonis blog)
  112. [120]Too much access: Microsoft Copilot data risks explained (Concentric AI, April 2026)
  113. [121]Microsoft launches cheaper Microsoft 365 Copilot Business (Office Watch, December 2025)
  114. [122]Forrester TEI of Microsoft 365 Copilot (March 2025, commissioned by Microsoft)
  115. [123]Google Workspace price increase 2025 (9to5Google, January 2025)
  116. [124]Claude pricing (Anthropic, retrieved November 2026)
  117. [125]Google Workspace pricing (retrieved November 2026, Thai baht view)
  118. [126]ChatGPT pricing (retrieved November 2026, no business prices shown)
  119. [127]Prompting in Copilot (The Ohio State University IT)
  120. [128]Use Current Channel or the Monthly Enterprise Channel to access Copilot features
  121. [129]Delete your Microsoft 365 Copilot activity history
  122. [130]Set up Microsoft 365 Copilot, admin guide
  123. [131]Microsoft 365 Copilot Chat usage report
  124. [132]Microsoft 365 Copilot readiness report
  125. [133]Anthropic models in Microsoft Online Services
  126. [134]Agent Mode in Excel
  127. [135]Keep it short and sweet: a guide on the length of documents that you provide to Copilot
  128. [136]Create a meeting agenda with Copilot in Outlook (Schedule with Copilot)
  129. [137]Get email coaching with Copilot in Outlook
  130. [138]Frequently asked questions about Copilot in Microsoft Teams
  131. [139]Overview of AI in Microsoft Teams for IT admins
  132. [140]Frequently asked questions about Copilot in Loop
  133. [141]Overview of Copilot Pages and Copilot Notebooks permissions
  134. [142]Get started with Microsoft 365 Copilot Notebooks
  135. [143]Share a Microsoft 365 Copilot Notebook
  136. [144]Drive adoption of Microsoft 365 Copilot, session 2 (prompting)
  137. [145]Now generally available: Surveys agent in Microsoft 365 Copilot (Microsoft Forms blog)
  138. [146]Microsoft 365 blog post on Researcher and Analyst (combined 25 queries a month)
  139. [147]Get more agents in the Microsoft 365 Copilot app
  140. [148]Submit agents from Agent Builder to your org catalog
  141. [149]Manage agents for Microsoft 365 Copilot (extensibility)
  142. [150]Plugins for Microsoft Copilot (MCP and API plugins as actions)
  143. [151]Manage agents in the Microsoft 365 admin center
  144. [152]Copilot Studio licensing and billing (Copilot Credits)
  145. [153]Microsoft 365 Copilot (enterprise product page)
  146. [154]Microsoft 365 blog, January 2024: Copilot for all sizes, no seat minimum
  147. [155]What's the difference between Microsoft Copilot (free) and Copilot in Microsoft 365
  148. [156]What's the difference between using Copilot Chat with or without a Microsoft 365 Copilot license
  149. [157]Microsoft 365 Copilot drove up to 353% ROI for small and medium businesses (Microsoft 365 blog, 2024-10-17)
  150. [158]Forrester projected TEI of Microsoft 365 Copilot for SMB (October 2024, commissioned by Microsoft)
  151. [159]Forrester projected TEI of Microsoft Copilot Studio (September 2025, commissioned by Microsoft)
  152. [160]The State of Microsoft 365 Copilot: Survey Results (Gartner abstract, October 2024)
  153. [161]r/microsoft_365_copilot (Reddit community)
  154. [162]r/copilotstudio (Reddit community)
  155. [163]Microsoft Tech Community: Microsoft Copilot

New books, in your inbox

One short note when a new Made Crystal Clear guide ships.
No spam, unsubscribe anytime.