# Microsofts Wave 2 AI Just Changed Work Forever - (Copilot Agents)

## Метаданные

- **Канал:** TheAIGRID
- **YouTube:** https://www.youtube.com/watch?v=9-vio5HjHms
- **Дата:** 20.09.2024
- **Длительность:** 18:10
- **Просмотры:** 82,446

## Описание

Prepare for AGI with me - https://www.skool.com/postagiprepardness 
🐤 Follow Me on Twitter https://twitter.com/TheAiGrid
🌐 Checkout My website - https://theaigrid.com/


Links From Todays Video:
https://www.youtube.com/watch?v=Gz0jPfCuvsM&pp=ygUQbWNpcm9zb2Z0IHdhdmUgMg%3D%3D

Welcome to my channel where i bring you the latest breakthroughs in AI. From deep learning to robotics, i cover it all. My videos offer valuable insights and perspectives that will expand your knowledge and understanding of this rapidly evolving field. Be sure to subscribe and stay updated on my latest videos.

Was there anything i missed?

(For Business Enquiries)  contact@theaigrid.com

#LLM #Largelanguagemodel #chatgpt
#AI
#ArtificialIntelligence
#MachineLearning
#DeepLearning
#NeuralNetworks
#Robotics
#DataScience

## Содержание

### [0:00](https://www.youtube.com/watch?v=9-vio5HjHms) Intro

so Microsoft recently announced co-pilot Wave 2 and I think this is by far one of the most underrated things in AI right now because this is literally going to change how most individuals actually use AI on a day-to-day basis even if you don't have use for this at work I think it's certainly going to help you in your day-to-day projects so this is something worth paying attention to all right so let's take a look at the first major upgrade Excel just became insane with its new python integration you don't even have to know how to code which is wild picture this you've got a ton of data like years of sales numbers and you're thinking this is probably going to take forever now here's where it actually gets crazy co-pilot steps in runs Advanced analysis for you and gives you insights charts forecasts whatever you need without touching a single formula it's literally like adding a pro data analyst to your team so let's take a look at how it all works say you want

### [0:48](https://www.youtube.com/watch?v=9-vio5HjHms&t=48s) Understanding Revenue Trends

to understand Revenue Trends First Step importing all your data you bring together data on product sales pricing and customer feedback drawing from Salesforce sap and Dynamics now you have a workbook with all the raw data you need in one place and you can use co-pilot to shape and analyze the numbers let's start by figuring out which category of your business is driving the most Revenue you know how to calculate that but this sheet has three years of sales data so while it's a routine task this much data can be unwieldy you ask co-pilot to quickly calculate monthly Revenue by product it knows exactly how to do that and which data to reference across tabs co-pilot creates a plan for how to run those numbers executes that plan showing its work as it goes and prompts you to ask questions or iterate on the solution it reached it looks great so you're ready to add that column to your spreadsheet now a new request has come in and you need to understand how each product category is performing and ensure you're selling at least $100,000 a product in each category per month let's start by comparing sales by category you ask co-pilot to create a simple bar chart so you can quickly see which product categories are selling best and with conditional formatting it highlights the product lines that aren't meeting the 100K minimum threshold so you know where to focus now that we know which products aren't selling as well let's dig a little deeper and see what we can learn from customer feedback co-pilot in Excel can now reach over text like this raw customer data co-pilot analyzes all the customer feedback from the past quarter and surfaces the top three concerns it looks like charging speed might be an emerging issue so let's ask co-pilot to highlight customer reviews that mention charging speed now with the help of co-pilot you've taken a complex disperate data set and quickly analyzed it giving you a full picture of your Revenue trends that you can bring to the up coming Business Review if you're a

### [3:01](https://www.youtube.com/watch?v=9-vio5HjHms&t=181s) Python in Excel

financial analyst you live in Excel you're analyzing and Mining the data for insights that make a huge difference to your business and we know that python one of the most popular programming languages on the planet is fast becoming an indispensable tool for advanced analysis modeling and data visualization today we are excited to announce co-pilot in Excel with python democratizing its powerful capabilities all without needing to know how to code it's like adding a highly skilled data analyst to your team take a look you're working on your company's annual revenue forecast planning for the next fiscal year this can be a time intensive task but now co-pilot can write and interpret python code making your job a whole lot easier in just a couple of clicks co-pilot does an advanced analysis reasoning over 3 years of historical sales data just like an analyst would co-pilot opens up a new workspace where you can experiment to get the insights you're looking for all without altering your original data it shows a preview of what it's reasoning over creates a plan to analyze it in a way that is immediately useful and executes it by running and writing python code giving you a quick picture of your numbers now you're ready to iterate on co-pilot's work so let's ask it to forecast your annual revenue for the next two years co-pilot repeats the pattern creating a plan for how to tackle the task writing and running python code and prompting you to iterate and ask questions about its work if you want to make any edits to the python code itself you can do so directly in the workbook this is the power of bringing python directly into the Excel grid let's take it a step further you want to understand which customers are prioritize to close gaps and meet your Revenue goal so you go back to your original customer data and ask co-pilot to use Python to rank customers based on upsell opportunity as co-pilot gets to work it jumps back to your analysis workspace it prioritizes the most helpful metrics and provides a preview of the data it will use it ranks them and within moments you have a prioritized table you want to see a visualization of the customer ranking and understand the waiting methodology co-pilot used co-pilot quickly creates a chart and gives you a detailed breakdown of how it arrived at the answer within minutes you've worked with co-pilot to create a detailed summary of your data all without writing Okay so

