WEBVTT 00:00:00.000 --> 00:00:03.000 The FIFA World Cup is coming up and I don't have 00:00:03.000 --> 00:00:06.120 any tickets. But instead of guessing, I'm going 00:00:06.120 --> 00:00:08.919 to use Microsoft Copilot in Excel to figure out 00:00:08.919 --> 00:00:12.000 exactly which games are worth going after. I'm 00:00:12.000 --> 00:00:13.720 going to show you the features that I use so 00:00:13.720 --> 00:00:16.179 that you can apply the same techniques in your 00:00:16.179 --> 00:00:19.100 spreadsheets. My name is Shervin Shafi and I'm 00:00:19.100 --> 00:00:21.859 a Copilot Principal Engineer at Microsoft. Now 00:00:21.859 --> 00:00:24.440 let's get started. All right so we're in Excel 00:00:24.440 --> 00:00:27.420 and we're using the web browser and if you notice 00:00:27.420 --> 00:00:30.359 here on the right hand side you'll see this Copilot 00:00:30.359 --> 00:00:33.219 icon and that shows up when you're in this home 00:00:33.219 --> 00:00:36.460 menu and you can also right click and you can 00:00:36.460 --> 00:00:38.560 see Copilot suggestions. So there's a couple 00:00:38.560 --> 00:00:40.619 of different ways of accessing Copilot and when 00:00:40.619 --> 00:00:43.399 you select chat with Copilot it does the same 00:00:43.399 --> 00:00:46.759 thing as if you actually click this icon. it 00:00:46.759 --> 00:00:49.600 opens up Copilot on the right hand side. So this 00:00:49.600 --> 00:00:52.359 is the simplest way of accessing Copilot in Excel. 00:00:52.619 --> 00:00:55.039 We got the blank spreadsheet in a web browser 00:00:55.039 --> 00:00:58.100 and we're using the Microsoft 365 Copilot license 00:00:58.100 --> 00:01:00.520 for businesses and commercial. If we kind of 00:01:00.520 --> 00:01:03.640 quickly look at this, your navigation panel opens 00:01:03.640 --> 00:01:05.939 up the fact that you can have a new chat, any 00:01:05.939 --> 00:01:09.299 agents that you have access to. and also if you 00:01:09.299 --> 00:01:11.340 scroll down to the bottom here you'll see all 00:01:11.340 --> 00:01:13.280 the chats that you've had your different chat 00:01:13.280 --> 00:01:15.480 histories shows up you can also click on all 00:01:15.480 --> 00:01:18.120 chats to go to additional chat history so this 00:01:18.120 --> 00:01:20.540 is the navigation panel this is the enterprise 00:01:20.540 --> 00:01:22.780 data protection you can click on this link it'll 00:01:22.780 --> 00:01:25.280 talk about microsoft privacy and security settings 00:01:25.280 --> 00:01:28.280 and then this is your work and the web tab that 00:01:28.280 --> 00:01:31.060 you can toggle between giving you access to your 00:01:31.060 --> 00:01:33.299 work data or not and then this is a new chat 00:01:33.299 --> 00:01:35.439 so if you have a chat you can click new chat 00:01:35.959 --> 00:01:38.019 to start a new chat, and then these three dots 00:01:38.019 --> 00:01:42.560 give you more options, like this is new. You 00:01:42.560 --> 00:01:45.939 can select the model of OpenAI, either setting 00:01:45.939 --> 00:01:48.939 it to auto, quick response, or think deeper, 00:01:49.140 --> 00:01:52.299 or you can select more and go to 5 .2 options 00:01:52.299 --> 00:01:55.459 of GPT, quick response or think deeper. So these 00:01:55.459 --> 00:01:58.459 are things that you can customize. Then you can 00:01:58.459 --> 00:02:00.980 go into schedule prompts, sending feedback, additional 00:02:00.980 --> 00:02:03.260 settings, or a new temporary chat. So there's 00:02:03.260 --> 00:02:06.469 a lot to kind of discover here. and take your 00:02:06.469 --> 00:02:08.710 time to kind of understand what these do. For 00:02:08.710 --> 00:02:12.050 me personally, I always just set it to auto and 00:02:12.050 --> 00:02:14.569 call it a day and go from there. But what's new 00:02:14.569 --> 00:02:18.289 that I wanted to bring your attention to is over 00:02:18.289 --> 00:02:21.289 here with these two squiggly lines, this is the 00:02:21.289 --> 00:02:24.409 tools menu. And now we have something called 00:02:24.409 --> 00:02:26.969 agent mode that we release as Frontier, but it's 00:02:26.969 --> 00:02:29.370 actually rolling out now as generally available. 00:02:29.490 --> 00:02:32.460 So you don't have to be a Frontier user. you 00:02:32.460 --> 00:02:34.939 might actually see this with not the parentheses 00:02:34.939 --> 00:02:38.000 frontier it just shows agent mode and when you 00:02:38.000 --> 00:02:41.780 select it it takes you to this other way that 00:02:41.780 --> 00:02:43.919 copilot looks and it says that you're in agent 00:02:43.919 --> 00:02:46.819 mode and you know that you're in agent mode because 00:02:46.819 --> 00:02:49.900 it's giving you this icon over here and at the 00:02:49.900 --> 00:02:51.960 moment i just want to give you a heads up that 00:02:51.960 --> 00:02:55.259 when you're in agent mode it does not have access 00:02:55.259 --> 00:02:58.620 to your work data only the internet This is going 00:02:58.620 --> 00:03:00.979 to change in the future, but at the moment it's 00:03:00.979 --> 00:03:03.520 only able to access the internet data. So you're 00:03:03.520 --> 00:03:06.539 in agent mode and up along the top, again, you 00:03:06.539 --> 00:03:09.939 can change the model, but this is also new. The 00:03:09.939 --> 00:03:13.780 fact that you can go between auto GPT -5 .2, 00:03:13.840 --> 00:03:18.639 which is open AI or Anthropix cloud. I don't 00:03:18.639 --> 00:03:20.620 know if it's cloud or cloud. Let's just call 00:03:20.620 --> 00:03:24.050 it cloud. Opus 4 .5. All right. So you have these 00:03:24.050 --> 00:03:27.050 choices and we can experiment with what Anthropix 00:03:27.050 --> 00:03:30.270 model does and what OpenAI's model does. But 00:03:30.270 --> 00:03:33.229 before we even use agent mode, you might be wondering 00:03:33.229 --> 00:03:35.810 what even is agent mode. So I'm going to go ahead 00:03:35.810 --> 00:03:39.129 and X this out and let's figure out what is agent 00:03:39.129 --> 00:03:41.650 mode. Now, I created a prompt that I'm going 00:03:41.650 --> 00:03:44.330 to go ahead and paste in here. And this prompt 00:03:44.330 --> 00:03:48.879 is for our FIFA World Cup. discovery around what 00:03:48.879 --> 00:03:51.280 actually is something worthwhile looking into 00:03:51.280 --> 00:03:54.719 for tickets so my prompt says look create a spreadsheet 00:03:54.719 --> 00:03:58.199 on the upcoming fifa world cup include all the 00:03:58.199 --> 00:04:00.659 games and the matches with info such as who is 00:04:00.659 --> 00:04:03.539 playing who the famous players are on the teams 00:04:03.539 --> 00:04:06.439 world rank of the team the date the time the 00:04:06.439 --> 00:04:09.120 location of these games tourist info about the 00:04:09.120 --> 00:04:12.439 top 10 things to do in each city and any other 00:04:12.439 --> 00:04:15.159 info that you think is important i want to figure 00:04:15.159 --> 00:04:18.540 out where I should go and what tickets I should 00:04:18.540 --> 00:04:21.300 get. So I also want to know about the city. I'm 00:04:21.300 --> 00:04:23.079 using this spreadsheet to decide which games 00:04:23.079 --> 00:04:25.860 to attend. So when I give it a prompt like this 00:04:25.860 --> 00:04:28.620 and I go ahead and send this off, then in typical 00:04:28.620 --> 00:04:32.680 fashion, Copilot's going to do its research and 00:04:32.680 --> 00:04:35.600 analyze my prompt and go out to the internet. 00:04:35.959 --> 00:04:39.220 In this case, because I'm using this briefcase 00:04:39.220 --> 00:04:41.899 icon, if there's work data that I have on FIFA, 00:04:42.000 --> 00:04:45.050 which I don't, but if I did, It would also access 00:04:45.050 --> 00:04:47.910 that information. And this is the typical mode. 00:04:47.970 --> 00:04:50.110 This is not agent mode. So let's go ahead and 00:04:50.110 --> 00:04:53.029 see what it comes back with. All right. So it 00:04:53.029 --> 00:04:55.389 just finished. And again, remember, this is not 00:04:55.389 --> 00:04:58.029 using agent mode. And it took a little bit of 00:04:58.029 --> 00:05:01.790 time. You can see 329 seconds is how long it 00:05:01.790 --> 00:05:03.990 took. And it did a bunch of stuff that you can 00:05:03.990 --> 00:05:05.970 expand and look at all the reasoning and the 00:05:05.970 --> 00:05:09.569 logic. But in the end, it came back and it said, 00:05:09.670 --> 00:05:14.480 look. I created a World Cup 2026 attendance planning 00:05:14.480 --> 00:05:18.060 spreadsheet. And it says that you can download 00:05:18.060 --> 00:05:22.319 it here. And it tells me what's inside and how 00:05:22.319 --> 00:05:24.759 it helps. And it has all this information in 00:05:24.759 --> 00:05:27.860 here. Now, this is cool. This is great. And I'm 00:05:27.860 --> 00:05:30.079 sure there's a ton of fantastic information. 00:05:30.680 --> 00:05:33.420 But really, I'm a little bit disappointed because 00:05:33.420 --> 00:05:35.500 if you look on the right -hand side, this whole 00:05:35.500 --> 00:05:39.689 area is empty. And that is the trick with agent 00:05:39.689 --> 00:05:43.110 mode. The thing about agent mode is that it actually 00:05:43.110 --> 00:05:45.870 does the work for you on the left -hand side. 00:05:46.029 --> 00:05:48.670 So while you might be able to go ahead and download 00:05:48.670 --> 00:05:51.509 this spreadsheet that it's telling you over here, 00:05:51.649 --> 00:05:54.050 and we can go ahead and click it and see what 00:05:54.050 --> 00:05:56.810 it is. And this is what that document is, the 00:05:56.810 --> 00:05:59.569 attachment. So it actually looked great. It has 00:05:59.569 --> 00:06:02.189 information on matches, on teams, on cities, 00:06:02.310 --> 00:06:06.199 on the sources, and even a short list. I actually 00:06:06.199 --> 00:06:09.639 wanted it to do that all in that document in 00:06:09.639 --> 00:06:11.240 the spreadsheet that I had instead of leaving 00:06:11.240 --> 00:06:15.019 it blank. So again this is super cool but it's 00:06:15.019 --> 00:06:17.879 not exactly what I was looking for. Now let's 00:06:17.879 --> 00:06:20.819 give it the exact same prompt except this time 00:06:20.819 --> 00:06:22.879 we're going to go ahead and use agent mode. So 00:06:22.879 --> 00:06:25.379 to do that first I'm going to start a new chat. 00:06:25.639 --> 00:06:27.680 So I'm going to select this icon and then I'm 00:06:27.680 --> 00:06:29.639 going to go to the tools area and I'm going to 00:06:29.639 --> 00:06:32.649 select agent mode. And then I'm going to go ahead 00:06:32.649 --> 00:06:35.269 and paste in that same prompt that we used again 00:06:35.269 --> 00:06:38.069 and execute. And let's see what happens with 00:06:38.069 --> 00:06:46.350 this now. Now this is much better. I don't know 00:06:46.350 --> 00:06:49.509 if you saw, but it created everything in the 00:06:49.509 --> 00:06:52.149 spreadsheet with agent mode on the left -hand 00:06:52.149 --> 00:06:55.889 side. There is a ton of information in here. 00:06:57.160 --> 00:06:59.360 answers all the questions that i asked it so 00:06:59.360 --> 00:07:02.019 let's look at this together a little bit now 00:07:02.019 --> 00:07:05.600 remember we're using agent mode and at the moment 00:07:05.600 --> 00:07:08.319 i have it just set to auto so i'm not quite sure 00:07:08.319 --> 00:07:13.199 if it used open ai chat gpt 5 .2 or or the cloud 00:07:13.199 --> 00:07:16.620 4 .5 and you can see that there's reasoning on 00:07:16.620 --> 00:07:19.439 the right hand side that it explains how it did 00:07:19.439 --> 00:07:22.870 it But I'm very impressed with the spreadsheet. 00:07:23.050 --> 00:07:25.649 And again, it's using all the internet data. 00:07:25.810 --> 00:07:28.670 And I also have another tab open where I cross 00:07:28.670 --> 00:07:31.149 -reference to see if these matches and schedules 00:07:31.149 --> 00:07:33.610 are correct. And they actually are correct. I 00:07:33.610 --> 00:07:36.170 don't know about 100 % of them, but the ones 00:07:36.170 --> 00:07:38.110 that I looked at, they look to be accurate in 00:07:38.110 --> 00:07:40.209 terms of who's playing who. Let me close the 00:07:40.209 --> 00:07:41.910 window on the right -hand side and look at this. 00:07:42.009 --> 00:07:46.069 So it broke out the FIFA World Cup 2026 match 00:07:46.069 --> 00:07:49.790 and travel guide. And it gave me all the matches 00:07:49.790 --> 00:07:53.449 for the group stages. So you can see the time 00:07:53.449 --> 00:07:56.329 that who's playing Mexico is playing South Africa, 00:07:56.490 --> 00:07:59.209 team one versus team two, the groups that they're 00:07:59.209 --> 00:08:01.389 in, the stadium that they're in, the host city, 00:08:01.529 --> 00:08:04.810 the country, the capacity of the stadium, and 00:08:04.810 --> 00:08:07.370 some notes, right? So this is an opening match. 00:08:07.569 --> 00:08:11.410 It says historic third hosting for Estadio Azteca. 00:08:12.199 --> 00:08:15.139 and then there's canada's first home world cup 00:08:15.139 --> 00:08:18.480 match is the third one stadium has 45 000 capacity 00:08:18.480 --> 00:08:21.180 and so it gives you all this information on the 00:08:21.180 --> 00:08:24.019 group stage and then it goes into the knockout 00:08:24.019 --> 00:08:27.420 rounds and it tells you you know a lot of these 00:08:27.420 --> 00:08:30.120 are tbd right because it depends on the previous 00:08:30.120 --> 00:08:32.980 outcomes but the locations of the stadiums are 00:08:32.980 --> 00:08:36.360 known and it tells you as terms of notes so this 00:08:36.360 --> 00:08:39.299 is information that you can use to analyze whether 00:08:39.299 --> 00:08:42.169 you want to pursue a ticket here or not and then 00:08:42.169 --> 00:08:44.850 it goes into qualified teams the FIFA rankings 00:08:44.850 --> 00:08:48.029 and star players so it's basically saying look 00:08:48.029 --> 00:08:51.870 in Spain and Argentina the star player here in 00:08:51.870 --> 00:08:55.470 Argentina everybody knows Lionel Messi and the 00:08:55.470 --> 00:08:59.330 second player Julian Alvarez and so on so it 00:08:59.330 --> 00:09:02.629 gave me that information and it's also telling 00:09:02.629 --> 00:09:06.450 me these different teams when they won winner 00:09:06.450 --> 00:09:11.360 in 2010 winner in 1996 gives me some notes so 00:09:11.360 --> 00:09:14.200 some good information here and then as we scroll 00:09:14.200 --> 00:09:17.519 further down it's giving me information about 00:09:17.519 --> 00:09:20.580 the host cities and the top 10 tourist attractions 00:09:20.580 --> 00:09:23.399 because if i'm going to go to new york at the 00:09:23.399 --> 00:09:26.100 metlife stadium with this capacity of a stadium 00:09:26.100 --> 00:09:30.399 82 500 what are some of the things to do there's 00:09:30.399 --> 00:09:32.980 a statue of liberty there's times square central 00:09:32.980 --> 00:09:36.139 park empire state building And it does this as 00:09:36.139 --> 00:09:40.460 well for AT &T Stadium, Los Angeles. It looks 00:09:40.460 --> 00:09:43.159 as Venice Beach is pretty cool and so on. So 00:09:43.159 --> 00:09:46.240 there's the tourist attraction side that I asked 00:09:46.240 --> 00:09:48.759 it. So it provided all that for me. And then 00:09:48.759 --> 00:09:51.139 some game attendance and recommendation ideas. 00:09:51.320 --> 00:09:54.539 So the number one priority, it says, is the World 00:09:54.539 --> 00:09:57.340 Cup final. But the ticket demand is extremely 00:09:57.340 --> 00:10:00.279 high. And why would you attend? Well, it's a 00:10:00.279 --> 00:10:02.960 once in a lifetime experience to see a world 00:10:02.960 --> 00:10:05.860 championship crown. It gives me all this great 00:10:05.860 --> 00:10:09.179 data as well as the tournament dates. It starts 00:10:09.179 --> 00:10:12.919 in June, it goes to July, 104 matches, 48 teams, 00:10:13.080 --> 00:10:15.720 and some tips for travel booking. Now that we 00:10:15.720 --> 00:10:17.840 have all this data, let's see what else we can 00:10:17.840 --> 00:10:20.519 do. What I'm gonna do first is I'm gonna go ahead 00:10:20.519 --> 00:10:23.820 and select new chat. And although agent mode 00:10:23.820 --> 00:10:27.059 is excellent at... doing all the work for us 00:10:27.059 --> 00:10:29.320 in the spreadsheet, you can see that there's 00:10:29.320 --> 00:10:31.279 not a lot of options here, right? So there's 00:10:31.279 --> 00:10:34.019 not a lot of information. You can basically type 00:10:34.019 --> 00:10:35.980 your own prompt in here, but you'd have to know 00:10:35.980 --> 00:10:39.179 what prompt to use. So what I recommend you do 00:10:39.179 --> 00:10:44.399 instead is you get out of agent mode. You can 00:10:44.399 --> 00:10:47.200 see that there's information in here around prompts 00:10:47.200 --> 00:10:49.580 you can type in, like analyzing this workbook, 00:10:49.840 --> 00:10:53.659 how can Copilot help, summarizing the data. And 00:10:53.659 --> 00:10:57.039 if you select see more, then you get a ton more 00:10:57.039 --> 00:10:59.779 prompts that you can type in so let's select 00:10:59.779 --> 00:11:02.159 are there any other trends in this data it says 00:11:02.159 --> 00:11:04.759 yeah there are several clear defensible trends 00:11:04.759 --> 00:11:07.399 so it gives me all this information but when 00:11:07.399 --> 00:11:10.039 you go all the way down to the bottom as it finishes 00:11:10.039 --> 00:11:13.220 executing this you'll see this section over here 00:11:13.220 --> 00:11:15.960 where you can either copy the response you can 00:11:15.960 --> 00:11:18.220 share the response you can open up in the word 00:11:18.220 --> 00:11:21.120 document or you can add it to a new sheet so 00:11:21.120 --> 00:11:24.330 let's go ahead and select that And then it opens 00:11:24.330 --> 00:11:27.149 up another sheet over here. So in addition to 00:11:27.149 --> 00:11:29.629 our main one, here's another one. We can change 00:11:29.629 --> 00:11:32.309 the name of this sheet. But it put all that information 00:11:32.309 --> 00:11:35.440 in this sheet. which is a lot easier to read 00:11:35.440 --> 00:11:38.480 than reading it on that small column over here 00:11:38.480 --> 00:11:40.600 on the right -hand side. That's way too difficult. 00:11:40.799 --> 00:11:43.460 Now here, maybe what we can do as we kind of 00:11:43.460 --> 00:11:45.100 wrap this up because there's so much you can 00:11:45.100 --> 00:11:48.059 do is we can ask you for a chart and we can say 00:11:48.059 --> 00:11:50.340 something like, given all the data in this spreadsheet, 00:11:50.559 --> 00:11:53.279 create a chart with the 10 matches I should attend. 00:11:53.799 --> 00:11:56.679 ranked in order. All right so I gave it that 00:11:56.679 --> 00:11:59.779 prompt and it took about 43 seconds and it came 00:11:59.779 --> 00:12:02.419 back here it says absolutely I use the rankings 00:12:02.419 --> 00:12:05.840 already embedded in the spreadsheet and it created 00:12:05.840 --> 00:12:08.139 this chart which is tiny but we can go ahead 00:12:08.139 --> 00:12:11.500 and select this plus add to new sheet and it 00:12:11.500 --> 00:12:13.919 goes ahead and puts it in here we can go ahead 00:12:13.919 --> 00:12:18.019 and expand it and here it is these are the matches 00:12:18.019 --> 00:12:22.779 that I should attend the world cup final extremely 00:12:22.779 --> 00:12:25.659 high, opening match Mexico, South Africa, Argentina, 00:12:25.860 --> 00:12:28.460 Brazil. So this is basically a visual representation 00:12:28.460 --> 00:12:31.100 of the data that was already there. So in summary, 00:12:31.240 --> 00:12:33.980 we learned about what agent mode is, what things 00:12:33.980 --> 00:12:36.419 are like without agent mode, the different large 00:12:36.419 --> 00:12:40.700 language models, Cloud, OpenAI, GPT -5 .2, different 00:12:40.700 --> 00:12:45.019 features inside Copilot. I think Excel and Copilot 00:12:45.019 --> 00:12:47.840 in Excel has come a long way since its inception, 00:12:48.019 --> 00:12:50.080 and it's only getting better. If you have any 00:12:50.080 --> 00:12:52.220 questions, comments, let me know. If you like 00:12:52.220 --> 00:12:54.100 this video, give it a like, consider subscribing. 00:12:54.600 --> 00:12:56.700 Thanks very much for watching and I'll catch 00:12:56.700 --> 00:12:57.860 you on the next one.