How to use Copilot effectively

First, check which Microsoft Copilot you are using

A personal Copilot account, workplace Copilot Chat and Copilot inside Microsoft 365 apps can have different access and features. Microsoft’s documentation describes web grounding and organisational data in specific contexts; it is not a promise that every Copilot window can search everything you use at work. [1]

Check three things before blaming the prompt

• Account: are you signed in with the intended work account?
• Surface: are you in chat, Outlook, Word, Excel, Teams or PowerPoint?
• Source: is the relevant file, thread or meeting actually selected or available?

If a button is missing

Check the app version, subscription and organisation settings with the person who manages your Microsoft setup. An absent feature is not usually cured by adding “please” to the prompt.

Match the task to the app

The Copilot prompt formula: task, source, audience, output

Tell Copilot what to do and what to use. Then say who needs the answer and what form it should take. Microsoft’s prompting guidance uses goals, context, expectations and sources; the practical point is to make the job and evidence explicit. [2]

Name the actual source

Use the app’s reference or attachment controls where available. Typing a filename in brackets is not the same as attaching it. If the source cannot be accessed, stop and fix that before asking for conclusions.

Ask for the useful decision

“Summarise this” is often too loose. “Tell the project manager what is delayed, what needs a decision and what remains unconfirmed” is a brief someone can work with.

Try this Copilot prompt for a project update

Use the selected reference [attach or select the actual current file] to prepare an update for [audience].

Focus on progress, blockers, decisions needed and unresolved questions. Keep it under 250 words. Identify the file and version you used and include available references for factual claims. Separate completed work from plans and suggestions.

If you cannot access the selected source, say so before drafting. Do not substitute web results or another similarly named file.

Check it: Open the reference. Check that the version and reporting period are the ones you intended. “Latest” is not always a sufficiently precise filename.

How to use Copilot in Outlook for better email

Outlook drafting can help turn notes into a reply and revise its tone or length where the feature is available. The exact controls vary by Outlook version and account. Microsoft’s current instructions explain the supported drafting experience. [3]

Tell it what the reply needs to achieve

An email is usually there to answer something, request something or settle what happens next. Give Copilot that job. “Write a professional response” leaves it free to spend a paragraph thanking everyone for their valuable correspondence.

Check the commitments

Dates, prices, refunds, promises and recipients deserve attention. A fluent sentence saying “we will deliver on Friday” is still a problem if nobody agreed Friday.

Try this Copilot email prompt

Draft a reply to this selected email thread. The purpose is to [purpose].
Approved facts: [facts you are authorised to use].
What we can commit to: [specific commitments].
What is still unconfirmed: [gaps].

Answer the sender’s questions directly, use a warm but concise tone and keep it under 150 words. Do not invent prices, dates, refunds or explanations. Put unanswered questions in a separate note for me, outside the email draft. Do not send the message.

Check it: Read the actual thread and check the recipient list yourself. Make sure internal notes have not slipped into the reply.

How to use Copilot in Word for reports and proposals

Copilot in Word can draft from notes, outlines and supported reference material where your account has access. If you want a particular file used, select it through the available reference controls and check the result against it. [4]

Get the argument right before the paragraphs

Ask for the structure first. A report that needs a decision should lead with the decision, not three pages of background warming up to it. Once the order works, develop the sections.

Keep unknowns visible

If the source does not contain a cost, date or supporting fact, leave a labelled gap. It is much easier to resolve “cost to confirm” than to discover later that a plausible-looking number was made up.

Try this Copilot prompt for a Word document

Using the selected approved reference file, draft a one-page report for [audience] on [topic].

Start with the decision required. Then give the relevant evidence, available options, trade-offs and questions to resolve. Preserve the source’s qualifications and uncertainty. Use short headings and British English.

Do not add figures, claims or conclusions that the source does not support. Mark missing information “[TO CONFIRM]”. Keep recommendations distinct from source facts and include available source references.

Check it: Check the recommendation separately from the facts. A document can be accurate in its quotations and still make a recommendation the evidence does not justify.

How to use Copilot in Excel without trusting a tidy mistake

Start with data that has clear headings and consistent meanings. Check the current Excel requirements for your account and file. Microsoft notes that Copilot’s output needs review; a spreadsheet still requires somebody who understands what the numbers represent. [5]

Define the calculation before requesting insight

“Analyse our performance” is a large invitation to produce charts. A better first request identifies the table, the metric, the period and how missing values should be handled. Ask for the method as well as the answer.

A small example you can verify

Put this fictional data in a copy of a workbook. Net sales here means gross sales minus refunds. The expected total is £2,350: North £1,550 and South £800. Those definitions belong to this exercise; they are not a universal accounting rule.

