Copilot for Dummies: A Plain-English Guide to Microsoft Copilot

The short version

Copilot is Microsoft's AI, and it arrived the way most Microsoft things do: already installed, whether you asked for it or not. It is the assistant now sitting inside Windows, Word, Excel, Outlook and Teams, wearing a Microsoft suit over OpenAI's brain.

For anyone whose work life is Microsoft 365, that is the whole point. Copilot is at its best not as a chatbot you visit, but as a helper baked into the exact apps where your work already lives. Especially, and I cannot stress this enough, in Excel.

Copilot at a glance

Made by: Microsoft, using OpenAI's models
Best for: businesses and teams already living in Microsoft 365 and Excel
Personality: the colleague IT added to every meeting without asking you
Free version: yes for the basic web version; the powerful in-app version needs a paid licence
The one catch: "Copilot" means about six different products, and only some of them are the good one

There is a decent chance Copilot has already appeared in your taskbar, your Word ribbon or your Teams calls without any decision on your part, because Microsoft has put it more or less everywhere. That ubiquity is either brilliant or mildly unnerving, depending on your mood and how much you enjoy being surprised by your own software.

Underneath the confusion sits a genuinely useful tool, particularly if you have ever cried softly into a pivot table. Here is what Copilot actually is, once you strip away the branding.

What is Copilot, in one sentence?

Copilot is Microsoft's AI assistant, built on the same sort of models as ChatGPT but wired directly into Windows and the Microsoft 365 apps, so it can draft in Word, analyse in Excel, triage your Outlook inbox and summarise the Teams meeting you only half-listened to.

What it is genuinely good at

Its home advantage is your work. Because Copilot can see your documents, emails and calendar, with permission, it can do things a standalone chatbot simply cannot: build a formula from a plain-English description in Excel, draft a reply that actually knows what the email thread said, or hand you a tidy summary and action list from a meeting you attended with your camera off. In Excel especially, it turns "I know this is possible but I have completely forgotten how" into a sentence you can just type.

Where it falls over

The naming is a genuine mess. Copilot on the free website, Copilot in Windows, Microsoft 365 Copilot, GitHub Copilot for programmers, and several more, all share a name and do quite different jobs. The powerful version that works across your Office files needs the right paid licence, and without it you have a perfectly ordinary chatbot wondering why everyone is so excited. Sort out which one you actually have before you judge it.

How to get the best from it

Use it inside the app, not the website

The free web chatbot is fine for a quick question, but the real value is Copilot working inside Excel, Outlook and Teams, on your own files and messages. That is where it does things nothing else on your machine can.

Lean on the meeting recaps

Let Teams summarise the call and pull out who agreed to do what. It is the least glamorous feature and quite possibly the most useful, particularly for anyone who attends more meetings than they can honestly remember.

A good first job

After your next Teams meeting, ask Copilot for a summary and the list of who committed to what. It is the single fastest way to look organised while doing almost nothing.

Copilot vs the rest: where it fits

ChatGPT is the famous generalist, Gemini the Google one, Claude the careful writer. Copilot's argument is corporate and practical: if your company already pays for Microsoft 365, the AI that lives inside Word, Excel and Outlook meets your work where it already sits, and comes with the admin controls your IT team will insist on. It is less about being the cleverest and more about being in the building.

So should you actually use it?

If you or your business run on Microsoft 365, yes, it is close to a no-brainer, provided you get the licence that unlocks the in-app version. If you are a solo user who lives in a browser and a personal email account, you will get more joy elsewhere. Check what your organisation already pays for before you buy anything, because you may well be sitting on it.

Frequently asked questions

The questions people actually type, answered plainly.

What is Microsoft Copilot?

Microsoft Copilot is Microsoft's AI assistant, built on OpenAI's models and wired into Windows and the Microsoft 365 apps. It can draft in Word, analyse in Excel, help with Outlook email and summarise Teams meetings, working on your own files with permission.

Is Copilot free?

There is a free web and Windows version for general questions. The powerful version that works inside Word, Excel, Outlook and Teams on your own data needs a paid Microsoft 365 Copilot licence. Pricing and plans change, so check Microsoft's site.

Do I need a special licence for Copilot?

For the in-app features across Office, yes, you need the Microsoft 365 Copilot licence on top of a qualifying Microsoft 365 plan. Without it, you have the general chatbot but not the parts that work across your documents and email.

Does Copilot work in Excel, Word and Outlook?

Yes, with the Microsoft 365 Copilot licence. That is where it is strongest: writing and rewriting in Word, building formulas and analysing data in Excel, drafting and triaging in Outlook, and recapping meetings in Teams.

Is GitHub Copilot the same thing?

No, and this trips a lot of people up. GitHub Copilot is a separate product aimed at software developers, helping them write code. Microsoft Copilot for Office is the one for everyday business work. Same word, different tools.

Copilot vs ChatGPT - aren't they both OpenAI?

They use similar underlying models, but they are not the same product. ChatGPT is OpenAI's own general assistant. Copilot is Microsoft's version, wrapped around your Office files and email with Microsoft's business controls. If you live in Office, Copilot's integration is the difference.

Is my company data safe with Copilot?

Microsoft 365 Copilot is designed to work within your organisation's existing data boundaries and permissions rather than sending your files off to train public models. The specifics depend on your setup, so confirm the details with your IT or Microsoft admin.

Is Copilot good for business?

For Microsoft 365 organisations, yes, particularly for Excel-heavy roles, email-heavy roles and anyone drowning in meetings. The value lands fastest when people are shown how to use it inside their apps rather than left to discover it alone.

Practical next steps

Put Microsoft Copilot to work with your team

We deliver practical AI training in Oxfordshire, London and across the UK, plus live online sessions for teams in the USA and other international markets. Sessions can be tailored for SME owners, directors, lawyers, doctors, nurses, teachers, estate agents, accountants and marketing teams.

Basic AI Training

Help Microsoft 365 users understand prompting, checking and safe use.

Explore this training

AI Basics Deep Dive

Turn Copilot into a practical part of everyday team workflows.

Explore this training

AI Policy Workshop

Create sensible rules for company data, permissions and review.

Explore this training

AI for Accountants

Apply AI carefully to reporting, analysis and client communication.

Explore this training

Compare the other AI For Dummies guides: ChatGPT · Claude · Google Gemini · Perplexity.

The Oxford AI School

On Microsoft 365? Let us unlock what you are paying for.

Plenty of businesses buy Copilot licences and then use a fraction of them. We show teams how to get real work done with Copilot inside Excel, Outlook and Teams, in plain English, no jargon required.

Book a free introductory call Training for businesses

Copilot is not trying to be the AI you fall in love with. It is trying to be the one already sitting in your Excel ribbon when you need a formula and your mind has gone blank. For the millions of people whose working lives run on Microsoft, that unglamorous, always-there usefulness is worth more than any amount of cleverness in a tool they would have to go and find.