Agent Mode in Office — Hand a Real Task to AI Inside Word, Excel & PowerPoint

The idea

Agent Mode is a setting inside Word, Excel and PowerPoint where the AI doesn't just answer — it does a multi-step task for you: cleans and analyses a spreadsheet, drafts a full document, or assembles a slide deck, then shows its work. It's the difference between asking "how do I make a pivot table?" and saying "analyse this sales data and build me a summary dashboard." The new skill is being a good director: giving a clear brief, then checking and correcting the output — because the agent is fast but not always right.

Who is this for?

What you'll get

Watch

MyOnlineTrainingHub · hands-on demo · ~8 min · 150K views

Do the challenge

1. 1Find Agent Mode in an Office app

   In Word, Excel or PowerPoint with Copilot, look for "Agent Mode" (vs the regular chat). It's rolling out across Microsoft 365. Pick the app where you do repetitive build-work — usually Excel or PowerPoint.

   💡 No Agent Mode at work yet? The same skill transfers: try the free ChatGPT/Claude/Gemini "do this multi-step task" flow on a copy of your file. The director mindset matters more than the specific button.

2. 2Write a brief, not a question

   Tell it the goal, the input, and what "done" looks like: "Using this sheet, clean the data, flag duplicates, and build a one-page summary with a chart of monthly totals." A clear brief is the whole skill.

3. 3Let it work, then check like a manager

   Agents are fast but make mistakes. When it returns, verify the parts that matter: spot-check 2–3 numbers, confirm it didn't drop rows, read the draft for anything off. Your judgement is the quality gate.

4. 4Save the brief that worked

   Keep your best brief as a reusable template for that recurring task. Next month you swap the data, reuse the brief, and the day-long job stays a 30-minute review.

   💡 Task for you to complete: [the whole task]. Input: [the file/data]. Steps I want: [step 1, step 2, step 3]. "Done" looks like: [the exact deliverable + format]. Then list anything you were unsure about so I can check it.

AGENT MODE BRIEF — Direct AI to Do the Whole Task

THE TASK (what you'd hand a capable intern):
"[Complete this end-to-end: e.g. clean this data + build a summary dashboard.]"

THE INPUT:
• File / data: [what it works from]
• Context it needs: [keep it short]

THE STEPS I WANT:
1. [e.g. clean + dedupe the data]
2. [e.g. flag anomalies]
3. [e.g. build a 1-page summary with charts]

"DONE" LOOKS LIKE:
• Format: [dashboard / report / deck]
• Must include: [the specific things]

THEN: "List anything you were unsure about or assumed, so I can check it."

MY CHECK (always):
□ Spot-check 2–3 numbers / facts
□ Did it drop or duplicate anything?
□ Read it once as the end reader
□ Time saved this run: ___