• hace 1 año
Vídeo: Microsoft

Categoría

🤖
Tecnología
Transcripción
00:00Hi everyone, I'm Joe and I work on the Excel team.
00:03And I'm Catherine and I work on Excel too.
00:05And we are here today to tell you about something new we're building in Excel,
00:09the Copilot function.
00:10We're not just creating a new function, we're actually unlocking a new way of thinking.
00:15Joe, why don't you go ahead and show them how to use this new function?
00:17Absolutely.
00:19The Copilot function is just like any other function.
00:21You access it by typing equals Copilot and there you can see a signature.
00:26The most important arguments are the first two.
00:29The first one is the prompt.
00:31It's the prompt you're sending the LLM.
00:33And then the second argument is any context that you might want to send the LLM to consider.
00:37Once you've provided that and hit enter, we send it to the LLM,
00:41the LLM considers it and the results are returned to you in your grid.
00:45That's what I love about this function.
00:46It's just like so deeply and seamlessly integrated into Excel,
00:50into your workbook, part of your model.
00:52It's fantastic. Keep going.
00:54Yeah, let's take a look here.
00:55I've got a spreadsheet and the spreadsheet has some feedback
00:57about the coffee machine in the cafeteria,
00:59but it's difficult to understand what the feedback's about.
01:02So I'm going to go equals Copilot and I'm going to give it a prompt here
01:05and I'm going to say, summarize this feedback into a paragraph.
01:11And then I'm going to pass in the feedback.
01:17That goes away, calculates, and the result comes back.
01:21And you can see it's here in my grid.
01:23Now that's a little long, so maybe let me modify that
01:27and just say, give it to me as a sentence.
01:29Now I have it as a sentence.
01:31So if we take a look here, you can see the coffee machine
01:32seems to be pretty easy to use, but it seems to be a little noisy
01:36and there seems to be some maintenance issues.
01:38So is there a way that we could break this down
01:40a little bit into more detail?
01:43Yeah, let's look at this line by line.
01:44So on this sheet, I have the same feedback,
01:47but I've added some categories over to the left.
01:50I've got taste, ease of use, noise, and other.
01:53And what I'd like to do is categorize that feedback
01:56into one of the categories.
01:58Equals Copilot, categorize this feedback,
02:03and then let's give it the feedback into one of these categories.
02:11And I'm going to give it the entire range over here,
02:14including this empty cell, so we can add more categories in future.
02:17And I hit enter.
02:19And there you go.
02:20It's categorized all the feedback.
02:22It's returned the results as an array.
02:23And that array has spilled to the grid
02:25with the magic of dynamic arrays.
02:27This is fantastic.
02:29We've now got to categorize,
02:30but let's see if we can go a little bit further.
02:32So I'm going to go and expand here.
02:34Let's get the sentiment.
02:36And just for fun,
02:37let's get an emoji that represents that sentiment.
02:39And I'm going to go in here and modify this formula.
02:42So I'm going to say,
02:43return these columns.
02:48And I'm going to tell it which columns I want returned.
02:50So category, sentiment, and emoji.
02:53And the model will consider this.
02:55It'll then return the category, sentiment, and emoji
03:00with a single formula.
03:01And there we go.
03:02We now have category, sentiment, and emoji.
03:04That's amazing.
03:05With just one call to the LLM,
03:07we've processed all that data
03:08and gotten all that information out.
03:10And I just love the emojis.
03:11Yeah.
03:11This is Excel doing sentiment analysis.
03:14This was something that was never possible
03:15within the spreadsheet before.
03:17And it opens up a new world
03:18of analysis and possibilities in your spreadsheets.
03:21You know, the feedback is just so easily categorized this way.
03:24Is there anything else we can do with this?
03:26Yeah, let's try some aggregation here.
03:29I think the pivot by function would be fantastic.
03:31So let's try that.
03:33Equals pivot by.
03:35And I'm going to go and pass in,
03:38for the rows, let's go with the categories.
03:41For our columns, let's go with the emojis.
03:44And then we're just going to count the number of occurrences.
03:49So I'm just going to pass that in again
03:50and then go count A.
03:53And here you can see we have all of our different categories
03:57and whether or not it was positive or negative in the count.
04:01Right.
04:01That's really, really powerful.
04:04But you know what?
04:04There's a lot of other there.
04:06Is there a way that we can tease that out more?
04:08Yeah, that's a great idea.
04:10Let's see if we add another category here.
04:13Let's go with maintenance.
04:14So I'm going to put maintenance in this list.
04:16Now remember, when I wrote the formula earlier,
04:18I referenced this entire range.
04:19So the formula is going to now update.
04:22So I'm going to put maintenance into the list.
04:24And off it goes.
04:26Look at that.
04:28Completely integrated into the calc system of Excel.
04:30I love it.
04:31It's really the magic of spreadsheeting
04:33is the ability to just update your data
04:35and have it seamlessly update and refresh in the background.
04:38And to see that working with AI is really spectacular.
04:42It's just amazing.
04:42Like AI is now literally a part of Excel.
04:45It's so cool.
04:46The Copilot function brings natural language intelligence
04:49into your everyday Excel work.
04:51Type what you need,
04:52pass it a range,
04:53and work with the results.
04:55We can't wait to see what you will build with this.
04:57Thanks for watching.