Tau
Microsoft Copilot · 11 lessons

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.

Essential 1

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.

Essential 2

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.

Essential 3

Ask Excel questions in plain English

Ask Copilot in Excel to analyse a table, add formulas and build a chart, then check its working.

Essential 4

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

  1. 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.”

  2. 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

  1. 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.”

  2. 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.”

  3. 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.”

  4. 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?”

  5. 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

  1. 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.”

  2. 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

  1. 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.”

  2. 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 365

One app for chat, Cowork and Office files; free tier plus Microsoft 365 plans.

Freemium

Microsoft Edge

Best for: Copilot beside any web page

Copilot sidebar summarises pages and compares tabs; Cowork can use Edge for web steps.

Free

Microsoft Copilot Studio

Best for: Building custom agents for your team

Low-code tool for building agents grounded in your organisation's files and systems.

Paid
Hands-on project

Do 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.

Guide · Microsoft · 8 min

Copilot app updates for personal, work and school accounts

What changed in the unified Copilot app, what was retired and key deadlines.

Guide · Microsoft · 5 min

Copilot pricing plans for individuals

Official comparison of free Copilot and Microsoft 365 Personal, Family, Premium and Pro.

Guide · Microsoft · 6 min

Microsoft Copilot privacy controls

How to opt out of model training and manage personalisation and memory.

Course · Microsoft Learn · 40 min

Work smarter with AI

Free beginner learning path on using Copilot for workplace tasks responsibly.

Guide · Microsoft Learn · 15 min

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.