M365 Copilot Hands-on Training for Power Users — User Guide

Hands-on exercises covering prompting best practices, Copilot tips by app, live demo scenarios, best practices playbook, and upcoming features.

📋
Overview

Session Agenda

60 min
Agenda 60-Minute Session Timeline
Time Segment
0:00 – 0:15 What Makes a Great Copilot Prompt
0:15 – 0:25 M365 Copilot Tips & Tricks by App
0:25 – 0:40 DEMO: Real-World Scenarios
0:40 – 0:50 Best Practices & The Copilot Playbook
0:50 – 1:00 New & Coming Soon: Edit with Copilot
✍️
Part 1 · 15 min

What Makes a Great Copilot Prompt

~15 min
Concept Why Prompting Matters

Copilot is only as good as what you ask.

  • Vague prompts → generic, unhelpful responses
  • Specific prompts → save hours every week
Quality Description
MEH Vague one-liner
OK Some context added
WOW Goal + Context + Format + Source
Framework The 4 Elements of a Great Prompt
  1. 1 Goal — What do you want Copilot to do?
  2. 2 Context — Who’s the audience? What’s the background?
  3. 3 Expectations — Format, length, tone, constraints
  4. 4 Source — Which data, files, or emails to use
Giraffes Can See Everything — Goal, Context, Source, and Expectations

Here is a mnemonic to help you remember the four elements.

Examples Prompt Makeover: Before & After

Email

Before (Vague)
Write an email about the project
After (Great)
Draft a concise 3-paragraph email to my project stakeholders summarizing this week's progress on the Azure migration, noting the 2-day delay in Phase 2, and requesting feedback by Friday. Tone: professional but direct.

Meeting

Before (Vague)
Prep me for my meeting
After (Great)
I have a 30-minute 1:1 with my manager tomorrow. Review my last 3 emails to them, any action items they've assigned me, and my calendar for this week. Give me a 5-bullet brief.

Document

Before (Vague)
Write a summary
After (Great)
Summarize the key decisions and open questions from /Finance Q1 Review.docx in bullet format, no longer than one page, for an exec audience.
💻
Part 2 · 10 min

M365 Copilot Tips & Tricks by App

~10 min
Outlook Outlook Copilot
  1. 1Summarize threads — Catch up on a 50-message thread in 10 seconds
  2. 2Draft with context — Pull in meeting notes, prior emails, and files
  3. 3Coaching — Get tone and clarity feedback before you hit send
  4. 4Triage your inbox — Prioritize what matters, ignore what doesn’t
Pro Tip
Summarize this thread and tell me what action I need to take
Teams Teams Copilot
  1. 1Meeting recap — Get a summary + action items after any meeting
  2. 2Catch up mid-meeting — Join late? Ask “What did I miss?”
  3. 3Chat intelligence — Search across chats to find past decisions
  4. 4Draft a reply — Let Copilot suggest your response in any chat
Pro Tip
What decisions were made and what are the open items?
Word Word Copilot
  1. 1Draft from scratch — Give an outline, get a full draft
  2. 2Rewrite & improve — Select any section, ask for a rewrite
  3. 3Summarize long docs — Get a TL;DR for any document
  4. 4Reference other files — Pull data from Excel or another Word doc
Pro Tip
Rewrite this section to be more concise and executive-ready
PowerPoint PowerPoint Copilot
  1. 1Create from prompt — Describe your topic, get a full deck
  2. 2Add slides from Word — Turn a Word doc into a slide
  3. 3Speaker notes — Auto-generate notes for any slide
  4. 4Design ideas — Get layout suggestions instantly
Pro Tip
Create a 5-slide deck based on /Q1 Report.docx
Excel Excel Copilot
  1. 1Formula help — Describe what you need, Copilot writes the formula
  2. 2Data insights — Ask “What are the top trends in this data?”
  3. 3Python in Excel — Run advanced analysis with natural language
  4. 4Charts — Ask Copilot to visualize your data automatically
Pro Tip
Highlight rows where Q1 sales dropped more than 15% vs. last year
🎬
Part 3 · 15 min

Demo: Real-World Scenarios

~15 min

Follow along on your own device!

Demo 1 Triage Your Inbox — Outlook

Scenario: Monday morning, 47 unread emails

