AI at Work

Top 10 Microsoft 365 Copilot skills worth learning

The Copilot skills that save time are knowing what your licence lets Copilot see, then using it in meetings, Outlook, Word, Excel and PowerPoint, and grounding answers in Notebooks, Pages, Researcher, Analyst and simple agents. Several of these need the paid Microsoft 365 Copilot licence, so check which version each person has before training them.

Why the licence comes first

Microsoft now describes three levels. Copilot Chat (Basic) is included with eligible Microsoft 365 subscriptions and answers from the web, plus any file you upload or the email or chat you have open. Microsoft 365 Copilot (Basic) adds standard access to Copilot inside Word, Excel, PowerPoint and OneNote. The paid Microsoft 365 Copilot add-on, which Microsoft calls Premium, grounds answers automatically in your email, files, meetings and chats through Microsoft Graph.

Microsoft is also renaming its apps: the Microsoft 365 Copilot app is now called Microsoft Copilot. In-product labels show which experience a person has. Features vary with licence and with your organisation's settings, so what one colleague sees may not match another.

The list below is in the order we would teach it. Each item says what the skill is, where it helps and what it needs.

1. Know whether Copilot can see your work

  • What to learn: tell a web-grounded answer from a work-grounded one, and know when you need to upload or open a file for Copilot to use it.
  • Where it helps: every other item on this list. Most disappointing answers come from asking Copilot about files it cannot reach.
  • What it needs: nothing extra. With Copilot Chat (Basic), Microsoft says you must upload the file, work with open content in Outlook or Teams, or use a pay-as-you-go agent with access to organisational content.

If you are weighing Copilot against Claude for particular jobs, see Claude or Microsoft 365 Copilot? Choose by the work you need done.

2. Recap a Teams meeting and run Facilitator

Copilot in a Teams meeting summarises key points, including who said what, suggests action items and answers questions during or after the meeting. To ask about the meeting afterwards, live transcription has to be on during it. Intelligent recap needs Teams Premium or a Microsoft 365 Copilot licence, and Copilot does not work in meetings hosted outside your organisation.

Facilitator goes further in scheduled meetings. It takes notes that participants can edit in a Loop page, tracks the agenda, captures tasks you can sync to Planner and summarises decisions and open questions. Microsoft says a Copilot licence is needed to add it, and it cannot be added to channel meetings, instant meetings or Teams calls. External participants do not see its updates.

  • What to learn: when to turn on transcription, how to ask Copilot what was decided, and how to check the actions before they go out.
  • What to check: an action with no clear owner in the transcript should stay a question.

3. Summarise an Outlook thread and draft the reply

  • What to learn: select Summary by Copilot at the top of a conversation. The summary can include numbered citations that take you to the email each point came from.
  • Where it helps: long threads you have been copied into, and catching up after leave.
  • What it needs: a work or school account, or certain personal Microsoft accounts; third-party addresses such as Gmail do not get Copilot in Outlook. Microsoft lists drafting emails, summarising threads and coaching on tone among the Outlook features.
  • What to check: open the cited email for anything you will act on, particularly dates and amounts.

4. Draft in Word from your own files

  • What to learn: type / in the Copilot pane to pick a document, email or meeting for Copilot to work from, then ask for a draft, a summary or a rewrite of selected text.
  • Where it helps: first drafts of reports, briefings and procedures that should reflect existing material.
  • What it needs: Microsoft says Copilot in Word is available with an eligible Microsoft 365 subscription or a Copilot licence, subject to your organisation's settings.
  • What to check: the draft against the files you referenced. A fluent paragraph can still blend two sources that disagree.

5. Analyse and edit in Excel

Copilot in Excel has three modes. Edit, the default, changes the workbook directly. Plan proposes an approach for you to confirm first. Chat only answers questions without changing anything. It can write formulas, build charts and PivotTables, sort and filter, and search the web with citations.

  • What to learn: choose the mode on purpose, and use Plan for any workbook other people rely on.
  • What to check: that the cell actually changed and the totals that depend on it are still right.

The checks are set out in Copilot gave you a formula. Did the workbook actually change?.

6. Build a PowerPoint deck from a Word document

  • What to learn: open your organisation's template first, then ask Copilot to create the presentation from a Word document. Microsoft says starting from a template tells Copilot to keep its theme and design.
  • Where it helps: turning a report or proposal into a first deck.
  • What it needs: Microsoft advises using Word Styles so Copilot can see the document's structure, and says it works best with Word documents smaller than 24 MB. If your organisation has a brand kit, Copilot applies it.
  • What to check: every figure on a slide against the source document.

