WEBVTT 00:00:00.000 --> 00:00:02.399 Today I'll show you the latest Microsoft 365 00:00:02.399 --> 00:00:05.879 Co -Pilot tips to help you work smarter. My name 00:00:05.879 --> 00:00:07.799 is Shervin Shafi and I'm a Co -Pilot Principal 00:00:07.799 --> 00:00:11.199 Engineer at Microsoft. Welcome to Collaboration 00:00:11.199 --> 00:00:14.099 Simplified. Tip number one is sharing your favorite 00:00:14.099 --> 00:00:15.919 prompts with your teammates. So what we're going 00:00:15.919 --> 00:00:19.379 to do is we're going to go to the m365copilot 00:00:19.379 --> 00:00:22.199 .com from your favorite web browser. Once we're 00:00:22.199 --> 00:00:24.379 here, basically, if you look on the left -hand 00:00:24.379 --> 00:00:26.300 side, you have all these different menu items 00:00:26.300 --> 00:00:28.760 like search and chat, and we're going to stick 00:00:28.760 --> 00:00:31.960 in chat. And by the way, this is M365 Copilot 00:00:31.960 --> 00:00:34.479 for business and enterprise, not for personal 00:00:34.479 --> 00:00:37.060 or for family use. Now, once in a while, you 00:00:37.060 --> 00:00:39.159 get this really awesome prompt, or maybe you 00:00:39.159 --> 00:00:41.420 build a prompt that you want to just share with 00:00:41.549 --> 00:00:43.729 everyone and instead of copying and pasting it 00:00:43.729 --> 00:00:46.649 and dropping it inside a team's chat or an email 00:00:46.649 --> 00:00:49.270 there's a way you can do this built into this 00:00:49.270 --> 00:00:51.990 application that we're looking at so let me grab 00:00:51.990 --> 00:00:54.189 this awesome prompt that someone just shared 00:00:54.189 --> 00:00:57.289 with me recently and I'm gonna go ahead and drop 00:00:57.289 --> 00:01:01.250 it inside this panel and basically this is a 00:01:01.250 --> 00:01:04.950 prompt that you can use to say no when someone 00:01:04.950 --> 00:01:08.030 asks you to do something At work and it uses 00:01:08.030 --> 00:01:10.390 this kind of planned framework of pause listen 00:01:10.390 --> 00:01:13.689 assess name and translate to say no in a very 00:01:13.689 --> 00:01:16.730 nice political way And so basically i'm going 00:01:16.730 --> 00:01:18.829 to go ahead and execute this prompt and have 00:01:18.829 --> 00:01:21.230 it run and it comes back and it asks a bunch 00:01:21.230 --> 00:01:24.769 of questions like What's your role and what exactly 00:01:24.769 --> 00:01:27.689 are you being asked to do and what's your hesitation 00:01:27.689 --> 00:01:30.269 in doing this? So once you respond to these questions 00:01:30.269 --> 00:01:38.090 like i'm a sales manager I was asked to attend 00:01:38.090 --> 00:01:43.670 a last minute meeting. My hesitation is don't 00:01:43.670 --> 00:01:47.390 have enough time to prepare, right? This is a 00:01:47.390 --> 00:01:50.109 very common ask and you can be very specific 00:01:50.109 --> 00:01:52.530 about whatever your role is and your hesitation 00:01:52.530 --> 00:01:56.069 is. So once we go ahead and execute this, it 00:01:56.069 --> 00:02:00.450 comes back using this plant method of the suggested 00:02:00.450 --> 00:02:03.959 response, which is right over here. And you can 00:02:03.959 --> 00:02:08.080 even draft three more variations. So this is 00:02:08.080 --> 00:02:10.740 typical AI where it gives you a lot of different 00:02:10.740 --> 00:02:13.860 options. So whatever looks good as far as maybe 00:02:13.860 --> 00:02:16.800 this one is assertive but diplomatic, you can 00:02:16.800 --> 00:02:19.919 go ahead and use them when you want to respond. 00:02:20.669 --> 00:02:23.129 now the key here is we want to know how do we 00:02:23.129 --> 00:02:26.370 share this awesome prompt with our team inside 00:02:26.370 --> 00:02:29.370 the application so if you notice on the top when 00:02:29.370 --> 00:02:31.909 you look at the actual prompt that you pasted 00:02:31.909 --> 00:02:34.469 you have all these different icons it's this 00:02:34.469 --> 00:02:36.729 icon that i'm interested in and i'm going to 00:02:36.729 --> 00:02:40.050 go ahead and select it and basically this allows 00:02:40.050 --> 00:02:42.490 me to save the prompt or bookmark the prompt 00:02:42.490 --> 00:02:44.590 something that i actually showed a while back 00:02:44.590 --> 00:02:47.169 but there's a new feature so let's change the 00:02:47.169 --> 00:02:51.659 title to help saying no and go ahead and save 00:02:51.659 --> 00:02:55.479 it. Now this actually saves it inside the Copilot 00:02:55.479 --> 00:02:58.139 Prompt Gallery, which you can go ahead and select 00:02:58.139 --> 00:03:01.539 this hyperlink and get there. Or if you notice 00:03:01.539 --> 00:03:04.340 on the bottom right, there's this peculiar icon 00:03:04.340 --> 00:03:06.860 that when you select that, it actually takes 00:03:06.860 --> 00:03:10.180 you to the Copilot Prompt Gallery as well. Now 00:03:10.180 --> 00:03:12.840 here we're in the Suggested tab, but if we go 00:03:12.840 --> 00:03:16.620 to the Your Prompts tab, what I just saved shows 00:03:16.620 --> 00:03:20.090 up. but how do you share it with a team so basically 00:03:20.090 --> 00:03:23.889 what you do is you select this icon which is 00:03:23.889 --> 00:03:27.050 the share prompt and it allows you to share it 00:03:27.050 --> 00:03:30.349 to a team right here so these are actually teams 00:03:30.349 --> 00:03:34.430 that are microsoft teams and the channels that 00:03:34.430 --> 00:03:36.469 correspond to them but just the actual overall 00:03:36.469 --> 00:03:39.030 team so here i'm part of an engineering team 00:03:39.030 --> 00:03:41.530 leadership team operations team so if i want 00:03:41.530 --> 00:03:43.550 to share this with the engineering team i just 00:03:43.550 --> 00:03:47.400 selected select share and now you can see up 00:03:47.400 --> 00:03:49.819 here it says that the prompt was shared with 00:03:49.819 --> 00:03:52.740 the team and it added this team's prompt and 00:03:52.740 --> 00:03:56.180 when i go there it basically says that me arnold 00:03:56.180 --> 00:03:59.060 shared this prompt and other people that are 00:03:59.060 --> 00:04:03.780 part of that team can now access it inside m365 00:04:03.780 --> 00:04:06.800 copilot and the prompt gallery that's built in 00:04:07.360 --> 00:04:09.979 And oh, by the way, if you don't have a team, 00:04:10.259 --> 00:04:12.759 you want to create your own team. This is just 00:04:12.759 --> 00:04:15.740 an exercise in Microsoft Teams. So if I go to 00:04:15.740 --> 00:04:18.399 Microsoft Teams, if you notice up on the top, 00:04:18.639 --> 00:04:21.439 there's this icon right here. And if you select 00:04:21.439 --> 00:04:23.899 that, you can go ahead and create a new team. 00:04:24.040 --> 00:04:26.540 You can create it from scratch or you can use 00:04:26.540 --> 00:04:29.060 different templates. And basically, there's a 00:04:29.060 --> 00:04:32.019 whole way of creating teams. And when you create 00:04:32.019 --> 00:04:34.889 this team. it'll show up over there in the prompt 00:04:34.889 --> 00:04:37.470 gallery so that was tip number one tip number 00:04:37.470 --> 00:04:41.550 two is teams mode for microsoft 365 copilot and 00:04:41.550 --> 00:04:43.709 interestingly enough this got announced today 00:04:43.709 --> 00:04:48.709 so if i go back to the m365 copilot app basically 00:04:48.709 --> 00:04:52.089 if i look at this prompt that we just looked 00:04:52.089 --> 00:04:55.790 at and i scroll down to the bottom maybe this 00:04:55.790 --> 00:04:59.490 is an awesome response that i got back from copilot 00:04:59.490 --> 00:05:02.519 that i want to share with someone And if you 00:05:02.519 --> 00:05:06.740 notice up along the top, this icon is actually 00:05:06.740 --> 00:05:09.939 brand new as of today. So when I select that, 00:05:10.160 --> 00:05:13.879 it allows me to start a group chat inside Teams. 00:05:13.939 --> 00:05:17.689 And when I select that. It allows me to add people 00:05:17.689 --> 00:05:21.490 to this response that Copilot just gave me. So 00:05:21.490 --> 00:05:23.529 one of the people that I work with very closely 00:05:23.529 --> 00:05:26.870 is Albert. Yeah, you know him. It's Albert Einstein. 00:05:27.089 --> 00:05:29.970 And I can actually select him and many other 00:05:29.970 --> 00:05:32.790 people and create a group chat along with Copilot 00:05:32.790 --> 00:05:35.769 so that we can all collaborate with AI in the 00:05:35.769 --> 00:05:38.410 mix. I can even select how many messages I want 00:05:38.410 --> 00:05:41.009 to drop in to this group chat. So let's go ahead 00:05:41.009 --> 00:05:43.939 and select all of them. and select create so 00:05:43.939 --> 00:05:46.240 this takes a second and it says that this group 00:05:46.240 --> 00:05:48.399 chat is being created you're going to get a notification 00:05:48.399 --> 00:05:51.600 so here it is i just got the pop -up that my 00:05:51.600 --> 00:05:54.339 group chat is ready and if i go to microsoft 00:05:54.339 --> 00:05:57.920 teams and i go to chats and i basically scroll 00:05:57.920 --> 00:06:00.180 up i can see that there's a new room created 00:06:00.180 --> 00:06:04.350 with albert einstein and if i select this section 00:06:04.350 --> 00:06:06.850 over here to see who's in the room it's basically 00:06:06.850 --> 00:06:11.389 going to be me and albert and co -pilot and all 00:06:11.389 --> 00:06:14.089 our interactions in terms of me putting in the 00:06:14.089 --> 00:06:17.670 initial prompt and then the response back asking 00:06:17.670 --> 00:06:20.540 me these three questions and me telling it additional 00:06:20.540 --> 00:06:24.579 information. It's all here. So now Albert sees 00:06:24.579 --> 00:06:28.139 everything. I see everything. And I can go ahead 00:06:28.139 --> 00:06:31.819 and type in at Copilot and interact with Copilot 00:06:31.819 --> 00:06:35.399 even more. So I can say, hey, Copilot, what other 00:06:35.399 --> 00:06:39.180 variations are there? And Copilot will go ahead 00:06:39.180 --> 00:06:41.819 and respond in this group chat. And Albert sees 00:06:41.819 --> 00:06:44.339 it. Albert can ask questions of me or Copilot 00:06:44.339 --> 00:06:47.420 as well. And so Copilot just came back and said 00:06:47.420 --> 00:06:49.860 that these are all the other variations. like 00:06:49.860 --> 00:06:53.279 an empathetic one or a strategic one and so on 00:06:53.279 --> 00:06:56.360 and so forth. So this is brand new. It's basically 00:06:56.360 --> 00:07:00.240 Teams mode for Copilot M365. That's tip number 00:07:00.240 --> 00:07:03.319 two. Tip number three, researcher with Anthropix 00:07:03.319 --> 00:07:07.620 Cloud. So here, if we go back to this M365 Copilot 00:07:07.620 --> 00:07:10.060 app, and if you notice on the left -hand side 00:07:10.060 --> 00:07:13.899 under agents, we have a few and we have researcher 00:07:13.899 --> 00:07:16.399 and we have analyst. So if we select researcher, 00:07:17.230 --> 00:07:19.670 if you notice on the top right hand side now 00:07:19.670 --> 00:07:22.889 there's a new section called try cloud i also 00:07:22.889 --> 00:07:26.810 want you to notice this green shield so basically 00:07:26.810 --> 00:07:30.089 if you're not familiar anthropic is another large 00:07:30.089 --> 00:07:33.850 language model creator of cloud we at microsoft 00:07:33.850 --> 00:07:37.449 we use open ai's large language models traditionally 00:07:37.449 --> 00:07:40.230 which is what we're looking at right now, but 00:07:40.230 --> 00:07:43.790 you can select try cloud. And if I do that, I 00:07:43.790 --> 00:07:46.170 want you to notice what happens to this shield 00:07:46.170 --> 00:07:48.290 icon, which is your enterprise data protection. 00:07:48.589 --> 00:07:51.970 I'm gonna select it. And now that cloud is on, 00:07:52.069 --> 00:07:54.910 you can see that basically this shield got grayed 00:07:54.910 --> 00:07:58.199 out. this is interesting in that you can now 00:07:58.199 --> 00:08:02.000 use your large language model of choice it doesn't 00:08:02.000 --> 00:08:05.399 have to be open ai it can be anthropic but the 00:08:05.399 --> 00:08:08.639 enterprise security changes and this is because 00:08:08.639 --> 00:08:11.720 cloud's large language models are hosted outside 00:08:11.720 --> 00:08:14.160 of microsoft's data centers and so basically 00:08:14.160 --> 00:08:17.040 you're governed by anthropics terms of service 00:08:17.040 --> 00:08:18.899 and so if you want to have a little bit more 00:08:18.899 --> 00:08:21.480 info when you select the cloud you can go ahead 00:08:21.480 --> 00:08:24.850 and select learn more opens up another tab and 00:08:24.850 --> 00:08:28.149 over here it basically has a box that says that 00:08:28.149 --> 00:08:31.290 the terms and the data handling because this 00:08:31.290 --> 00:08:33.350 is outside of microsoft you can go ahead and 00:08:33.350 --> 00:08:36.289 click it and it takes you to anthropics commercial 00:08:36.289 --> 00:08:39.970 terms of service so you have the option of using 00:08:39.970 --> 00:08:42.389 it it's just that the security model changes 00:08:42.389 --> 00:08:46.230 and so let's go ahead and put a prompt in and 00:08:46.230 --> 00:08:48.289 i don't know if you guys are aware but right 00:08:48.289 --> 00:08:51.169 now the blue jays are actually in the world series 00:08:51.169 --> 00:08:54.029 which is awesome so here's a little question 00:08:54.029 --> 00:08:57.029 from a research perspective who are the main 00:08:57.029 --> 00:09:00.350 players on the blue jays team and what are their 00:09:00.350 --> 00:09:03.210 stats including how long they've been on the 00:09:03.210 --> 00:09:05.470 team so let's go ahead and ask researcher with 00:09:05.470 --> 00:09:08.409 cloud on this question and so for those of you 00:09:08.409 --> 00:09:11.120 who haven't used researcher before it does very 00:09:11.120 --> 00:09:13.639 deep reasoning and so the first thing generally 00:09:13.639 --> 00:09:16.220 it does is it comes back and it asks you some 00:09:16.220 --> 00:09:18.559 additional questions so it says are you interested 00:09:18.559 --> 00:09:21.580 in all positions or just the key starters should 00:09:21.580 --> 00:09:25.580 i focus on the 2025 season and do you want career 00:09:25.580 --> 00:09:28.379 stats so let's you can you can basically say 00:09:28.379 --> 00:09:32.840 just go ahead or i can say one all positions 00:09:32.840 --> 00:09:40.139 two 20 25 only and three career stats So let's 00:09:40.139 --> 00:09:42.399 go ahead and run. And this takes a little bit 00:09:42.399 --> 00:09:45.039 of time. And as it's going through its process, 00:09:45.259 --> 00:09:48.279 you can see all the activities. So I'll come 00:09:48.279 --> 00:09:51.240 back here in just a minute once it's done. Okay, 00:09:51.299 --> 00:09:54.100 so cloud finished. And you can see it did quite 00:09:54.100 --> 00:09:56.399 a bit of analysis. And again, this is a little 00:09:56.399 --> 00:09:58.860 bit different than OpenAI. So you can turn this 00:09:58.860 --> 00:10:02.919 on or off by just toggling this. And it basically 00:10:02.919 --> 00:10:06.500 gave me a summary of the 2025 main players. There's 00:10:06.500 --> 00:10:08.980 statistics for each of these different players. 00:10:09.610 --> 00:10:12.470 as well as the outfielders the players names 00:10:12.470 --> 00:10:16.149 and starting pictures and so on so it did a really 00:10:16.149 --> 00:10:18.690 good job and now when we scroll all the way down 00:10:18.690 --> 00:10:21.909 to the bottom i can basically select this icon 00:10:21.909 --> 00:10:25.590 that takes me to pages and from there i can export 00:10:25.590 --> 00:10:28.350 it to a word document which is this icon right 00:10:28.350 --> 00:10:30.509 here up along the top so i'm going to select 00:10:30.509 --> 00:10:35.970 word so here it is now as a word document everything 00:10:35.970 --> 00:10:38.840 that the researcher using cloud basically gave 00:10:38.840 --> 00:10:43.100 me inside M365 Copilot is here and I can go ahead 00:10:43.100 --> 00:10:45.980 and share this. I can also select view more and 00:10:45.980 --> 00:10:48.480 look at the AI summary, look at insights, look 00:10:48.480 --> 00:10:51.220 at activities, and even export this as a podcast. 00:10:51.679 --> 00:10:54.139 Tip number four, adding to your Copilot memory. 00:10:54.559 --> 00:10:58.019 So now if we go back to the M365 Copilot app 00:10:58.019 --> 00:11:01.279 and we basically select chat on the left hand 00:11:01.279 --> 00:11:04.320 side, you can actually tell Copilot to remember 00:11:04.320 --> 00:11:08.879 things. So you can say, remember, that I like 00:11:08.879 --> 00:11:12.779 the Toronto Blue Jays. And when you write that, 00:11:12.980 --> 00:11:16.740 it'll basically say here, memory updated, and 00:11:16.740 --> 00:11:18.659 it says, got it, I'll remember that you are a 00:11:18.659 --> 00:11:21.080 fan of the Toronto Blue Jays. I can also say, 00:11:21.220 --> 00:11:30.740 remember that I want sports info only on Toronto 00:11:30.740 --> 00:11:36.029 teams. And it says memory updated. Got it. I'll 00:11:36.029 --> 00:11:38.330 make sure any sports updates are focused only 00:11:38.330 --> 00:11:41.350 on Toronto teams. Now, the thing is, if you look 00:11:41.350 --> 00:11:44.289 on the top right hand side with these three dots, 00:11:44.370 --> 00:11:46.789 when you select that and you go to settings, 00:11:46.990 --> 00:11:49.950 you can see that there's a bunch of menu items 00:11:49.950 --> 00:11:52.870 and there's one called personalization. And when 00:11:52.870 --> 00:11:55.210 you select that, we actually did a session on 00:11:55.210 --> 00:11:57.309 custom instructions, but there's also copilot 00:11:57.309 --> 00:12:00.049 memory. And when you select copilot memory, what 00:12:00.049 --> 00:12:03.139 I just told it in terms of. user wants sports 00:12:03.139 --> 00:12:05.879 information only on toronto teams and user likes 00:12:05.879 --> 00:12:08.919 the toronto blue jays is here and you can also 00:12:08.919 --> 00:12:12.159 delete them so you can start to add to copilot's 00:12:12.159 --> 00:12:14.659 memory so that when it responds it'll respond 00:12:14.659 --> 00:12:17.159 based on your preferences so for example if i 00:12:17.159 --> 00:12:21.059 go back out of here and i select this top icon 00:12:21.059 --> 00:12:25.139 here this start new chat and i ask it a question 00:12:25.139 --> 00:12:32.590 like what sports teams are playing in the next 00:12:32.590 --> 00:12:35.710 week now that's kind of a vague question right 00:12:35.710 --> 00:12:38.730 this can be so many different sports teams around 00:12:38.730 --> 00:12:42.330 the world but based on the memory it's basically 00:12:42.330 --> 00:12:44.549 giving me information about the toronto blue 00:12:44.549 --> 00:12:47.070 jays and the toronto raptors and the toronto 00:12:47.070 --> 00:12:50.330 maple leafs which is perfect right this is exactly 00:12:50.330 --> 00:12:53.389 what i wanted it to do so that's memory that's 00:12:53.389 --> 00:12:56.549 tip number four tip number five agent mode in 00:12:56.549 --> 00:13:00.860 excel Now, if we open up Microsoft Excel, and 00:13:00.860 --> 00:13:03.940 if we select create a blank workbook, there's 00:13:03.940 --> 00:13:05.879 a new feature that got announced maybe about 00:13:05.879 --> 00:13:09.120 a month ago called agent mode. And the idea around 00:13:09.120 --> 00:13:11.960 agent mode is that you can get Copilot not just 00:13:11.960 --> 00:13:14.580 to respond to you, but to actually do things 00:13:14.580 --> 00:13:17.799 for you inside your worksheets, like create charts 00:13:17.799 --> 00:13:20.279 and graphs and so on. So without agent mode, 00:13:20.440 --> 00:13:23.620 if I select Copilot on the top right hand side, 00:13:23.759 --> 00:13:26.299 and I just select it, it says, what are we solving 00:13:26.299 --> 00:13:29.220 today? And I can ask it a question like, create 00:13:29.220 --> 00:13:39.140 a table for me about the Toronto Blue Jays. and 00:13:39.140 --> 00:13:44.620 I can click plus and I can add work content from 00:13:44.620 --> 00:13:49.139 this Blue Jays document that I just created six 00:13:49.139 --> 00:13:52.259 minutes ago. And I can go ahead and send it and 00:13:52.259 --> 00:13:54.279 let's see what it does here. This is without 00:13:54.279 --> 00:13:57.759 agent mode. This is typical copilot inside Microsoft 00:13:57.759 --> 00:14:01.700 Excel. So it says you asked me for a table summarizing 00:14:01.700 --> 00:14:04.700 the Toronto Blue Jays and basically it gives 00:14:04.700 --> 00:14:09.360 me all this information but it doesn't do anything 00:14:09.360 --> 00:14:12.639 inside the worksheet okay so you can see the 00:14:12.639 --> 00:14:14.720 worksheet itself on the left hand side is blank 00:14:14.720 --> 00:14:17.039 now this is what you have to do this is one of 00:14:17.039 --> 00:14:19.120 these frontier features so there's a couple steps 00:14:19.120 --> 00:14:22.419 involved what you need to do is on the top here 00:14:22.419 --> 00:14:26.279 you have to select add in and you have to type 00:14:26.279 --> 00:14:32.220 in excel labs and when this excel labs comes 00:14:32.220 --> 00:14:35.419 up you have to select add So let's go ahead and 00:14:35.419 --> 00:14:37.860 select add. And notice that this is from the 00:14:37.860 --> 00:14:40.860 web browser, right? So I'm not sure if the application 00:14:40.860 --> 00:14:43.980 itself, if you've downloaded it, works. But everything 00:14:43.980 --> 00:14:46.899 that I've done so far is using web apps. Now, 00:14:46.919 --> 00:14:50.519 when Excel Labs loads, you'll see that this agent 00:14:50.519 --> 00:14:53.139 mode, which is a frontier feature, shows up. 00:14:53.500 --> 00:14:55.899 And you can make it the default or you can just 00:14:55.899 --> 00:14:57.600 open it. So I'm going to go ahead and make it 00:14:57.600 --> 00:15:00.879 default. I'm going to select open. And you can 00:15:00.879 --> 00:15:04.970 see that agent mode is here now. Okay. Now I'm 00:15:04.970 --> 00:15:07.590 going to close this out and I'm going to X this 00:15:07.590 --> 00:15:12.450 out. And when I go to Copilot, let's see if the 00:15:12.450 --> 00:15:16.049 Copilot changes in any way. The Copilot doesn't 00:15:16.049 --> 00:15:19.590 seem to change. It looks the same. So what I'm 00:15:19.590 --> 00:15:21.750 going to do is I'm going to go ahead and hit 00:15:21.750 --> 00:15:25.269 this refresh on this browser and let's see what 00:15:25.269 --> 00:15:28.169 happens here. So I'm just refreshing the browser. 00:15:28.590 --> 00:15:33.509 I'm going to select Copilot again. and this time 00:15:33.509 --> 00:15:37.730 around if you notice this new icon came up these 00:15:37.730 --> 00:15:41.730 these two lines so if i select that now you can 00:15:41.730 --> 00:15:44.990 see that agent mode actually shows up and that's 00:15:44.990 --> 00:15:49.509 after i added this add -in of excel labs so when 00:15:49.509 --> 00:15:54.429 i select agent mode i can go ahead and ask it 00:15:54.779 --> 00:15:56.899 the same question create a table for me about 00:15:56.899 --> 00:15:59.259 the toronto blue jays players but unfortunately 00:15:59.259 --> 00:16:02.480 i can't put slash or add the document so i'm 00:16:02.480 --> 00:16:05.279 going to go to that word document that we created 00:16:05.279 --> 00:16:07.840 together and i'm going to go ahead and click 00:16:07.840 --> 00:16:10.639 share on the top right hand side and copy the 00:16:10.639 --> 00:16:16.039 link And then go back to Excel and then go ahead 00:16:16.039 --> 00:16:18.139 and put the link in. Let's see what it does here. 00:16:18.279 --> 00:16:21.379 Now, this is similar to Researcher in that it 00:16:21.379 --> 00:16:24.399 does deep analysis. And when you open up this 00:16:24.399 --> 00:16:27.100 arrow here, you can see all the activity. So 00:16:27.100 --> 00:16:29.259 it takes a little bit of time. But the key is 00:16:29.259 --> 00:16:31.259 that it actually does something for you in your 00:16:31.259 --> 00:16:33.860 worksheet. Instead of just telling you what to 00:16:33.860 --> 00:16:35.519 do, it's going to do it for you. So let's see 00:16:35.519 --> 00:16:43.700 how this plays out. okay looks like it's done 00:16:43.700 --> 00:16:46.039 and you saw that on the left hand side it was 00:16:46.039 --> 00:16:48.840 creating the table which looks awesome and so 00:16:48.840 --> 00:16:51.460 it has information about the player their jersey 00:16:51.460 --> 00:16:54.440 number roster group their height their weight 00:16:54.440 --> 00:16:57.860 date of birth their age and if you notice this 00:16:57.860 --> 00:16:59.960 section here the source this is where it got 00:16:59.960 --> 00:17:02.710 all the information from so Although I put the 00:17:02.710 --> 00:17:05.309 link in for the document, I don't think it used 00:17:05.309 --> 00:17:08.130 that Word document that we created using Researcher. 00:17:08.170 --> 00:17:11.210 And that might just be a function of where this 00:17:11.210 --> 00:17:14.049 Frontier agent is today, hence why it didn't 00:17:14.049 --> 00:17:17.730 have the plus for me to add it. So it just essentially 00:17:17.730 --> 00:17:19.789 went out to the internet and got its information 00:17:19.789 --> 00:17:22.349 from there. If you enjoyed this video, make sure 00:17:22.349 --> 00:17:24.549 to give it a thumbs up and consider subscribing. 00:17:24.890 --> 00:17:27.309 Drop your questions in the comments and I'll 00:17:27.309 --> 00:17:28.690 catch you on the next one.