### [5:48](https://www.youtube.com/watch?v=9-vio5HjHms&t=348s) Narrative Builder in PowerPoint

we've all been there blank PowerPoint slide no idea where to start right this is where it gets crazy PowerPoints narrative Builder with co-pilot is your new best friend you give it some basic info and Bam it drafts a whole pitch deck for you titles speaker notes even on brand visuals all ready to go it's like PowerPoint but on steroids I mean this is actually useful and I don't know about you but I'll be using this for sure when I need to crank out presentations fast so let's take a look at how PowerPoint became upgraded say you're a sales lead getting ready to pitch a new retail customer you ask co-pilot to create a compelling pitch deck in your company template that shows how your product will attract Shoppers and keep them in the store longer now with co-piloting PowerPoints new narrative Builder you are in Creative control it starts with the draft outline where you can reorder the flow delete topics you don't want or add new ones and ensure you've got a solid outline before creating a presentation let's add a section on our key value props tailored to customer insights and another section with customer testimonials within seconds you have a Content outline and you're ready to start on your presentation co-pilot makes a plan for creating the slides and executes it crafting the titles and draft copy pulling in images from your corporate library and applying your company's PowerPoint template so the presentation is on brand now you're ready to iterate with co-pilot as your partner it looks like this slide could use an image you tell co-pilot what you're looking for and within seconds it provides several options from your company's approved image Library Co pilot can also provide AI generated images using designer and Dolly 3 now that you've selected a photo PowerPoint gives you several slide design options aligned to your company brand guidelines to choose from you can keep iterating but let's see what co-pilot has helped you build so far it added speaker notes to every slide built slide Transitions and added animations giving you a professionall looking presentation that's on brand with so

### [7:57](https://www.youtube.com/watch?v=9-vio5HjHms&t=477s) Prioritize My Inbox

here's where we have something that changes the game I don't know about you guys but I honestly have so many pointless emails piling up in my inbox now here's where it gets insane outlooks prioritize my inbox feature uses co-pilot to sort your emails based on what actually matters it knows which emails are important based on your job your team everything and it learns so next time it'll prioritize what you care about this is actually useful because we all know how much time we waste on emails I'll definitely be using this to Stop drowning in my inbox prioritize my inbox let's take a look co-pilot and out look can now help you prioritize what's in your inbox it analyzes all your emails using both the content of your messages and the context of your job like who your manager is and who's on your team to highlight what's most important you can then sort by priority based on co-pilot's analysis let's look at this email from a new customer tail and Traders when you select it co-pilot shows you why it thinks it's significant and highlights what action you need to take this is a key customer for the next few months so you teach co-pilot that all emails mentioning them are top priority now co-pilot knows to prioritize any email from tail and Traders copilot is your partner helping you manage your inbox so you don't miss what's most important now let's switch to Outlook mobile you have to run to a meeting but you don't want to leave the customer hanging so you need to draft a response on the go we're making it even easier to be productive on your phone with co-pilot and Outlook co-pilot analyzes the email and offer some suggested responses now all you have to do is pick one as your starting point and instruct co-pilot on what else to add co-pilot generates a solid draft and it's ready for editing because this is going to a customer you want to make it more formal so you ask co-pilot to adjust the tone you can easily flip through the options and select which version you like the best the second paragraph could also use an update you can edit it yourself or ask co-pilot to help let's highlight the relevant section and tell co-pilot what you want to include once you're happy with the edits you can accept the changes and your email is ready to send now here's a surprising feature co-pilot

### [10:09](https://www.youtube.com/watch?v=9-vio5HjHms&t=609s) Copilot in Teams

in team so let's imagine this you finish a meeting and instead of frantically trying to remember what was said co-pilot has already transcribed it all and pulled out the key points for you and now here's where it gets crazy it even scans the chat for important questions or ideas you missed so no more wait what did I miss moments this is actually useful and for anyone who lives in back-to-back meetings this is going to save so much time co-pilot and teams can now reason over both the meeting transcript and the meeting chat to give you a complete picture of what was discussed let me show you how you meet as a team to discuss the customer's RFP as the meeting wraps you think you might have missed some important questions in the chat now co-pilot and teams captures this valuable high bandwidth conversation let's ask co-pilot about any questions you may have missed it quickly scans what was said and what was in the chat looks for questions and checks if any were left unanswered now you have a list of the open questions so you can follow up and close the loop with the team now I'm literally so glad

### [11:08](https://www.youtube.com/watch?v=9-vio5HjHms&t=668s) Copilot in One Drive

