4.1Copilot in Word, Excel, PowerPoint
The essentials in 30 seconds
- AI comes into your tools: no more copy-pasting — Copilot writes in Word, analyses in Excel, generates in PowerPoint.
- Context becomes automatic: your open files and documents serve as sources, referenceable with “/”.
- Upstream quality pays: structured tables in Excel, well-styled Word documents for PowerPoint — and always check.
Running case — Amine prepares his steering committee
Amine, a project manager in Algiers, must prepare his site steering committee: a progress note, a work-package tracking table and a ten-slide presentation. Instead of juggling a general assistant and his files, he tests the integrated circuit: in Word, he gets a one-page note written from his site report; in Excel, he questions his structured tracking table; in PowerPoint, he generates the presentation from his Word note. He discovers the method is still the one from levels 1-2 — but the context has become automatic.
This same case runs through the lesson, the diagram, the script and the 48h challenge — and continues in 4.2, 4.3, 4.4 and 4.5.
1. AI in your tools
Copilot built into Microsoft 365 applies everything you learned in levels 1 and 2 — without copy-pasting: it writes in Word from your notes or files, analyses in Excel on your tables, generates the presentation in PowerPoint from a Word document. Amine no longer pastes his report into a separate window: he works where his documents already are.
The prompt is still king; the context becomes automatic. Your open files and documents serve as sources — to reference explicitly with “/” (for example “summary from /Report”).
2. What each integration does best
In Word: draft, summarise, rewrite — drawing on your files as sources. In Excel: draw findings from data, describe a column logic in plain English, iterate on a chart. In PowerPoint: generate a presentation from a Word document, add or reorganise slides, summarise an existing deck.
Each integration has prerequisites: Excel requires structured tables (Ctrl + L); PowerPoint prefers well-styled Word documents (Heading 1 / Heading 2); and full integration requires the Microsoft 365 Copilot licence (business), distinct from the classic Microsoft 365 subscription.
3. The method does not change, the comfort does
Prompt skills from levels 1-2 transfer fully: context, task, format — and systematic checking of the result, even when generated “inside” the tool. Integration adds comfort and the business framework, not an exemption from re-reading: Amine audits the first version of his presentation as he used to audit a pasted text.
Without the Copilot licence, the same uses can be practised with a general assistant (by pasting the content): you lose the automatic context, not the method. For in-depth mastery of each application, the Copilot 365 guide devotes whole levels to it (Word, Excel, PowerPoint).
🔎 Concrete example — 🔎 Worked example — The Word → Excel → PowerPoint circuit
Amine's circuit for his steering committee, step by step:
Word: “Write a one-page note on lot B progress from /Site-report”
Excel (structured table, Ctrl + L): “What are the 3 main findings from this data?”
then “Add a planned / actual variance column described in plain English”
PowerPoint: “Create a presentation from /Progress-note” → audit V1
→ end-to-end assisted office flow, with no copy-pastingOutcome: three applications, one context: Amine's files as sources.
Lesson: upstream quality (structured table, styled Word) conditions downstream quality.
Section vocabulary
- Copilot in Word
- Draft, summarise, rewrite directly in the document, referencing your files as sources with “/”.
Simple example: Amine asks for a one-page note from /Site-report, without leaving Word.
What it is not: a spellchecker or a static document template.
Reflex: name the source file with “/” in each document-backed request.
- Copilot in Excel
- Draw findings, describe a column logic in plain English, iterate on a chart — on data in a structured table.
Simple example: Amine questions his structured lot-tracking table: 3 findings, then a variance column.
What it is not: reliable analysis run on loose unstructured cells.
Reflex: check the structured table (Ctrl + L) before any question to Copilot.
- Copilot in PowerPoint
- Generate a presentation from a styled Word document, add or reorganise slides, summarise a deck.
Simple example: Amine generates his ten slides from his Word note headed in Heading 1 / Heading 2, then audits V1.
What it is not: automatic layout that would exempt you from re-reading the substance.
Reflex: style the source note (headings) before generating, audit after.
- Microsoft 365 Copilot licence
- The business licence that unlocks full Copilot integration in Microsoft 365 applications.
Simple example: Amine's IT department confirms who benefits from it in his team before planning uses.
What it is not: the classic Microsoft 365 subscription alone, which is not enough for full integration.
Reflex: check the available licence before promising an integrated use.
- Automatic context
- Open files and documents accessible to Copilot as sources, with no copy-pasting.
Simple example: Amine works on his open report: Copilot refers to it directly via “/Report”.
What it is not: unlimited access to the whole company, beyond the user's rights.
Reflex: cite the target source and check the right document is open.
In practice — In practice — The Word → Excel → PowerPoint circuit
- In Word: “Write a one-page note on [a real topic] from /[one of your documents]” — observe the automatic context.
- In Excel, on a structured table (Ctrl + L): “What are the 3 main findings from this data?” then “Add a [logic described in plain English] column”.
- In PowerPoint: “Create a presentation from /[your Word note]” — audit the first generated version (headings, figures, order).
- Note what changes versus the general assistant: no more copy-pasting, your files as sources — and the same checking rules.
Ready-to-say script — asking IT for the licence and the framework (30 s)
“Hello, this is Amine: I prepare my notes and presentations with our team documents. Can we check whether I have the Microsoft 365 Copilot licence, and confirm which team data I may use as sources? I want to work within the authorised scope.”
To adapt to your organisation; note the answer and keep the IT contact at hand.
Copy-paste template — standard request per application
WORD: Write a one-page note on [TOPIC] from /[DOCUMENT], tone [TONE], format [FORMAT].
EXCEL: On this structured table, give the 3 main findings, then suggest a [LOGIC IN PLAIN ENGLISH] column.
POWERPOINT: Create a [N]-slide presentation from /[WORD NOTE], one key message per slide.
CHECKING: cite the figures reused and flag any uncertain point.Without a Copilot licence
Same uses with a general assistant by pasting the content (anonymised if needed): you lose the automatic context, not the level 1-2 method.
Unstructured Excel table
Structure first (Ctrl + L, clean headers), then ask: running Copilot on loose cells gives fragile findings.
Confusing Word note
Style before generating the presentation (Heading 1 / Heading 2, one message per section): a confusing source gives confusing slides.
Team work
Only use as sources files shared within your authorisation scope; if in doubt, ask IT before widening.
✓ Best practices
- Mind the upstream: structured tables, well-styled Word documents.
- Reference your files as sources with “/”.
- Always check, even when generated “inside” the tool.
✗ Common pitfalls
- Running Copilot in Excel on unstructured data.
- Believing the classic Microsoft 365 subscription is enough.
- Skipping the check on the pretext of integration.
Key takeaways
- Built-in Copilot = your prompts + your automatic context (files, open documents).
- Excel requires structured tables; PowerPoint likes well-styled Word files: upstream quality pays.
- Level 1-2 prompt skills transfer fully.
- To go deeper per application: Copilot 365 guide (Word, Excel, PowerPoint levels).
48h challenge — apply tomorrow
Run the full circuit on a real case: 1 Word note backed by a file with “/”, 1 question to Copilot on a structured table, 1 presentation generated from the note — then audit each output.
- I can describe what Copilot does in Word, Excel and PowerPoint.
- I can cite the prerequisites (structured table, styled Word, licence).
- I ran the full circuit and audited the outputs.
Frequently asked questions
I do not have the Copilot licence: is this level useless to me?
No: the same uses can be practised with a general assistant (by pasting the content, anonymised if needed). Integration adds comfort and the business framework, not the method — which remains the level 1-2 one.
Is Copilot better than a general assistant for writing?
The engines are comparable; the difference is access to context (your files) and the business framework. With equal prompts and no context, results are close.
What is the prerequisite for Copilot in Excel?