Microsoft Copilot lessons: workflows, plans, mistakes, prompt library
Reference lessons to use after the step-by-step tutorial.
Workflows
Email catch-up
- Outlook: "Summarize unread from my manager."
- Open the original emails before acting.
Spreadsheet cleanup
- "Find duplicates in column A."
- Check before deleting.
Plans compared
| Plan | Price | Storage | Copilot usage |
|---|---|---|---|
| Personal | $9.99/mo or $99.99/yr | 1 TB | Higher than free |
| Family | $12.99/mo or $129.99/yr | 2 TB shared | Owner only |
| Premium | $19.99/mo or $199.99/yr | 2 TB shared | Extensive |
| Pro | $99.99/mo | 5 TB | Highest |
Mistakes and fixes
| Mistake | Fix |
|---|---|
| Personal account for work | Switch accounts |
| Unchecked formulas | Test on sample rows |
| Trial renews | Calendar reminder |
Prompt library
Using only the attached file, draft a one-page summary for my manager:
- 3 key numbers with the cell or page they come from
- 2 risks
- 1 decision needed
Don't add facts that aren't in the file.Use-case playbooks
Excel formula you trust
- Name the columns and the period.
- Ask for the formula plus an explanation.
- Test it on 3 rows by hand.
Proposal draft in Word
- Paste your notes.
- Ask for a 1-page draft with headings.
- Rewrite the opening yourself.
Meeting follow-up
- Ask for decisions, owners and due dates in a table.
- Flag items with no owner.
- Send it after you check.
Animated walkthrough
Animated walkthrough
Press play, or pick a chapter. Each chapter animates its steps.
Troubleshooting
I hit a limit. What now?
Microsoft 365 Family includes AI features for the subscription owner only (Microsoft). Start a new chat with a short summary instead of dragging a long one.
The answer cites a page that doesn't say that.
Treat the claim as unverified. Ask: quote the exact sentence from that page that supports this, or say it isn't there. Then open the page yourself.
It forgot my earlier instructions.
Long chats push early text out of context. Put standing instructions where Microsoft Copilot keeps them (Your files live in OneDrive/Microsoft 365; Copilot works on the open document.) and start a fresh chat.
It agrees with everything I say.
Ask it to argue the other side and list the strongest evidence against your view, with sources.
How do I keep costs down?
Personal $9.99/mo or $99.99/yr; Family $12.99/mo or $129.99/yr; Premium $19.99/mo or $199.99/yr (Microsoft). Some business agent features use pay-as-you-go Copilot Credits that admins control in Cost Management.
Cost control
Microsoft 365 Family includes AI features for the subscription owner only (Microsoft).
- Test with the free tier on real tasks for a week first.
- Set a calendar reminder 2 days before any renewal.
- Keep one paid assistant, not three, unless each earns its place.
Prompt library: bad vs good
Bad: help me
Good: I have columns Date, Rep and Amount. Give me a formula for total Amount per Rep for March 2026, and explain each part.
Why: situation, task, format and limits.
Bad: research this
Good: Find the 5 most relevant official sources from the last 12 months on [topic]. For each: title, date, link, and one sentence it actually says.
Why: asks for dated, quotable, checkable sources.
Bad: make it better
Good: Rewrite this for a busy customer: max 100 words, one ask, no jargon. Then list what you cut.
Why: a reader, a length and an audit of changes.
Bad: should I do X?
Good: List the 3 strongest reasons for and against X for someone in [situation]. Mark which reasons depend on facts I should check.
Why: balanced, and separates facts from judgement.
Privacy and safety
Sign in with a Microsoft account to keep history; use your work account for work files so your company's rules apply.
- Don't paste passwords, ID numbers, card numbers or other people's private details.
- Assume the company can read and keep your chats unless its official policy says otherwise.
- For health, money or legal decisions, confirm with a professional or an official source.
Failure modes to watch
- Formulas that work on the sample but not on edge rows.
- Summaries without owners or dates.
- Answers based on the wrong account's files.
When to use it vs other bots
| Use Microsoft Copilot for | Consider another bot when |
|---|---|
|
See: ChatGPT · Claude · Gemini · Perplexity · comparison |
Leveled tutorials
Where these facts come from
- microsoft.com Copilot for individuals: personal plans and prices
- microsoft.com Copilot business pricing: business plans, Copilot Credits, training and cancellation terms
- support.microsoft.com/copilot: help (reachable)
Checked Oct 29, 2026. Plans change, so confirm on the official page before you pay.
Next: More bots →