What this covers.
Most people only ever use the prompt box. This takes you from setup to the Wave 3 powers, the best free ways to learn, and the tools worth pairing with Copilot by role.
The free 2-hour Wave 3 course with Sabrina Ramonov and trainer Sheree Brock. Watch on YouTube if the player does not load. This guide is built from that course plus Microsoft Learn and the monthly Copilot release notes.
Learn Copilot your way.
Take this 16-question check to see how you prefer to take in new information. Your result tailors how to work through this guide. Then keep scrolling; the whole cheat sheet is still here for everyone.
Get set up.
Most "it does not work" complaints trace back to skipped setup, not the AI.
Confirm access
You need a Copilot license, or use free Copilot Chat (web only). A license unlocks the Wave 3 "Edit with Copilot" powers in the apps.
Clean up sharing
Copilot only sees what you can see. Fix oversharing in SharePoint and OneDrive first.
Custom instructions
Settings, then Personalization. Tell it how to answer you: honest feedback, plain language, bullet points.
Saved memories
Let it remember your role and projects. Setting them in Personalization beats saving mid-chat.
Pin it everywhere
Turn it on in Word, Excel, PowerPoint, Outlook, and Teams, plus the Windows app and Edge sidebar.
Pick 2 or 3 tasks
Do not explore once and quit. Choose concrete jobs: triage my inbox, build this tracker, draft this recap.
The homepage is a workspace.
Most people treat it as just a prompt box. Here is what else lives on that screen and left rail.
Prompt Gallery
Ready-made prompts that pull from your real files. "Prepare me for a one-on-one" gathers the right docs, meetings, and chats.
Search
The underrated one. A search engine across your whole org: every meeting, Teams message, email, and SharePoint site.
Create
Images, one-sentence videos, infographics, roadmaps, posters, and a reusable brand kit with your colors.
Pages
Turn any answer into an editable canvas. Rewrite and reorder sections like a Word doc, then share or push to PowerPoint.
Notebooks
A private desk grounded only in the files you add, with citations. Good for one policy or project.
Temporary chat
No history, no memories, and it ignores your custom instructions for one-off questions.
Schedule prompts
Reuse a favorite prompt on a timer. Example: every Monday, sort my weekend emails by importance.
Models and Web / Work
Pick GPT-5.2 or leave it on Auto (agents run on Claude). Toggle Web for the internet or Work for your data.
Backslash to tag
Type "/" to tag a file, meeting, or person, including anything shared with you across OneDrive, Teams, and Outlook.
Talk to it like a teammate.
The Prompt Coach agent teaches this four-part recipe. Hit three of four and results jump.
Goal
What you want back. "Rewrite this email to sound more professional."
Context
Why and for whom. "Going to a coworker; clear but friendly."
Source
Point to the file, email, or meeting. "Use the email below."
Expectations
Format and tone. "Keep it four to six sentences."
Give a task, get a result.
Unlike chat, you hand an agent a goal and it does the whole job. These are built by Microsoft and ready under "All agents."
| Agent | What it does for you | |
|---|---|---|
| Researcher | Best first agent. Returns a 5 to 7 page, expert-level report with cited sources from one goal. | Start |
| Analyst | Complex, multi-step data analysis over your files. Ask "any trends I am missing?" on a messy spreadsheet. | 2026 |
| Prompt Coach | The most underrated one. Guides you to a great prompt before you run the heavy agents. | 2026 |
| Facilitator | Replaces meeting notetakers: live notes, action items, owners, and follow-up scheduling. | 2026 |
| Career Coach | Reality-check on a promotion: the skills gap and an 18-month plan. Talk to leadership too. | 2026 |
| Idea Coach | Structured brainstorming partner for planning and problem-solving. | 2026 |
| Learning Coach | Builds learning plans and points to courses. Ask it to keep resources free. | 2026 |
| Build your own | Create custom agents in Copilot Studio. Some teams run whole workflows on them. | Advanced |
Inside the apps now.
Wave 1 was drafting; Wave 2 added Pages and Notebooks; Wave 3 puts agents inside the apps. Look for the "Edit with Copilot" button.
Excel
- Build an entire tracker or dashboard from one prompt
- Add sheets, dropdowns, charts, and fix formulas by asking
- Turn a Word or PowerPoint file into structured data; clean messy data
- Double-click any cell to see the formula it wrote
Word
- Rewrite and restructure sections, not just summarize
- Edit formatting by prompt: bold, color, insert tables and charts
- Rewrite for a new audience: finance to legal, technical to plain
- Turn a 150-page report into a 1 to 2 page executive brief
PowerPoint
- Build a deck from a topic or from an existing file
- Add a slide or a whole section, with automatic speaker notes
- Use brand kits and templates; ask Copilot to make images
- Find slides from your team's past decks; pair with Designer
Outlook
- Draft and rewrite replies; change tone (shorter, casual, direct)
- Set draft instructions so it sounds like you, not like AI
- Triage the inbox: what matters most, what needs urgent replies
- Summarize a month of email into a prioritized action list
Five beginner rules.
Copilot, not autopilot
Always review the output. The moment AI never makes a mistake is the moment it does not need you.
Ask AI first
Beat the blank page. "I am a [role]; what custom instructions should I use?" Let it draft, then tweak.
Let it ask you
Prompt Coach and clarifying questions force you to get clear on what you actually want.
Kill the AI tells
In Outlook draft instructions, ban openers like "I hope you are well" and stray em dashes so it reads like you.
Search is not chat
Chat does something for you and may find only a few files. Search is built to find everything across your org.
Bring your other apps in.
Your Microsoft apps already talk to each other, so you skip stitching ten tools together. Connectors extend that to outside systems: 100+ available, and 2026 adds federated ones that query live, with a citation and your permissions on every result.
Popular ready-made
- Salesforce CRM, ServiceNow, Confluence, Box
- Google services, MediaWiki, Azure services
- Zendesk Help Center, Egnyte, Amazon S3
- Asana, Monday.com, Coda, Guru, GitLab Issues
Federated (live) 2026
- Query the source system in real time, no stale index
- Every answer carries a citation back to the record
- Runs on your identity and permissions
- Works in Chat, Researcher, and Agent Mode in Excel
Free ways to get good.
Follow a few creators, then work a free course. Best path: Microsoft Learn, the Wave 3 course, then a certificate.
Sabrina Ramonov
The free 2-hour hands-on Wave 3 course with trainer Sheree Brock, plus free prompts, automations, and a community.
Kevin Stratvert
Ex-Microsoft PM and the most Reddit-recommended teacher. Real business scenarios, not toy demos.
Mike Tholfsen
Fast "tips and tricks" videos for Copilot and M365. Great for quick five-minute wins.
| Program | Why it is good | |
|---|---|---|
| Microsoft Learn: Get started with M365 Copilot | Official, beginner-friendly path across the apps. No AI background needed. | Free |
| Sabrina Ramonov + Sheree Brock: Wave 3 course | Two hours, hands-on inside the actual apps. This guide is built from it. | Free |
| Microsoft AI-Powered Work Bootcamp | Microsoft's own bootcamp with AI thought leaders and live sessions. | Free |
| Great Learning: Intro to M365 Copilot | Self-paced with a free completion certificate. | Free + cert |
| Microsoft AI Skills / LinkedIn Career Essentials | Free certificate from Microsoft and LinkedIn that displays on your profile. | Free + cert |
Copilot & AI at Work
By Danny de Vries and team. "Less hype, more proof." The most on-topic newsletter.
Nate's Newsletter
Home of the Microsoft AI Copilot Roadmap plus tested prompts and adoption case studies.
What's New in Copilot
The monthly Microsoft Tech Community posts, plus the Release Notes and public Microsoft 365 Roadmap.
Free tools that stack with Copilot.
"Free" means a free tier or download. Connectors still need the underlying app and an admin toggle.
Sales
- Researcher agent for cited account and market briefs
- Copilot Search to rebuild history with a prospect
- HubSpot CRM (free tier) pairs with the CRM connector
- Prompt Gallery for ready-made sales prompts
- Salesforce connector to index accounts and leads needs Salesforce
- Microsoft Forms for free lead and discovery surveys
Customer Satisfaction
- Analyst agent for trends across support and survey data
- Excel Edit with Copilot to add an AI summary column to free-text replies
- Microsoft Forms for free CSAT and NPS surveys
- Service Agent for support scenarios
- Zendesk Help Center connector grounds answers in your KB
- Clipchamp (free) for quick how-to videos
Supply Chain
- Excel Edit with Copilot to build a tracker or dashboard from one prompt
- Analyst agent for demand and inventory trends
- Power Automate (free tier) for reorder and alert flows
- Amazon S3 and Monday.com connectors to pull ops data in
- Supplier Communications Agent for order confirmations D365 SCM
- Power BI (free) for dashboards Copilot can summarize
Proposal Creation
- Word Edit with Copilot to draft, restructure, and retarget for audience
- Pages to PowerPoint to turn a draft into a client deck with notes
- Researcher for polished, cited reports
- Create (brand kit + images) for on-brand visuals and covers
- Notebooks to ground the proposal only in your project files
- CRM and finance connectors to pull real numbers into the pitch
People first, then the tools.
Copilot is at its best when it serves the people and the goal, not the other way around. The same principle behind the transformation flywheel.
See the Strategy → Let's connect