Gemini, Microsoft Copilot, Perplexity & the AI Tool LandscapeMicrosoft Copilot · Lesson 7 of 19

Microsoft 365 Copilot and Copilot Chat in daily work

Article · 16 min · 8 min lecture

Video lecture

Microsoft 365 Copilot and Copilot Chat in daily work

14 chapters · about 8 min · full transcript

Coming soon

Chapter 1 of 14

Microsoft 365 Copilot

  • Know which Copilot
  • Workflows in Outlook, Teams, Word, Excel, PowerPoint

The narrated lecture is in production

Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.

Chapters

Know which Copilot you are using

Microsoft uses "Copilot" for several products. The distinctions matter for data and capability:

ProductWhat it isWork data access
Microsoft Copilot (consumer)Personal assistant for Microsoft accountsPersonal context only
Microsoft 365 Copilot ChatWeb-grounded chat included at no extra cost for eligible Microsoft 365 business users signing in with Entra ID, covered by enterprise data protectionFiles you upload; agents that use tenant data may be billed pay-as-you-go
Microsoft 365 Copilot (paid licence)Copilot inside Word, Excel, PowerPoint, Outlook, Teams and more, grounded in your organisation's data through Microsoft Graph ("Work IQ")Emails, files, meetings, chats you already have permission to see

Microsoft 365 Copilot also includes reasoning agents such as Researcher (multi-step research across work data and the web) and Analyst (data analysis), Copilot Notebooks and Pages, and in 2026 Copilot Cowork, an agentic experience that plans and carries out multi-step work. Copilot offers model choice, including models from OpenAI and Anthropic, under Microsoft's enterprise terms. Features and licensing change frequently; your IT admin and Microsoft's documentation are the source of truth.

High-value workflows by app

Outlook

  • "Summarise this thread: decisions, open questions, and what's being asked of me."
  • "Draft a reply confirming the three next steps; keep it under 120 words; mark missing dates [TBC]."
  • Catch up on a busy inbox by asking which messages need action today.

Teams

  • In meetings (with transcription on and participants informed): "What did we decide? List actions with owners and due dates."
  • After meetings: "What questions were left unresolved?"
  • In chats: "Summarise what I missed in this channel since Monday."

Word

  • "Draft a proposal using /[file references] with sections: objective, approach, timeline, pricing [TBC]."
  • "Rewrite section 3 for a non-technical executive."
  • "Which statements in this draft need a source?"

Excel

  • "Add a column calculating margin %, then highlight rows under 15%."
  • "Explain this formula." / "What are the top three drivers of the change in revenue?"
  • Use Analyst for deeper analysis; verify with spot checks.

PowerPoint

  • "Create a 10-slide deck from /[Word doc] using our corporate template."
  • "Summarise this deck into 5 key messages for the CEO."

Verification habits

  • Meeting summaries: check owners, dates and whether something was agreed or merely proposed.
  • Numbers: spot-check against the workbook.
  • Grounding: ask "Which files or emails did you use?" and open the important ones.
  • Tone: AI drafts can sound generic; add your own specifics.

Copilot in Teams meetings relies on transcription or recording settings. Inform participants, follow company policy and local law (consent rules differ between the UK, EU, UAE, KSA, Pakistan and US states), and avoid transcribing sensitive conversations (HR, legal, health) unless approved.

Worked example: a project manager in Manchester

After a two-hour supplier workshop in Teams, a project manager asks Copilot for decisions, actions with owners, and open risks. The summary says "the team agreed to extend the deadline"; she remembers it was only proposed, corrects it, and checks two owner names against the attendee list. In Outlook she drafts the follow-up with Copilot and, in Excel, asks it to update the risk register from the meeting notes. Total follow-up time falls from about an hour to twenty minutes (her estimate), with every correction made before anything is sent.

Hands-on

Use Copilot (or Copilot Chat if you are not licensed) on one real meeting or document workflow. Record what it got right, what you corrected and the time saved.

Prompt patterns that work well in Copilot

  • Reference your sources: use the file and person references (type / in many Copilot experiences) so the answer is grounded in the right documents.
  • Ask for structure: "Decisions / Open questions / Actions (owner, due date)".
  • Constrain length and audience: "under 150 words for a busy director".
  • Ask what it used: "Which emails and files did you use for this?"
  • Iterate: "Keep the structure; make the tone warmer; add the budget figure from the Q3 workbook."

Save your best prompts in a shared Word document or OneNote page so the whole team benefits.

Pitfalls

  • Confusing consumer Copilot with your work Copilot and pasting work data into the wrong one.
  • Sending AI meeting summaries without checking decisions and owners.
  • Transcribing meetings without informing participants.
  • Treating generic drafts as finished.

How to measure success

Follow-ups go out faster, decisions and owners are accurate, and colleagues trust your AI-assisted summaries because you check them.

Key takeaways

  • Distinguish consumer Copilot, Microsoft 365 Copilot Chat (web-grounded, enterprise data protection) and licensed Microsoft 365 Copilot (grounded in your work data).
  • Licensed Copilot works across Outlook, Teams, Word, Excel and PowerPoint, with Researcher, Analyst, Notebooks and, in 2026, Copilot Cowork.
  • Check meeting summaries for agreed vs proposed, owners and dates; spot-check numbers and ask which files were used.
  • Inform participants about transcription and follow policy and local law; avoid sensitive meetings unless approved.

Check your understanding

Quick questions to lock in the lesson. They don’t count towards your certificate.

  1. What most distinguishes licensed Microsoft 365 Copilot from the consumer Copilot app?
  2. A Copilot meeting summary lists an action owner you don’t recognise. What should you do?
  3. What should happen before a meeting is recorded or transcribed?

Put it into practice

Use Copilot (or your organisation's equivalent) on one real meeting or document workflow. Record what it got right, what you corrected, and the time saved.

Enrol for free to save your progress

Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.