Live Prompt
Summarize my unread emails from the last 48 hours. Highlight anything urgent, flag action items, and tell me what I can ignore.

Expected Outcome

  • Urgent items surfaced immediately — no inbox scrolling
  • Action items extracted and listed by priority
  • Low-priority threads identified for bulk archive
  • Time saved: 20–30 minutes of manual triage
Demo 2 Prep for a Big Meeting — Outlook

Scenario: QBR with your VP in 30 minutes

Live Prompt
I have a QBR with my VP in 30 minutes. Check my last 5 emails related to our Q1 results. Give me a 5-point brief with any risks I should flag.

Expected Outcome

  • 5-bullet executive brief ready in under 60 seconds
  • Risks and open items surfaced from your emails
  • You walk in prepared — not scrambling for context
Demo 3 Draft a Report in Minutes — Word

Scenario: Need a project status report by EOD

Live Prompt
Draft a one-page project status report for the Azure Migration project. Pull from /Project Notes.docx and the last 3 emails with subject 'Azure Migration'. Include: current status, blockers, next steps. Audience: VP level.

Expected Outcome

  • Full draft generated in seconds — grounded in your files
  • Proper structure: status, blockers, next steps
  • VP-ready tone applied automatically
  • You edit and refine instead of starting from scratch
Demo 4 Unlock Hidden Data Insights — Excel

Scenario: Monthly sales data, need quick insights

Live Prompt
Look at this sales data and tell me: which 3 regions underperformed vs. last quarter, what's the YoY trend, and suggest a chart that would work best for an exec presentation.

Expected Outcome

  • Underperforming regions identified instantly
  • YoY trend analysis with natural language explanation
  • Chart recommendation matched to exec audience
  • Python in Excel runs complex analysis without formulas
💡
Part 4 · 10 min

Best Practices & The Copilot Playbook

~10 min
Best Practices Top 8 Copilot Best Practices
  1. 1Always give context — who, what, why
  2. 2Specify your audience and format
  3. 3Iterate — refine prompts when first answer isn’t right
  4. 4Reference specific files with /
  5. 5Review everything before sending
  6. 6Use Copilot to catch your own mistakes
  7. 7Start every morning with a briefing
  8. 8Share great prompts with your team
Pitfalls Common Pitfalls to Avoid
Don’t Do Instead
Send without reviewing Always review AI-generated content
Use vague one-liners Add context, format, and audience
Repeat the same failing prompt Change one variable and retry
Rely on Copilot for facts Verify statistics and quotes
Ignore the /file reference Ground Copilot in YOUR data
Playbook The Copilot Playbook
  1. 1START — Replace 1 manual task per day with Copilot
  2. 2BUILD — Create a personal prompt library
  3. 3SCALE — Share wins, build team playbooks
💬 Remember
The teams that win with AI aren’t the ones with the fanciest tools. They’re the ones who build habits.
🧠
Personalization

Memory & Custom Instructions

Setup Custom Instructions in Settings

Access Custom Instructions in Settings → Personalization. Copilot uses these to tailor every response to your preferences.

Below are example custom instructions organized by category. Copy each one into your Custom Instructions to personalize Copilot.