they've added this one drive used to be a mess before but now here's where it gets insane co-pilot in one drive actually Compares files for you let's say you have two documents with similar names co-pilot will tell you exactly what's different between them without you opening a single file this is a surprising feature and honestly super useful for those of us who constantly dig through files I'll definitely be using this when I can't figure out which version is the latest one drive is a rich repository of content and with co-pilot in one drive finding exactly what you need has never been easier co-pilot helps you work faster and smarter summarizing your content and answering your questions without ever opening a file let's say you need to find the latest product specs for a customer you go to one drive but you can't tell which of these files is the right one as they both have file names in indicating they could be the latest let's ask co-pilot to compare them within seconds you have a clear easyto read summary highlighting the important differences between the document and PDF now you know the one dated August 13th is what you need so you can be confident you're giving the customer what they requested all right guys we have the big

### [12:17](https://www.youtube.com/watch?v=9-vio5HjHms&t=737s) Copilot Agents

boys agents and more specifically co-pilot agents and this is where it gets crazy imagine having an AI assistant that doesn't just answer questions but can actually do your work for you we're talking about automating tasks pulling data and even making decisions say you need to troubleshoot something on the spot or place an order for a part co-pilot agents have got you covered and the best part anyone can create one you don't need to be a developer you just tell it what you want connect it to your systems like SharePoint or Dynamics and boom it's up and running this is insanely useful if you want to cut down on repetitive tasks and free up time to focus on the important stuff I'll definitely be using this to streamline my work introducing co-pilot agents broadly speaking agents automate and execute business processes working with or for humans they come in all shapes and sizes they can reason remember be trained and even no one ask for help agents range from simple prompt and response to more advanced agents that automate repetitive tasks to sophisticated agents that are fully autonomous and can orchestrate other agents co-pilot agents do that and more they bring the power of agents to you right in the flow of your work they work for you in the background are fully managed and orchestrated by co-pilot and are incredibly easy to create co-pilot agents build capacity enabling you to scale your team like never before take a look we'll start in b chat where we can open a simple agent for a field service technician say you're onsite and you get an error code you've never seen before you built a field service agent for exactly this it has access to all your product knowledge and can give you step-by-step instructions in real time now watch how simple it is for anyone to create the agent we just saw and add it to co-pilot you fire up agent Builder and describe what you want the agent to do it needs to be able to reason over your product catalog and repair tickets to provide step-by-step troubleshooting instructions let's connect it to SharePoint so it has access to all the knowledge it needs it's built in seconds so you can start using it immediately or edit and configure it to fit your needs you can expand its knowledge Base by tapping into resources like SharePoint sites or other it approved data sources you can even update its name or image to align with your company's branding so let's do that you can test the agent right here or just hit create and you're done and of course the agent respects your organizations's Microsoft 360 65 and SharePoint security permissions okay here's a surprising feature for all the SharePoint users out there co-pilot has just turned SharePoint into a gold mine of insights you know how SharePoint is full of data documents and records that are super hard to sift through now here's where it gets insane co-pilot can reason over all that info answer questions and even take action just like a real teammate would you can build a co-pilot agent directly in SharePoint to do things like automate workflows make recommendations or pull in data from other sources and get this you can share it with your team in one click it's a total game Cher for anyone dealing with loads of information in SharePoint and I'll be using this for sure to get more out of my content let's say there's an issue that requires further research and followup your team keeps all its customer records from deployment to maintenance reports on a SharePoint site it's a wealth of valuable insights that's largely been locked away kind of hard to extract until now you can create an agent with a single click from any SharePoint site library or folder an agent that deeply knows the information it was built on it can answer questions about Source material reason over that material and take action just like a well-informed teammate would in just a few seconds your co-pilot agent is ready to be used or shared with others let's add it to your team chat so everyone can work with the agent now all those artifacts in SharePoint are immediately accessible and useful so cop pilot can reason over all the relevant content to find what your team needs you can at mention the agent as you would any other teammate sharing new information and asking it questions and it will respond in real time let's take it a step further now we'll edit the agent we just built so we can take action on behalf of the team first open your agent in co-pilot Studio here you can customize the knowledge an agent has as well as the actions it can take you want it to be able to place in order for new parts with your procurement team let's connect it to Dynamics 365 Supply Chain management and in just a few seconds you're ready to update the agent and bring it back to the team chat where you're working on solving the customer's issue let's ask the agent to order the part it recommended your agent is on it asking you to confirm before moving forward once you give it the go-ahead it's done wow there you have it so what do you guys think about these recent announcements are you going to be using this stuff I'm definitely going to be doing a few tutorials on my channel for these pieces of software because I think that this is something where once again those who are early are going to benefit massively from a streamlined workflow so I'm going to be testing many of these things many different agents to see what is the most effective if you already know how to use these tools and are remarkably effective why don't you leave a comment down below and let everyone know how best to take advantage of these tools with that being said hopefully guys enjoyed the video and have a wonderful day

---
*Источник: https://ekstraktznaniy.ru/video/14063*