The FIFA World Cup is coming up and I don't have
any tickets. But instead of guessing, I'm going
to use Microsoft Copilot in Excel to figure out
exactly which games are worth going after. I'm
going to show you the features that I use so
that you can apply the same techniques in your
spreadsheets. My name is Shervin Shafi and I'm
a Copilot Principal Engineer at Microsoft. Now
let's get started. All right so we're in Excel
and we're using the web browser and if you notice
here on the right hand side you'll see this Copilot
icon and that shows up when you're in this home
menu and you can also right click and you can
see Copilot suggestions. So there's a couple
of different ways of accessing Copilot and when
you select chat with Copilot it does the same
thing as if you actually click this icon. it
opens up Copilot on the right hand side. So this
is the simplest way of accessing Copilot in Excel.
We got the blank spreadsheet in a web browser
and we're using the Microsoft 365 Copilot license
for businesses and commercial. If we kind of
quickly look at this, your navigation panel opens
up the fact that you can have a new chat, any
agents that you have access to. and also if you
scroll down to the bottom here you'll see all
the chats that you've had your different chat
histories shows up you can also click on all
chats to go to additional chat history so this
is the navigation panel this is the enterprise
data protection you can click on this link it'll
talk about microsoft privacy and security settings
and then this is your work and the web tab that
you can toggle between giving you access to your
work data or not and then this is a new chat
so if you have a chat you can click new chat
to start a new chat, and then these three dots
give you more options, like this is new. You
can select the model of OpenAI, either setting
it to auto, quick response, or think deeper,
or you can select more and go to 5 .2 options
of GPT, quick response or think deeper. So these
are things that you can customize. Then you can
go into schedule prompts, sending feedback, additional
settings, or a new temporary chat. So there's
a lot to kind of discover here. and take your
time to kind of understand what these do. For
me personally, I always just set it to auto and
call it a day and go from there. But what's new
that I wanted to bring your attention to is over
here with these two squiggly lines, this is the
tools menu. And now we have something called
agent mode that we release as Frontier, but it's
actually rolling out now as generally available.
So you don't have to be a Frontier user. you
might actually see this with not the parentheses
frontier it just shows agent mode and when you
select it it takes you to this other way that
copilot looks and it says that you're in agent
mode and you know that you're in agent mode because
it's giving you this icon over here and at the
moment i just want to give you a heads up that
when you're in agent mode it does not have access
to your work data only the internet This is going
to change in the future, but at the moment it's
only able to access the internet data. So you're
in agent mode and up along the top, again, you
can change the model, but this is also new. The
fact that you can go between auto GPT -5 .2,
which is open AI or Anthropix cloud. I don't
know if it's cloud or cloud. Let's just call
it cloud. Opus 4 .5. All right. So you have these
choices and we can experiment with what Anthropix
model does and what OpenAI's model does. But
before we even use agent mode, you might be wondering
what even is agent mode. So I'm going to go ahead
and X this out and let's figure out what is agent
mode. Now, I created a prompt that I'm going
to go ahead and paste in here. And this prompt
is for our FIFA World Cup. discovery around what
actually is something worthwhile looking into
for tickets so my prompt says look create a spreadsheet
on the upcoming fifa world cup include all the
games and the matches with info such as who is
playing who the famous players are on the teams
world rank of the team the date the time the
location of these games tourist info about the
top 10 things to do in each city and any other
info that you think is important i want to figure
out where I should go and what tickets I should
get. So I also want to know about the city. I'm
using this spreadsheet to decide which games
to attend. So when I give it a prompt like this
and I go ahead and send this off, then in typical
fashion, Copilot's going to do its research and
analyze my prompt and go out to the internet.
In this case, because I'm using this briefcase
icon, if there's work data that I have on FIFA,
which I don't, but if I did, It would also access
that information. And this is the typical mode.
This is not agent mode. So let's go ahead and
see what it comes back with. All right. So it
just finished. And again, remember, this is not
using agent mode. And it took a little bit of
time. You can see 329 seconds is how long it
took. And it did a bunch of stuff that you can
expand and look at all the reasoning and the
logic. But in the end, it came back and it said,
look. I created a World Cup 2026 attendance planning
spreadsheet. And it says that you can download
it here. And it tells me what's inside and how
it helps. And it has all this information in
here. Now, this is cool. This is great. And I'm
sure there's a ton of fantastic information.
But really, I'm a little bit disappointed because
if you look on the right -hand side, this whole
area is empty. And that is the trick with agent
mode. The thing about agent mode is that it actually
does the work for you on the left -hand side.
So while you might be able to go ahead and download
this spreadsheet that it's telling you over here,
and we can go ahead and click it and see what
it is. And this is what that document is, the
attachment. So it actually looked great. It has
information on matches, on teams, on cities,
on the sources, and even a short list. I actually
wanted it to do that all in that document in
the spreadsheet that I had instead of leaving
it blank. So again this is super cool but it's
not exactly what I was looking for. Now let's
give it the exact same prompt except this time
we're going to go ahead and use agent mode. So
to do that first I'm going to start a new chat.
So I'm going to select this icon and then I'm
going to go to the tools area and I'm going to
select agent mode. And then I'm going to go ahead
and paste in that same prompt that we used again
and execute. And let's see what happens with
this now. Now this is much better. I don't know
if you saw, but it created everything in the
spreadsheet with agent mode on the left -hand
side. There is a ton of information in here.
answers all the questions that i asked it so
let's look at this together a little bit now
remember we're using agent mode and at the moment
i have it just set to auto so i'm not quite sure
if it used open ai chat gpt 5 .2 or or the cloud
4 .5 and you can see that there's reasoning on
the right hand side that it explains how it did
it But I'm very impressed with the spreadsheet.
And again, it's using all the internet data.
And I also have another tab open where I cross
-reference to see if these matches and schedules
are correct. And they actually are correct. I
don't know about 100 % of them, but the ones
that I looked at, they look to be accurate in
terms of who's playing who. Let me close the
window on the right -hand side and look at this.
So it broke out the FIFA World Cup 2026 match
and travel guide. And it gave me all the matches
for the group stages. So you can see the time
that who's playing Mexico is playing South Africa,
team one versus team two, the groups that they're
in, the stadium that they're in, the host city,
the country, the capacity of the stadium, and
some notes, right? So this is an opening match.
It says historic third hosting for Estadio Azteca.
and then there's canada's first home world cup
match is the third one stadium has 45 000 capacity
and so it gives you all this information on the
group stage and then it goes into the knockout
rounds and it tells you you know a lot of these
are tbd right because it depends on the previous
outcomes but the locations of the stadiums are
known and it tells you as terms of notes so this
is information that you can use to analyze whether
you want to pursue a ticket here or not and then
it goes into qualified teams the FIFA rankings
and star players so it's basically saying look
in Spain and Argentina the star player here in
Argentina everybody knows Lionel Messi and the
second player Julian Alvarez and so on so it
gave me that information and it's also telling
me these different teams when they won winner
in 2010 winner in 1996 gives me some notes so
some good information here and then as we scroll
further down it's giving me information about
the host cities and the top 10 tourist attractions
because if i'm going to go to new york at the
metlife stadium with this capacity of a stadium
82 500 what are some of the things to do there's
a statue of liberty there's times square central
park empire state building And it does this as
well for AT &T Stadium, Los Angeles. It looks
as Venice Beach is pretty cool and so on. So
there's the tourist attraction side that I asked
it. So it provided all that for me. And then
some game attendance and recommendation ideas.
So the number one priority, it says, is the World
Cup final. But the ticket demand is extremely
high. And why would you attend? Well, it's a
once in a lifetime experience to see a world
championship crown. It gives me all this great
data as well as the tournament dates. It starts
in June, it goes to July, 104 matches, 48 teams,
and some tips for travel booking. Now that we
have all this data, let's see what else we can
do. What I'm gonna do first is I'm gonna go ahead
and select new chat. And although agent mode
is excellent at... doing all the work for us
in the spreadsheet, you can see that there's
not a lot of options here, right? So there's
not a lot of information. You can basically type
your own prompt in here, but you'd have to know
what prompt to use. So what I recommend you do
instead is you get out of agent mode. You can
see that there's information in here around prompts
you can type in, like analyzing this workbook,
how can Copilot help, summarizing the data. And
if you select see more, then you get a ton more
prompts that you can type in so let's select
are there any other trends in this data it says
yeah there are several clear defensible trends
so it gives me all this information but when
you go all the way down to the bottom as it finishes
executing this you'll see this section over here
where you can either copy the response you can
share the response you can open up in the word
document or you can add it to a new sheet so
let's go ahead and select that And then it opens
up another sheet over here. So in addition to
our main one, here's another one. We can change
the name of this sheet. But it put all that information
in this sheet. which is a lot easier to read
than reading it on that small column over here
on the right -hand side. That's way too difficult.
Now here, maybe what we can do as we kind of
wrap this up because there's so much you can
do is we can ask you for a chart and we can say
something like, given all the data in this spreadsheet,
create a chart with the 10 matches I should attend.
ranked in order. All right so I gave it that
prompt and it took about 43 seconds and it came
back here it says absolutely I use the rankings
already embedded in the spreadsheet and it created
this chart which is tiny but we can go ahead
and select this plus add to new sheet and it
goes ahead and puts it in here we can go ahead
and expand it and here it is these are the matches
that I should attend the world cup final extremely
high, opening match Mexico, South Africa, Argentina,
Brazil. So this is basically a visual representation
of the data that was already there. So in summary,
we learned about what agent mode is, what things
are like without agent mode, the different large
language models, Cloud, OpenAI, GPT -5 .2, different
features inside Copilot. I think Excel and Copilot
in Excel has come a long way since its inception,
and it's only getting better. If you have any
questions, comments, let me know. If you like
this video, give it a like, consider subscribing.
Thanks very much for watching and I'll catch
you on the next one.