It’s Agent Mode the new way to do human-agent collaboration?

Microsoft Copilot development just doesn’t sleep… This time they have just announced “agent mode” which they claim could be game changer in the way we (humans) work with AI agents (Copilot). Called “Agent Mode” this latest update marks is not just about new features, but a significant shift in how we interact with Office apps through Copilot.

Agent Mode in Excel

What is Agent mode?

Agent Mode is Microsoft’s answer to the growing demand for intelligent, iterative workflows without needing to craft lengthy prompts. Agent Mode brings agentic reasoning into Excel and Word, (others will follow), allowing users to work along side Copilot through multi-step tasks ranging from data analysis to document creation – with a level of depth and refinement that feels like working alongside an expert.

“In the same way vibe coding has transformed software development, the latest reasoning models in Copilot unlock agentic productivity for Office artefacts.”

Sumit Chauhan |CVP |Microsoft Product Group

These are both application and context aware. As an example:

  • In Excel, Agent Mode “speaks spreadsheet” language. Whether you need to build financial models, loan calculators, resource calculators or budgets, Agent Mode in Excel means Copilot now understands the nuances of formulas, formatting, and validation. Rather than just generating outputs, it can evaluate your work, suggest fixes, and works with you until you get the result you need.
  • In Word, Agent Mode will be able to transform writing into a dialogue. Users can prompt, Copilot drafts, user can then asks clarifying questions, and Copilot will refines the content with native styling and formatting. Microsoft say this is vibe writing in action — fast, fluid, and focused.

Chat first creation…

Then, there is the new “Office Agent”, which will live inside Copilot chat. This is designed for when discussions start in a Copilot Chat, rather from within document or spreadsheet. In this context, the Office Agent will have the ability to create “proper” documents directly from your chat, using deep reasoning and live previews to guide the process and creation. These will be powered by Anthropic models and not OpenAI.

Microsoft have given (in their official article) some examples we can use.

In Excel

Financial Analysis Prompt:Create a financial monthly close report for a bike shop business, including a breakdown of product lines across VTB, VTF, sequential, and year-over-year growth. Use standard financial formatting and best practices.”


Loan Calculator Prompt:Build a loan calculator that computes monthly payments based on user inputs for loan amount, annual interest rate, and term in years. Generate a schedule showing month, payment, principal, interest, and remaining balance. Present the results in a clear, formatted table.”

Monthly Report Update Prompt: Help me update this monthly report for September. Update the data table with the latest numbers from the /Sept Data Pull email. Summarise the key highlights including insights compared to last month’s /August monthly report.doc.”

In Word


Project Update Prompt: “Update the executive summary for clarity, bold all key findings, and insert a bulleted list of next steps based on the /Project update meeting. Make sure to add a conclusion“.


Document Style Prompt: “Can you clean up this document? Title case for section headers, branding updates per the ‘/Latest brand guidelines’ email, and italicize all external partner mentions. Feel free to ask if you need help identifying partners or guidelines.”

In Powerpoint (coming later)

Interestingly, Microsoft say that Copilot can now (finally) create good presentations in PowerPoint!

“PowerPoint is one of the most used tools for creating presentations, but over the last two years, AI (Copilot) has often fallen short when creating slides. Office Agent changes that. Office Agent creates tasteful, well-structured PowerPoint decks and well-researched Word documents. ”

Microsoft say that now… When you work with Copilot to create presentations you will get a totally transformed experience. It will

  • Clarify your intent
  • Conduct deep research
  • Produce high-quality content.

How to use “Agent Mode”

First thing first….. Not everyone can yet and it’s not available day one… OK now read on…

Currently, Agent Mode is available for organisations (and users) enrolled in the Frontier program for Microsoft 365 Copilot who have a Microsoft 365 Copilot license or that have Microsoft 365 Personal or Family with a Copilot Pro license.

Agent Mode works in Excel on the web but will be coming soon to desktop. Word is also coming soon.

For Excel, you will also need to install the Excel Labs add-in and choose “Agent Mode”.

Oddly, from what I have read, the Office Agent is only available for Copilot Pro subscribers on Microsoft 365 Personal or Family or Premium and not (yet) Microsoft 365 Commercial. It’s also limited to USA currently! 🙁

Microsoft Presenter + Review

Like similar clickers on the market, the Microsoft Presenter + can be used to control your PowerPoint and PowerPoint Live presentations.

The similarity ends here, however, as Presenter + is the first clicker that’s also Microsoft Teams certified, meaning it can also help you control and navigate your Teams meetings as well as providing control over your presentations when using PowerPoint Live from within Teams.

Microsoft say that “Presenter + reflects how work has changed since the start of the COVID-19 pandemic“.

Presenter + costs ~£69 so is not the cheapest “clicker” but is the first designed to work with Teams and brings meeting controls into your hand.

In the Box

… Is the Presenter + device and a charging Dock plus the usual manuals etc. The Presenter + can also be charged directly with a USB type C cable meaning you can leave the charger plugged into your laptop safe knowing that should you need to you can top up the charge with any USB cable.

The back of the device has a simple on/off switch a Bluetooth pairing button.

Set-up

Set up is easy.

  • Un-box the device and turn it on (there’s a switch on the back)
  • If not already installed, install the free Microsoft Assessory centre app from the Store
  • Head over to your Windows Bluetooth settings and pair the device. It also accepts pairing to multiple devices which is useful if you use a different device at home to when out and about, and even remembers any custom settings you apply to it.
Pairing the Presenter + in Windows 11
  • Open the Microsoft Accessory Centre and follow the on-screen prompts to set-up the device and customise any of the settings you wish to.
Walk through of set up and tutorial of Presenter +

Controls and Use

Microsoft Presenter + is not just a PowerPoint clicker.

In addition to the usual slide forward and back buttons, there is an also a giant Microsoft Teams button that allows you to quickly join Teams meetings and do things such as raise or lower you hand when in a meeting without reaching for your keyboard or mouse, giving a much more natural presenter experience. Microsoft also say that you can use Presenter+ with most other meeting apps, including Zoom, though I haven’t tested this yet.

Also on the device is a giant mute button, which can mute and unmute your microphone when in a call/meeting, and the remote nicely vibrates when your turn mute off, so that you know your audience can hear you talking.

You are also able to customise the left and right buttons to your individual needs using the Microsoft Accessory Centre app.

Customising the buttons on Presenter + using the Accessory Control App

Another cool feature which sets this apart from other clicker remotes is that you can use Presenter + to grab and focus the audience’s attention with the screen pointer by pressing the middle 🔆button.

Summary

The is well built, presenter remote that makes Teams Meetings and Presenting within them simple and easy. I’ve only had the joy of using this in a couple of meetings so far and the true test will be how it enables me to true be hands free.

Benefits of Presenter +
Image: Microsoft

One thing I wish it had, would be the ability to spotlight text/highlight text when presenting or zoom in / focus to a section of the presentation. It might be possible to do this via a keyboard shortcut programmed into the device, but I haven’t found a way of doing that yet.