How to use Microsoft Copilot at home and at work
Work out which Copilot you have, then use it to draft documents, question spreadsheets and catch up on emails and meetings. For anyone using Windows or Microsoft 365, at home or at work.
Who it’s for: Windows and Microsoft 365 users at home, school or work.

Microsoft has several products called Copilot, which is why many people aren't sure which one they have. There's the free Copilot app, Copilot in Microsoft 365 home plans and Microsoft 365 Copilot at work. They look similar but differ in features and data rules. So this course starts by working out which one you've got.
Then you'll put it to work in the apps you already use. You'll draft a Word document from your notes and an older file, then rewrite sections in the right tone. You'll ask Excel a question in plain English, get formulas and a chart back, and check its working. You'll turn a long Outlook thread or a missed Teams meeting into a list of decisions and your own action items.
Later lessons cover sharing your screen with Copilot, turning off training and managing memory. You'll hand it multi-step tasks with Copilot Cowork, and use Researcher and Analyst for evidence-backed reports. You'll also build a simple Copilot Studio agent that answers only from one handbook, and test it before sharing. The course is for anyone who uses Windows or Microsoft 365, at home or at work. Throughout, you'll use only the Copilot your plan or employer allows.
By the end you’ll be able to…
- Tell free Copilot, Microsoft 365 home plans and work Copilot apart
- Draft a Word document from your notes and an existing file
- Ask Excel a plain-English question and get a chart back
- Turn off model training and manage memory in Copilot settings
Short on time? Start with the essentials
These 4 lessons cover the most useful ideas in this course. Each one takes about a minute.
Which Copilot do you have? Free, home or work
Identify whether you're using free Copilot, Copilot with a Microsoft 365 home plan or Microsoft 365 Copilot at work.
Draft a Word document from notes and an old file
Use Copilot in Word to draft from your notes and a reference file, then rewrite sections in the right tone.
Ask Excel questions in plain English
Ask Copilot in Excel to analyse a table, add formulas and build a chart, then check its working.
Catch up on long threads and missed meetings
Summarise an Outlook thread and a Teams meeting recap into decisions and your action items.
Every lesson in this course
This course has 11 video lessons of about a minute each, from the basics to expert habits. Each one ends with a question, three takeaways and its sources.
Foundations 2 lessons
Which Copilot do you have? Free, home or workEssential
Identify whether you're using free Copilot, Copilot with a Microsoft 365 home plan or Microsoft 365 Copilot at work.
“Free Copilot, Copilot in Microsoft 365, Copilot at work: not the same thing.”
Pick a home plan: Personal, Family, Premium or Pro
Compare Microsoft 365 home plans on Copilot usage and features, including who in a family can use AI.
“The Family plan covers six people, but Copilot works only for the owner.”
Building skills 5 lessons
Draft a Word document from notes and an old fileEssential
Use Copilot in Word to draft from your notes and a reference file, then rewrite sections in the right tone.
“Point Copilot at last year's report and your notes; get this year's first draft.”
Ask Excel questions in plain EnglishEssential
Ask Copilot in Excel to analyse a table, add formulas and build a chart, then check its working.
“'Which product's sales fell fastest?' Ask Excel in plain English, get a chart.”
Catch up on long threads and missed meetingsEssential
Summarise an Outlook thread and a Teams meeting recap into decisions and your action items.
“Missed the meeting? Ask what was decided and what's assigned to you.”
Ask Copilot about what's on your screen
Share your screen or camera with Copilot, or use it in Edge, to compare options on the page you're viewing.
“Share your screen and ask: which of these three flights is really cheaper?”
Turn off training and manage Copilot memory
Opt out of training on text and voice, manage or delete memory, and know the separate rules for work accounts.
“Copilot can learn from your chats unless you opt out. Here's the toggle.”
Advanced 2 lessons
Delegate a multi-step task with Copilot Cowork
Brief Cowork on a multi-step task using your files, approve its actions and review the output.
“Cowork plans the steps, uses your files and checks with you before acting.”
Use Researcher and Analyst for evidence-backed work
Choose Researcher for multi-source reports and Analyst for data crunching, and verify their outputs.
“Researcher reads your files and the web; Analyst works through the numbers.”
Expert 2 lessons
Ground a Copilot Studio agent in one handbook
Build a simple Copilot Studio agent that answers only from one policy handbook, and test it on five questions with known answers before sharing it.
“An HR-policy agent that answers from your handbook, built without code.”
When Copilot beats ChatGPT, Gemini or Claude
Decide when Copilot's access to your Microsoft 365 files makes it the best choice and when another tool fits.
“If your files live in OneDrive and Teams, Copilot can see what others can't.”
Apps we recommend
These are the tools this course uses, and what each one is best for. We have no partnership with any of them.
Microsoft Copilot
Best for: AI help across Windows and Microsoft 365One app for chat, Cowork and Office files; free tier plus Microsoft 365 plans.
FreemiumMicrosoft Edge
Best for: Copilot beside any web pageCopilot sidebar summarises pages and compares tabs; Cowork can use Edge for web steps.
FreeMicrosoft Copilot Studio
Best for: Building custom agents for your teamLow-code tool for building agents grounded in your organisation's files and systems.
PaidDo one real piece of weekly work with Copilot
Take a task you do in Microsoft 365 every week or month, such as a report, meeting follow-ups or a data summary. Draft it in Word from your notes and last version, analyse the numbers in Excel and pull actions from Outlook or Teams, using only the Copilot your plan or employer allows.
What you’ll make: The finished document, plus a short note of each Copilot step, what you changed and the time it took.
Check your own work
- The note names the Copilot version used and confirms it is the one your plan or employer allows
- Every number taken from Excel is checked against the source table
- Action items from Outlook or Teams match the actual thread or meeting recap
- At least two Copilot drafts were rewritten by you, with what you changed noted
- Copilot was pointed only at the files the task needed
Further reading and viewing
We’ve chosen these articles, research papers, videos and guides from other trusted sources.
Copilot app updates for personal, work and school accounts
What changed in the unified Copilot app, what was retired and key deadlines.
Copilot pricing plans for individuals
Official comparison of free Copilot and Microsoft 365 Personal, Family, Premium and Pro.
Microsoft Copilot privacy controls
How to opt out of model training and manage personalisation and memory.
Work smarter with AI
Free beginner learning path on using Copilot for workplace tasks responsibly.
Release notes for Microsoft 365 Copilot
Official running log of new Microsoft 365 Copilot features for work accounts.
Questions about this course
Which version of Copilot do I have?
Look at how you sign in. With a personal Microsoft account and no subscription, you're likely using free Copilot. With a Microsoft 365 Personal or Family plan, you may have Copilot inside Word, Excel and Outlook at home. If your employer gives you a work account, it may include Microsoft 365 Copilot, with its own data rules set by your organisation.
How do I use Copilot in Excel?
Open a table in Excel and ask Copilot a question in plain English, such as which month had the highest sales. It can suggest formulas, highlight patterns and build a chart. Always check its working, because it can misread a column or pick the wrong range. Formatting your data as a proper table with clear headings helps it understand.
Is Microsoft Copilot safe for work documents?
It depends on which Copilot you use and what your employer allows. Work accounts with Microsoft 365 Copilot follow your organisation's own data rules, which differ from those for personal accounts. Don't paste confidential work files into a personal or free tool. If you're unsure, ask your IT team which AI tools are approved before you use them.
Can Copilot summarise a Teams meeting?
Yes, where your plan and your organisation's settings allow it. Copilot in Teams can recap a meeting, pull out decisions and list who agreed to do what. It's a good way to catch up on a meeting you missed. Still, check the recap against the transcript or with a colleague before acting on it, especially for deadlines and commitments.
Is this course free?
Your first five lessons in Tau are free, so you can try it before deciding. Tau Pro opens every lesson in every course, from foundations to expert. Each lesson is a short video of about a minute, followed by one question and three takeaways. Prices are shown in your local currency, and you can cancel any time.
Get early access to this course
Tau opens soon. Join the waitlist and we’ll email you as soon as you can start this course.
We’ll only email you about Tau, and you can unsubscribe any time. Privacy policy.
We’ll email you as soon as Tau opens.