Try this Copilot Excel prompt

Use the selected table containing Region, Gross sales and Refunds. For this exercise, Net sales means Gross sales minus Refunds.

Propose a calculated Net sales column and a summary of net sales by region. Show the formulas or calculation method, the rows included and the overall total. Treat missing numeric values as questions to resolve, not automatically as zero.

Explain any assumptions. Do not change the source data or add forecasts. If you cannot inspect the selected table, stop and tell me.

Check it: For the three fictional rows above, check £1,100, £800 and £450 before checking the regional totals. Also check whether filters or omitted rows have changed what was analysed.

How to use Copilot in Teams for meeting actions

A useful meeting summary distinguishes a decision from an idea somebody floated ten minutes before lunch. Ask for actions, owners, dates and unresolved points, with evidence where available.

Check what meeting material exists

Teams Copilot behaviour depends on meeting settings and available content. Supported after-meeting use of spoken content relies on the saved transcript; temporary speech-to-text content from a meeting without transcription is not retained for later Copilot use. Follow your organisation’s meeting and transcription arrangements. [6]

Do not promote suggestions into decisions

“We could launch in November” is not “launch approved for November”. It is a small distinction with a habit of becoming a large problem.

Try this Copilot meeting prompt

Use the available transcript and relevant chat for this selected meeting. State which sources are available before summarising.

Create separate lists for decisions, agreed actions, proposals and open questions. For each action, show owner, deadline and an available transcript reference or supporting quotation. Write “not assigned” or “not agreed” where appropriate.

Keep tentative language tentative. Do not infer agreement from silence. If the transcript is unavailable, explain what can and cannot be established from the remaining material.

Check it: Ask the people responsible to confirm unclear actions. A transcript can mishear names or miss context; the neat table is not the meeting’s final authority.

How to use Copilot in PowerPoint without creating a slide avalanche

PowerPoint can use supported source material for presentation tasks where the feature is enabled. Available file references and controls vary, so check Microsoft’s current instructions for your version. [7]

Give it a story before a slide count

Decide who is in the room, what they need to understand and what you want them to do. Then limit the story to the points that help. Turning every paragraph in a report into a slide is technically a presentation. It is also an excellent way to lose the room.

Approve the outline before building

Check the order and evidence first. Afterwards, inspect labels, charts, notes and readability. A new layout is not permission to round a number into something more convenient.

Try this Copilot presentation prompt

Using this selected approved source, propose a six-slide outline for [audience]. The decision is [decision]. The presentation lasts [time].

For each slide, give a message-led title, one main point, the evidence supporting it and a suggested visual only where useful. Preserve the source figures and qualifications. Mark gaps instead of inventing data.

Show me the outline for review before creating slides. If you cannot access the source or create slides in this app, say what you can provide instead.

Check it: Can someone understand the argument from the six titles? If not, fix that before choosing colours.

Why Copilot gives a poor answer, and how to fix it

Check access before adding more adjectives. Then check the source, its version and the scope of the request. If all three are right, make the task smaller and ask for a result you can verify.

Diagnose the failure instead of starting again blindly

Did Copilot use the wrong file? Miss a date range? Produce a general answer when you wanted evidence from a document? Say exactly which failure occurred and what a correct result would look like.

Try this Copilot troubleshooting prompt

The previous answer did not meet the brief.
The task was: [task].
The intended source was: [actual selected file, thread or meeting].
The problem was: [specific error].

First state which sources you actually used and which are unavailable. Explain whether the problem appears to be source access, conflicting information or the instructions. Do not invent an explanation if you cannot tell.

Then suggest the smallest change needed to produce a checkable answer. Wait for me to confirm before redrafting.

Check it: If access is missing, fix the account or source selection. Rewriting the same prompt five times will not open a file the tool cannot reach.

Build a useful Copilot routine

Choose one task you do repeatedly: a project update, an email reply or a meeting action list. Save the prompt alongside the source requirements and checking steps. Improve it after actual use, not after watching another launch video.

Keep the person in charge of the finished work

Review recipients, figures, dates and commitments before anything leaves the draft stage. Use the account and information approved for the task. Copilot respecting access permissions does not remove your responsibility to decide what should be shared.

For guided practice, explore The Oxford AI School’s programmes or start with basic AI training. The useful question is not how many Copilot features you have opened. It is which piece of work you can now complete properly.

Keep learning: more ways to use your AI effectively

• How to Use ChatGPT Effectively: The 5-Part Prompt Rule
• How to Use Claude Effectively: 7 Prompts for Better Work
• How to Use AI Effectively at Work: A Practical Method
• Microsoft Copilot Training UK
• How To Learn Advanced Copilot
• ChatGPT vs Copilot for Business: The Difference