Vibe working: Agent Mode and Office Agent

- [Instructor] If you've never heard of the term vibe coding before, it's a means of coding where a developer describes to AI what they want, views the output, and continues to refine the prompt to get the desired output. The developer is not the one writing the code, the AI is. Along the same line, Microsoft has given us vibe working. In a previous video, I introduced you to the concept of an agent, who guided prompts to help with a task. Now you can use different kinds of agents directly within Excel, Word, and PowerPoint, with support for the remaining products coming soon. In Excel and Word, you can use something called Agent mode. You do need the separate Copilot license to use these tools and while it will be official soon, right now it's so new that the only way to get it is to use Excel on the web, like I am right here, I'm accessing it through a browse, and install an add-in called Excel Labs. To do that, from the Home Ribbon tab, click Add-ins, and in the search box type "Excel labs." Click Add. And scroll through the results until you see Agent mode. From there, click Open. Now you can use Excel in Agent mode, in which you are going to describe the visuals that you'd like to see, or what you want Agent mode to analyze for you. "Create a dashboard telling me a story about this data, including visuals that will show me my top conferences as well as what is underperforming.' Now I'm not going to run this, because you've seen it in action in a similar fashion in the Analyst agent in a previous video. This one is similar, yet I'm running the query right here in the actual file in Excel. And I can also refine my prompt after to continuously get new data and change the visuals to see a data story emerge. Microsoft Word also has this Agent mode, and you can acquire it in a similar manner. It's like having a writing partner, right? You can continuously update a document by having a back-and-forth conversation with the agent to get data from other sources and include them in your document. Now, speaking of Word, here's another way that you can use agents with Word, and I'm going to go back to chat for this. Microsoft has also given us something called Office Agent to use with PowerPoint and Word. Now, this one is so new that you may not see it for a while in your organization, and it's also very slowly being rolled out to existing family and personal Microsoft 365 subscribers. Just like you saw me create a presentation in PowerPoint, this lets me also create one, but without ever actually going into PowerPoint. Now I'm still in the chat portal. On the left hand side, I'm going to click Office Agent Frontier. And again, you probably won't see this option for a short time, but you can get ahead of the learning curve by watching. Once here you'll see that you can ask Office Agent anything. That's how you'll know that you're in the different area. So just like we did when we were in PowerPoint, this time, I'm going to type the same thing right from the chat box. "Create a presentation on the benefits of community outreach for employers.' Now, again, I'm not going to send this, but you can see that you can create things in PowerPoint and Word. Currently Excel is grayed-out, but that's coming soon. And from here I can also click View use cases. This is a great way to get some inspiration on things that you can use Office Agent for. So that is a vibe working with Office Agent and the very powerful Agent mode.