7. Work from a Copilot Notebook

  • What to learn: gather the files, pages, meeting notes, chats and links for one piece of work into a notebook, and ask Copilot questions against that set.
  • Where it helps: a project, a client matter or a recurring report where the same sources come up every time.
  • What it needs: Microsoft says a Microsoft Copilot or Copilot Chat licence is required, and creating notebooks also needs a SharePoint or OneDrive licence. Open it from Notebooks in the Copilot app.
  • What to check: whether the notebook still holds the current version of each file.

8. Turn a chat answer into a Copilot Page

  • What to learn: under a Copilot response, open the menu and choose Edit in Pages, then keep editing the page with Copilot and share it with colleagues.
  • Where it helps: project briefs, meeting notes and plans that several people will refine.
  • What it needs: Microsoft says Pages is available to work and school accounts with SharePoint or OneDrive storage, even without a Microsoft 365 Copilot licence.
  • What to check: a page is a working draft. Move the agreed version into the document or system where your team keeps its records.

9. Use Researcher and Analyst

Researcher handles multistep research and produces a structured report with cited sources, drawing on the web and, for work accounts, on your own files within your existing permissions. Microsoft says business users need a Microsoft 365 Copilot add-on licence for it.

Analyst works from a plain-language question over data in Excel files, CSV files and similar sources, and returns a report with charts and tables. Both are found under Agents in the Copilot app. If one is missing, Microsoft says your administrator may not have enabled it.

  • What to learn: when a question deserves a research report rather than a quick chat answer.
  • What to check: open the sources Researcher cites, and recalculate any figure from Analyst that will be used in a decision.

10. Build a simple agent

  • What to learn: use Agent Builder in the Copilot app or Teams to make a focused assistant with its own instructions and knowledge, such as SharePoint content. Microsoft gives a team onboarding agent as an example.
  • Where it helps: questions colleagues ask repeatedly about one body of material.
  • What it needs: access depends on the licences in your tenant. With Copilot Chat, Microsoft includes agents grounded in instructions and public websites; agents with organisational content are pay-as-you-go. Agent Builder cannot add actions that call outside services; for those, Microsoft says to copy the agent to Copilot Studio.
  • What to check: who can open the SharePoint files behind the agent. Microsoft notes that file permissions may need to be updated by hand for the agent to answer.

How to start

  • Check each person's licence and the in-product label before any training, so nobody is taught a feature they cannot see.
  • Start with items 1 to 4. They cover most of a working day and need the least setup.
  • When a prompt works in Word or PowerPoint, save it. Microsoft lets you save prompts to reuse, and saved prompts are visible only to you.
  • Practise each skill on a real piece of the person's own work, then return to the next real example a week later.

For training built around these skills, see our Copilot training in Ireland.

Common questions

Is Copilot Chat the same as Microsoft 365 Copilot?

No. Microsoft describes Copilot Chat (Basic) as included with eligible Microsoft 365 subscriptions and grounded in the web, with your own content only when you upload or open it. The paid Microsoft 365 Copilot add-on grounds answers automatically in your email, files, meetings and chats.

Which of these skills work without the paid Copilot licence?

Copilot Pages, for work accounts with SharePoint or OneDrive storage, and agents grounded in instructions and public websites are available without it. Researcher and Facilitator need a Copilot licence. Features in Word, Excel, PowerPoint and Outlook depend on your subscription and your organisation's settings.

Why can Copilot not find our company files?

Without the paid licence, Copilot Chat cannot search Microsoft Graph, so it only sees files you upload or open. With the licence, it sees only what the person already has permission to open.

Should we use Claude or Copilot for these tasks?

It depends on the job. We compare the two task by task in a separate guide, and many firms use both.

If your team uses Claude alongside Copilot, see our Claude training for teams.

Sources and product references

Checked 16 November 2026. Features and access can change, so check what your own licence includes.

  1. Microsoft: what is Microsoft Copilot? (licences compared)
  2. Microsoft: get started with Copilot in Teams meetings
  3. Microsoft: Facilitator in Teams meetings
  4. Microsoft: summarise an email thread with Copilot in Outlook
  5. Microsoft: welcome to Copilot in Word
  6. Microsoft: get started with Copilot in Excel
  7. Microsoft: create a new presentation with Copilot in PowerPoint
  8. Microsoft: get started with Copilot Notebooks
  9. Microsoft: get started with Copilot Pages
  10. Microsoft: get started with Researcher
  11. Microsoft: get started with Analyst
  12. Microsoft: Agent Builder overview
  13. Microsoft: save your favourite prompts to use again

Editorial guidance informed by Acuity's work with teams. Examples are fictional and client materials stay private. To record who owns an AI use and when it is reviewed, see AI Register.