Instructions Core Principles
Custom Instruction
Core Principles Copilot prioritizes accuracy, clarity, and trust. Always distinguish verified facts from inferred reasoning. Never present assumptions or context-based reasoning as fact. Avoid cascade errors by rechecking each step before responding. Think deeply before answering. When uncertain, ask clarifying questions or present two to three vetted options with pros and cons.
Instructions Tone by Audience
Custom Instruction
Tone by Audience Internal or Collaborative Audience Collaborative and supportive. Slightly informal and pragmatic. Quick confirmations and concise language. Use only when the audience is clearly internal. Example language: "Thanks for sharing." "Would it work to proceed this way?" "Appreciate your support." Customer or External Audience Professional, courteous, and reassuring. Formal greetings and closings. Avoid jargon unless contextually relevant and explained. No slang or overly casual language. Provide clear next steps and timelines. Example language: "Looking forward to discussing the way forward." "We completely understand the need to address this carefully." "Sounds like a great opportunity."
Instructions Content Labels
Custom Instruction
Content Labels Use explicit labels consistently. [Verified] Facts confirmed by authoritative sources. [Inference] Logical conclusions based on context. [Confidence] Confidence cues for inferred content such as "Likely" or "Based on observed patterns." [Unverified] Claims not yet confirmed. [Glossary] Acronyms clarified on first use. When mixing content, present verified facts first, then clearly disclose inferred content with this disclaimer: "The following points are inferred based on available context and may require validation."
Instructions Data Sourcing & Accuracy
Custom Instruction
Data Sourcing and Accuracy Search enterprise content first. Files. Emails. Chats. Meetings. Transcripts. Resolve contradictions before responding. Preserve critical qualifiers in summaries. Never fabricate citations, quotes, or references. If confidence is low, state what is known, state what is unknown, recommend next steps. For legal or regulatory topics: verify jurisdiction and verify effective dates. For time sensitive topics: check date stamps, warn about staleness, add freshness disclaimers when appropriate. If no authoritative source exists: state "No authoritative source found" and propose next steps such as further internal or external research. Never present inferences as facts.
Instructions Output Guidelines
Custom Instruction
Output Guidelines Always include a TLDR at the top of emails and documents. Present information in a logical order: verified facts first, inferences second, recommendations and next steps last. Use clear section headings. Avoid decorative characters such as hyphens when writing text. Be concise while preserving precision. Never guess or fill gaps with plausible language. State clearly when information is missing. Surface multiple interpretations when they exist and explain tradeoffs. Favor clarity and honesty over completeness when certainty is low.
Memory Challenge My Thinking
Memory Prompt
Remember that you don't always have to agree with me on everything. In fact I like to have my opinion challenged to make sure I'm thinking about all the different sides of it. Can you do that in all of my chats with you?
💬
Power Tips

Additional Useful Prompts

Prompt Plain Text Output

When you want the output to be just a block of text (no formatting):

Prompt
Output the results only as a block of plain text. Do not include any other text. Always treat the block of plain text as a block of code that uses text as the code language. Always include a copy button to copy the contents of the box. Do not include sources.
Prompt Get the Resultant Prompt

Useful when running out of iterations (maximum of 30 iterations per chat). Get the prompt that got you to the current result so you can continue in a new chat:

Prompt
What is the resultant prompt so far?
Prompt Blocking Off Calendar

Quickly block time on your calendar without switching apps:

Prompt
Place the following hold on my calendar. Call it 'HOLD: Important Meeting' No agenda, no attendees. Just trying to block time that I offered for a QBR. All day event. The date is 6/15/2026.
🚀
Part 5 · 10 min

New & Coming Soon

~10 min
Available Now Edit with Copilot

Inline AI editing directly within your documents. Select text, choose an action, Copilot rewrites in place.

  • Rewrite for tone, length, or clarity
  • Expand or condense any selection
  • Fix grammar and polish language
  • Accept, reject, or refine suggestions

Example

Before “The thing about this project is that it has been going on for a while and there have been a lot of issues.”
Copilot action Make this concise and professional
After “This project has experienced ongoing delays and significant challenges.”

Available now in Word, Outlook, Teams, and PowerPoint

Roadmap What’s Coming Next
  • Copilot in Forms and Loop — Intelligent form generation and collaborative Loop components powered by Copilot
  • Voice-activated Copilot in Teams — Speak your prompts during live meetings — Copilot listens, summarizes, and acts in real time
  • Copilot agents for automated workflows — Build and deploy autonomous AI agents that handle multi-step processes without manual intervention
  • Deeper SharePoint & OneDrive integration — Copilot surfaces, organizes, and acts on content from across your entire document ecosystem
🏆
Wrap-Up

Key Takeaways

Summary Remember These
  1. 1A great prompt = Goal + Context + Expectations + Source
  2. 2Build one habit at a time — start with your inbox
  3. 3Share your best prompts — the whole team wins

Resources

Copilot Lab m365copilot.com
Prompt Gallery aka.ms/CopilotPrompts
📄
Reference

Prompt Cheat Sheet

Cheat Sheet Quick-Start Prompts by Scenario
Scenario Starter Phrase
Email help “Draft an email to [name] that…”
Meeting prep “Brief me on my [meeting] — check my emails and calendar…”
Summarize “Summarize the key points of [doc/thread] for [audience]…”
Rewrite “Rewrite this to be more [concise/formal/friendly]…”
Analyze “Look at [data] and tell me [insight]…”
Action items “Extract all action items from [doc/meeting]…”