[Excel Esports Announcer]
What if Excel could be a game?
What if players from all over the world came
together and battled it out to see who's the
smartest and fastest user of Excel?
What if tech gurus could finally be recognized
for their skills?
What if this was a weekly evening TV show?
That's how Excel Esports was born.
[Bill Jelen]
Welcome to the Excel Esports: All-Star Battle.
We have eight household names who compete
in three awesome Excel gaming competitions.
To find out who is the best at solving impossible
Excel puzzles.
[Oz du Soleil]
Yeah, I'd say awesome as in the dictionary
definition of awesome: terrifying.
[Bill Jelen]
Terrifying.
All right.
This is going to be an exciting day here.
We have eight players, three rounds of different
Excel game challenges.
In the first round, all eight will be going
head to head.
The top four will advance to the semifinals.
And then the remaining two battle it out for
the win.
The time for one task: 30 minutes.
[David Brown]
To me, it's an opportunity to have some fun.
[Diarmuid Early:]
There's a lot of pressure when there's three
or seven or even one other person building
the same model at the same time and you're
all racing through it.
It's literally, what can you do to shave off
one second here and there?
[Gabriela Strój]
It's a skill that I'm using on everyday basis.
I feel like it is a bit connected with my
body and so on.
[Andrew Ngai]
The variety of things that are entertaining
and involve skill and abilities, because that's
basically what a sport is, right?
[David Brown]
When I watch other people do these competitions,
I learn functions that I didn't know existed.
[Gabriela Strój]
I can use this skill to have fun and to show
others that solving some problems in Excel
doesn't have to be dull.
[Diarmuid Early:]
It's all about the speed.
[Excel Esports Announcer]
No, we will not be dealing with social media
content here.
Instead we will revise the old mechanical
slot machines.
The participants will be creating an online
game similar to slot machines.
However, we don't want to use it for gambling,
so the game is free and instead of money points
are awarded.
To get the correct number of answers and advance
further participants have to find out the
total number of points rolled in each level
of difficulty.
There are five levels of difficulty in the
game, starting from only one strip in one
roll, adding extra difficulty on the go, and
finally modeling a machine with five reels
and a 10 turns.
The game will use a total of five reel strips
with 19 sectors each.
There are a total of eight different symbols,
one symbol at each sector.
The game starts with all five reels standing
on the starting sector.
Good luck.
[Bill Jelen]
Good luck indeed.
We'll see you all in 30 minutes.
[Oz du Soleil]
All right.
Now 3, 2, 1, go.
[Bill Jelen]
This is great.
[Oz du Soleil]
Yeah.
[Bill Jelen]
We have the ability to watch any of the eight
screens.
[Oz du Soleil]
Yep.
That's right.
[Bill Jelen]
We'll start with our fan favorite: Diarmud
Early.
Diarmud has been referred to as the LeBron
James of Excel.
He won the FMWC regular tournament last year,
is currently number two in the rankings.
In Level One, they're trying to just get that
whole concept of counting.
How far, how…
Look he's using the mod function.
That mod function.
[Oz du Soleil]
Oh, already.
[Bill Jelen]
So his goes back to your high school math
class, where you did a division and you're
getting the remainder.
So in this Case they're moving the reel 93
spaces and every 19 it resets.
So a mod function there would be one way to
do it.
[Oz du Soleil]
When I did this, I looked at the maximum number
of spins, like that 77, 57, 69, add them all
up together and then stack the 19 beyond that.
[Bill Jelen]
Look at this.
Dim is off to a quick lead with 60 points
already.
[Oz du Soleil]
Wow.
[Bill Jelen]
We're barely a couple minutes in and he's
already solved the first level.
This is wild.
Holy smokes.
[Oz du Soleil]
Yes, it is.
[Bill Jelen]
Oh, 220 points.
This is crazy.
[Oz du Soleil]
Already!
Okay.
All right.
[Bill Jelen]
He's off to an amazing start.
In less than two minutes, he's already got
a fifth of the points.
[Diarmuid Early:]
I don't know if you've heard the expression,
but they say that any sufficiently advanced
technology is indistinguishable from magic.
And I think sometimes people look at what
I'm doing in Excel and think it must be magic,
but it's just the same thing, but just doing
it a little faster, maybe, or a little differently.
[Oz du Soleil]
Let's take a look at Gabriela.
Gabriela's from Poland, working at PWC, and
she's had huge success in these Excel Esport
challenges.
[Gabriela Strój]
I love to get to know how the works work because
the financial models they explain what are
the main drivers and what are the main how
any business works.
[Bill Jelen]
Do you need to power up your staff's Excel
skills?
Hire MrExcel for a one hour virtual webinar.
Train your whole team.
Everyone receives a copy of Bill's ebook.
Visit MrExcel.com today for a special ESPN
Ocho price of 8.88 for a one hour event and
great deals on many of our Excel and Power
BI books.
If you use Excel 40 hours a week, and those
are the weeks you're on vacation, you will
love this webinar.
[Copper Fit Announcer]
Need arch support but orthotics make your
shoes too tight?
Now there's Copper Fit Arch Relief Plus, the
revolutionary adjustable orthotic arch supports
that form fit to your feet, not your shoes,
so you can comfortably wear them in any shoes.
[Copper Fit Speaker 2:]
Every shoe that I have, it makes a difference
in.
Whether I'm barefoot, wearing flip flops,
basketball shoes, running shoes.
[Copper Fit Announcer]
A copper infused adjustable compression band
with a built-in semi-rigid orthotic arch support
that form fits to your arches for support
and pain relief exactly where you need it,
whenever you want it.
So thin, so comfortable.
For planter fasciitis, fallen arches, flat
feet.
[Copper Fit Speaker 3]
I feel a huge difference.
It fits perfectly right where there's pressure
on my feet.
[Copper Fit Announcer]
The fast, easy way to get foot relief.
Guaranteed or your money back.
Order right now and your shipping is free.
[Copper Fit Speaker 2:]
It's arch support without the shoe.
You don't need the shoe.
[Copper Fit Speaker 4]
Dress shoes, tennis shoes, doesn't matter
what you're wearing.
This fits your foot.
Your foot fits your shoes.
That's it.
[Copper Fit Announcer]
Arch Relief Plus.
Only from Copper Fit.
[Brian Kenny]
We've been watching a lot of soccer at the
office lately.
Seems to be causing a rise in workplace injuries.
[Sports Center Ad Speaker 2]
Setting up a goal.
That's just brilliant.
I just love the—
[John]
Ah!
Oh, my ankle.
Oh, ah, oh.
I won't work for weeks.
[Sports Center Ad Speaker 4]
John, get up.
[John]
Oh, my ankle.
[Sports Center Ad Speaker 4]
He's fine.
[John]
Oh, no.
My ankle!
Oh.
[SNB Ad Speaker 1]
Here we go, fellas.
There is nothing like this atmosphere on Sunday
Night Baseball.
[SNB Ad Speaker 2]
Put it all out there, all the chips.
You got to just go for it.
[SNB Ad Speaker 3]
Raise those hands.
Let everybody know you went deep.
[SNB Ad Speaker 4]
Things can change very quickly in this sport.
[SNB Ad Anouncer]
Padres, Dodgers.
Juan Soto ready to power slam Diego on Sunday
Night Baseball.
[Fantasy Football Ad Speaker 1]
You hear what Darth Waver had to do after
losing last week?
[Fantasy Football Ad Speaker 2]
Morning.
[Bill Jelen]
Gabriela is working on Level Two now.
Dim was able to take his result from Level
One and very quickly create the solution.
Gabriela looks like she's doing a little index
out there with the mod function as well.
[Oz du Soleil]
Yep, yep.
Using the MOD and not the stack it up method.
[Bill Jelen]
Perfect.
Okay.
[Oz du Soleil]
Yeah.
[Bill Jelen]
Here we are with Andrew Ngai, the winner of
the biggest FMWC XL esports event last year,
the FMWC Open.
Now he's going back to try and figure out
how that formula is not working.
Or actually, no, he's going on to Level Two.
He doesn't realize that he hasn't gotten Level
One right.
[Oz du Soleil]
Ah.
[Bill Jelen]
Oh, that's going to cause problems down the
road for him.
John:
Yeah.
Yes.
[Bill Jelen]
And it's one in the morning there for Andrew.
[Andrew Ngai]
I think I probably do work reasonably well
at night.
So I think if you made every competitor work
at 3:00 AM, then I would be at an advantage.
And I think if it was 10:00 PM or something,
then I might say, "Oh, yeah, I work better
at night, but definitely not 3:00 AM."
[Bill Jelen]
Oh, Dim is now up to 410 points.
This could be a record.
We're just over four minutes in.
Okay, so in Level Four, he is doing five reels,
one spin.
And this is where you have to do the CountIf
to figure out how many times each item appeared
and you're going to multiply those together.
So if one of these is worth 50 points and
you get two of them, it'll be 50 times 50.
If you would get four of them, 50 raised to
the fourth power, 50 times 50 times 50 times
50.
Dim Early is off to an early start here with
410 points.
Andrew, 178.
Ow, and Dim just scored now 608.
608, so wow.
A lot of Level Four is working.
Wow, this is amazing.
[Oz du Soleil]
It is.
[Bill Jelen]
We're watching Excel brilliance here.
Let's jump over to number eight, Joseph Lau,
who so far is not on the board.
[Oz du Soleil]
Yeah, let's see what's happening.
Might he be one of those that set everything
up and then at the last second tightens it
in and boom, out of nowhere.
Joseph won the very first season of the Financial
World Modeling Cup.
And that was all the way back in 2020.
[Joseph Lau]
I started off in model auditing function.
The first five years of my working career
was really just staring spreadsheets, trying
to understand what people have done, and try
to figure out what goes wrong, what can go
wrong with those models, and then provide
a sign off at the end.
So that was a very good learning experience
to learn about how people model in Excel.
I don't think I knew Excel at all when I started
working, so that's where I learned it all.
[Oz du Soleil]
Ah!
[Bill Jelen]
He's on sheet one.
He's done a lot of pre-work.
[Oz du Soleil]
Yes.
[Bill Jelen]
This could allow him to solve the later items
much faster, right?
[Oz du Soleil]
Yes.
[Bill Jelen]
So a little bit of pre-work ahead of time
wasted six minutes doing pre-work with no
points to show for it yet, but now the points
might come.
Michael Jarman at 420 has successfully solved
everything in Level Two.
Diarmud at 630, he has missed one.
He should have 640 at that in Level Four,
but he's probably working on Level Five at
this point.
And here we are with Gabriela.
[Oz du Soleil]
Gabriela.
[Bill Jelen]
Gabriela currently is at 60 trying to solve
Level Two and there she's also using the mod
function.
[Oz du Soleil]
So how would you think about using a mod versus
stacking the reels up?
[Bill Jelen]
Yeah, I initially thought mod would be the
way to go, but then when I saw a solution
with the reels stacked up, like you say, there's
just some limit.
You wouldn't have to stack more than 10 of
them or something like that.
[Oz du Soleil]
Right.
[Bill Jelen]
So, yeah.
Here we are with Anup, new last season's runner
up.
Anup is from India, working at Thick Matrix
Solutions where they "think matrix," whatever
that means.
[Anup Agarwal]
And one day a friend of mine asked, "What
would be your dream career?"
And I would say, "I love to make spreadsheets.
That would be my dream career."
And we both discussed something like that
cannot happen because spreadsheet is a tool
that you use in your career, so you cannot
just do spreadsheet and that can be a career.
So, yeah, it just so randomly happened that
that conversation turned out to be a future
for me.
[Bill Jelen]
For the folks at home, down in the lower corner
there, the APM, that's the keystrokes-per-minute.
You can see those number around 247, which
is a lot of keyboard action happening.
At the end of Level Three, Anup should have
420.
So that means that a few of his Level Three
must not be correct.
He has an error somewhere in there.
Let's hope that doesn't hurt him as we go
through.
Having one early mistake, it's like missing
an extra point out after a touchdown.
That one point can come back and hurt you
later.
[Oz du Soleil]
All right.
We got David Brown here, associate professor
at the University of Arizona and winner of
what?
The Excel Global Summit Battle.
[David Brown]
Ultimately over those first couple of years
out of school, I learned what I like to do.
I'm very intellectually curious.
I want to work on lots of different projects
and see wherever my interests take me and
academia is perfect for that.
I get to choose what research projects I work
on.
I get to choose kind of how I teach, what
kind of projects I do, like the Excel Modeling
University Open is something that I really
wanted to work on and was passionate about,
and see how I can best add value to the world.
And so I don't think there's another job that
gives nearly that flexibility as being a professor.
[Bill Jelen]
Filling it all here on one sheet.
That's good.
It keeps it in view.
So he's taking his Level Three logic and copying
down to Level Four.
The difference between Level Three and Level
Four, in Level Three you're just figuring
out how to score the five reels, so getting
the concept of multiple items being multiplied
together.
And now actually trying to do one spin down
here, Level Four.
And this is worth 220 points, Level Four.
[Oz du Soleil]
One strategy he used was to do the view, get
a second view window, to see them side-by-side
and not have so much on one sheet.
But everybody has their own strategy.
[Bill Jelen]
Sure.
Right.
Yeah, and it depends on your screen size there.
[Oz du Soleil]
Yes.
[Bill Jelen]
We see that Jeff Tan and Joseph Lau, everyone
has now solved Level One successfully.
So that's great.
Everyone is on the board with the 60 points.
[Oz du Soleil]
Yes.
[Bill Jelen]
Here's Diarmud using the new sequence function.
[Oz du Soleil]
And I also saw the curly brackets for that
control+shift+enter function, right?
[Bill Jelen]
Yeah, using that What-If analysis data table,
that's a common one.
Especially in these later levels, you're trying
to solve it for just one Case, then once you
get that logic to work on the What-If analysis
data table, and it replicates that logic for
all of the other Cases.
[Oz du Soleil]
Yeah.
[Bill Jelen]
Let's take a look at Andrew down there at
598.
And there he's building a data table.
[Oz du Soleil]
Wow.
[Bill Jelen]
All right, so this should very quickly get
a whole series of answers and he'll copy those
and paste them in and see how he did there.
[Oz du Soleil]
As I see.
[Bill Jelen]
Oh, look at that 958 points from Andrew.
[Oz du Soleil]
Whoo!
[Bill Jelen]
All right.
[Oz du Soleil]
Lawd!
[Bill Jelen]
He has solved everything, but he still has
a couple of errors somewhere along the way.
[Oz du Soleil]
Something is off.
[Bill Jelen]
This is going to be so tough to go back and
figure out exactly what has happened.
[Oz du Soleil]
Yeah.
[Bill Jelen]
All right, so Andrew taking the lead over
Diarmud Early, but, again, remember the top
four all advance here.
Michael Jarman at 580 points.
A shout out to Jarmy's Army, Michael's fans
from the FMWC Open Excel Esports event.
[Oz du Soleil]
Deep into Level Five, but some of these answers
from Level Four are not right.
And you can see that in the bottom right hand
corner.
[Bill Jelen]
I love that he took the time to name his worksheet,
doing it probably.
[Oz du Soleil]
Doing it properly.
[Bill Jelen]
That's good.
That's right.
See, he's pasting every fifth reel there,
so he's trying to track these five reels through
multiple spins.
In the last level, we're doing five reel spinning
and we're doing 10 spins.
So that means each of the reels has to start
from at the end of the previous spin and see
where they end up there.
So he's copying his totals across.
[Oz du Soleil]
Oh, oh, Diarmud and Andrew!
1000 points.
1000 points.
[Bill Jelen]
Okay.
[Oz du Soleil]
Yep.
[Bill Jelen]
Yep.
Nice job.
All right.
Fan favorite Diarmud Early with 1000 points.
Andrew with 1000 points.
They've locked in their spot in Case Two.
[Oz du Soleil]
Position in the next round.
[Bill Jelen]
Yeah.
[Oz du Soleil]
Yep.
All right.
Okay
[Bill Jelen]
David is working on Level Five.
Doesn't have all the points from Level Four
yet.
He would be at 640 points, so something has
gone wrong in his Level Four.
And that logic, if he's copying that logic
down, that bodes that that could be a problem.
And you can see his APM there is 62.
He's doing a lot of thinking, not a lot of
keystrokes.
Right behind David, we have both Joseph Lau
and Gabriel.
Let's take a look at Joseph.
[Oz du Soleil]
Yeah, Joseph is now just right outside the
four.
He needs eight points.
[Bill Jelen]
Eight points behind.
[Oz du Soleil]
See.
Okay.
[Bill Jelen]
And there's 12 minutes, 40 seconds left.
[Oz du Soleil]
Mm-hmm.
[Bill Jelen]
All right.
So he is working on Level Four and this is
where you're spinning all five reels.
They all go a different number of slots in
position.
[Oz du Soleil]
Yep.
Oh, transpose function.
Okay.
[Bill Jelen]
Look at that.
[Oz du Soleil]
Ha, ha!
[Bill Jelen]
Actually, it's not a new function, it's been
around forever, but before we had a price
for control+shift+enter, and now we don't.
It's a great way to turn data sideways on
the fly.
[Oz du Soleil]
That's right.
[Bill Jelen]
This is still anyone's game.
Michael Jarman now has 945, so he essentially
has solved Case Five, but still has a few
mistakes somewhere.
Okay.
Okay.
There we go.
Michael solved it.
He's at 1000 points.
[Oz du Soleil]
1000.
All right.
All right.
So there's just one more spot.
[Bill Jelen]
One more spot, right?
And we're down to David with 420, Joseph for
420, Gabriela with 420, Anup 351, and Jeff
Tan at 140.
Now, hey, for those of you watching, there
is a great opportunity here.
[Oz du Soleil]
Yes.
[Bill Jelen]
You can download these Cases for free, but
only during the live streams.
So go to FMWorldCup.com.
Make sure that you do that during the live
stream where you can download those.
If you're watching this later, you can go
buy the Cases with the solutions.
But if you want to try this, it's definitely
worth it to go download them now during the
livestream.
And if you want to participate in an event
like this, sign up for the FMWC Open Excel
Competition coming up at the end of the year.
Again, tickets to enter are at FMWorldCup.com.
[Oz du Soleil]
Joseph has got a rough error to figure out.
[Bill Jelen]
Oh, the rough errors.
I hate rough errors.
[Oz du Soleil]
Wow.
Well, that usually means the formula was working
and then something got deleted.
[Bill Jelen]
Definitely a bad thing that will happen to
you.
And here in the heat of the battle with now
8 minutes and 20 seconds left to go.
And really the first person who solves this
and gets to 1000 points will be advancing.
[Oz du Soleil]
Edge out to…
Oh, David!
[Bill Jelen]
And David Brown's just jumped ahead with 788.
Although I have to tell you, David is in trouble
because he has missed something on the earlier
rounds and doesn't realize that he's missed
it.
So he probably now has put in his answers
for Case Five and realizes that something
earlier has gone wrong.
[Oz du Soleil]
She's moving.
[Bill Jelen]
Oh, my.
If neither Gabriela or Joseph make it to 1000,
David with a 788 would squeak in there.
It's almost like playing defense right now.
Can David find his earlier errors?
And if he can, he has to hope that no one
else can get deep into Level Five here.
All right, so there's Anup who is working
on Level Five, again, with his 560 points.
He's very quickly pacing things in.
This is where we have to model 10 different
turns, so he's copying things from turn five
to turn six, checking his formulas there.
David Brown has now solved a few of his at
924.
[Oz du Soleil]
Yeah.
[Bill Jelen]
And then just changed, now 914.
Oh, that's interesting.
So he can change an answer and see whether
it was correct or not.
[Oz du Soleil]
Yeah.
[Bill Jelen]
So right there, he's picking up 10 points
and losing 10 points as he's checking the
various ones to see where he is at.
So David at 924, hopefully will find his error.
That's a brilliant way to figure out where
the error is, just removing one answer at
a time and then undoing it.
[Oz du Soleil]
Mm-hmm.
[Bill Jelen]
Obviously how your score changes, so great
strategy there for David.
That's a strange number.
That means he's missed 55 points somewhere.
[Oz du Soleil]
Something.
[Bill Jelen]
All right.
Oh, there.
Oh, 1000 points.
There we go.
[Oz du Soleil]
Whoo!
Oh!
Uh-oh, 1000!
[Bill Jelen]
So there we have locked it in.
Joseph and Gabriela who were so close.
[Oz du Soleil]
So close.
[Bill Jelen]
So close to solving, but David Brown scored
and locked in that fourth spot into Case Two.
[Oz du Soleil]
Wow.
Wow.
[Bill Jelen]
What an exciting finish.
Do you need to power up your staff's Excel
skills?
Hire MrExcel for a one hour virtual webinar.
Train your whole team.
Everyone receives a copy of Bill's ebook.
Visit MrExcel.com today for a special ESPN
Ocho price of $888 for a one hour event,
and great deals on many of our Excel and Power
BI books.
If you use Excel 40 hours a week, and those
are the weeks you're on vacation, you will
love this webinar.
[Sports Center Ad Speaker 2]
Right in the front.
[John]
That's like winning the lottery, dude.
Sports Center Ad Speaker 2:
Really.
[John]
I got that spot once.
[Sports Center Ad Speaker 2]
Good morning, Usain.
[Usain Bolt]
Hey, guys.
[John]
Hey.
And the guy was about to go in, right?
So I sort of duck under him.
[Sports Center Ad Speaker 2]
Right.
[John]
Man, he pops out of the car.
His chili is running so hot, right?
I'm like, "Dude, it's a parking spot.
Relax, right?
It's no big deal."
Slow day, huh?
[Usain Bolt]
A little.
[John]
Man, I would kill for that schedule.
[Sports Center Ad Speaker 2]
Me too, man.
I'm telling you, me too.
[ESPN 8 Ad Announcer]
What can possibly happen when the Ocho goes
live?
Just about anything.
ESPN 8: The Ocho, live all day today on ESPN
2.
[Bundesliga Ad Announcer]
The Bundesliga is back.
[Bundesliga Ad Speaker 2]
This is astonishing.
[Bundesliga Ad Announcer]
Dortmund.
[Bundesliga Ad Speaker 2]
Trying to pick something up and he succeeded.
[Bundesliga Ad Announcer]
Leverkusen.
[Bundesliga Ad Speaker 2]
It keeps getting better and better for Leverkusen.
[Bundesliga Ad Announcer]
Tomorrow on ABC and ESPN Plus.
[Spectrum Ad Announcer]
Hey, Orlando business owners, stop overpaying
for internet and phone.
Switch to Spectrum Business.
You'll get faster internet and get Orlando's
best deal for small businesses.
For only $49 99 a month, you'll get 600 megabits
per second of blazing fast internet.
Add business phone for just $19.99 a month,
taxes and fees included.
Call 888-845-4779.
Count on Spectrum Business to deliver faster
speeds at an incredible price with over 99.9%
network reliability.
It's the best choice for your business.
Other providers don't even come close.
Just $49.99 a month for 600 megabit internet.
Add phone for $19.99 a month.
No taxes, no fees, and no contracts.
Switch to Spectrum Business and get Orlando's
best deal for small businesses.
Call today 888-845-4779.
[Oz du Soleil]
Oh.
Oh.
[Bill Jelen]
All right.
[Oz du Soleil]
Yeah.
[Bill Jelen]
Well, there we are.
What just an absolutely exciting round that
was.
[Oz du Soleil]
Thrills!
[Bill Jelen]
Early jumping out there in the first two minutes,
solving Levels One and Level Two.
[Oz du Soleil]
Yep.
And then there was Joseph and Gabriela struggling
to get through Level Five.
And then David Brown and the classic move
of, "Let's see what's wrong with the work
that I've done."
[Bill Jelen]
David, what was your problem?
Was it an error somewhere early on Level Two,
Level Three?
[David Brown]
So on Level Two, I was off by one on a mod
function that I was using.
[Bill Jelen]
Diarmud, we've never seen that many points
that early.
Are you disappointed you didn't get to 1000
points in the first three minutes?
[Diarmuid Early:]
I was pretty happy with how that went.
I was still, even when it's going well, it's
very stressful, but I can't complain.
[Bill Jelen]
Gabriela, I'm curious.
I think you were close there, if you would've
got those 1000 points.
What was the hang up there on the last level?
[Gabriela Strój]
Yeah, just when we finished, I found the one
stupid error—
[Bill Jelen]
Oh.
[Gabriela Strój]
…which would have saved me like three minutes
that I might…
[Oz du Soleil]
Wow.
[Bill Jelen]
Crazy.
Well, that was an exciting round.
[Oz du Soleil]
Yes, it was.
[Bill Jelen]
And so congratulations to our four who are
moving on.
And the other four, thanks for being here.
[Oz du Soleil]
Oh, he's using left.
Now, how about Flash Fill?
Right?
[Bill Jelen]
Oh my God, what are you doing?
This is Oz Du Soleil, who hates all artificial
intelligence.
[Oz du Soleil]
No, for something like this, you can see it,
right?
You can see.
[Bill Jelen]
That's correct.
[Oz du Soleil]
Right.
[Bill Jelen]
You'll know whether or not at it worked.
We're two minutes in and Diarmud hasn't scored
a point yet.
[Oz du Soleil]
Oh, Lord.
Did he fall asleep?
[Bill Jelen]
Look at this.
He's using a Named Range.
[Oz du Soleil]
Named Range!
[Bill Jelen]
Named Range.
Wow.
All right.
He is trying to build a Case that will be
able to solve just about every level at his…
That yellow input section at the top of Column
C.
[Oz du Soleil]
Oh.
[Bill Jelen]
Header Two, Sheet Name top left, bottom right,
bottom left.
Data table start.
[Oz du Soleil]
Oh, okay.
[Bill Jelen]
All right.
[Oz du Soleil]
See if that'll work out.
[Bill Jelen]
He's playing the long game there.
It's like he's trying to be able to solve
any possible level.
And he is copying those answers in.
Oh, there it is.
He gets to 991.
[Oz du Soleil]
Oh!
991!
Oh, oh, oh, oh.
[Bill Jelen]
Zero.
Find that cell.
There it is.
[Oz du Soleil]
Oh, he's maintained!
See?
[Bill Jelen]
There we are.
[Oz du Soleil]
Yep, that was it.
That was it.
[Bill Jelen]
We have our first lock.
Let's see how Michael is doing there.
[Oz du Soleil]
See.
[Bill Jelen]
Now accounting for the different ships would
have different characteristics.
[Oz du Soleil]
Oh, Andrew!
[Bill Jelen]
Andrew now has 1000 point.
[Oz du Soleil]
Andrew, Andrew, Andrew.
[Bill Jelen]
There we are.
Oh my gosh, so close.
With 59 seconds left to go, Andrew manages
to bring it home.
Look at that.
Michael going to 910.
[Oz du Soleil]
Wow.
[Bill Jelen]
And David clearing out his answers for zero
there.
[Oz du Soleil]
Oh.
[Bill Jelen]
Oh, wow.
Look at that.
Diarmud at 1000.
Andrew at 1000.
Michael's so close.
The scores now at the top of the screen to
the left of the countdown clock.
Diarmud on the board first was 60 and moving
on to Level Two.
All right, so Andrew, again, trying to get
to that first Case.
Looks like he's about to paste his answers
in and, again, 60 points.
[Oz du Soleil]
60 points.
[Bill Jelen]
Andrew.
Oh my gosh, Andrew's just got 400.
[Oz du Soleil]
Oh, okay.
Okay.
Okay.
[Bill Jelen]
Wow, he solved it.
[Oz du Soleil]
411 for Andrew.
Look at that.
Look at that.
[Bill Jelen]
Yep, there won't be enough time.
There will not be enough time.
Andrew.
[Oz du Soleil]
Three, two, one.
[Bill Jelen]
Andrew is going to be our winner.
Andrew will beat Diarmud.
[Oz du Soleil]
Oh.
[Bill Jelen]
Time is up.
Winner, Andrew.
All right.
[Oz du Soleil]
Andrew.
[Bill Jelen]
All right.
Andrew, congratulations.
[Oz du Soleil]
All right.
Confetti.
Andrew gets the confetti.
All right.
How you feel?
[Andrew Ngai]
Pretty tired.
[Oz du Soleil]
Oh, tired?
You're supposed to be jubilant.
[Andrew Ngai]
I was surprised to win that last one.
It was really fun, all three rounds.
I really enjoy all these battles and the interesting
problems that we solve on these.
Yeah, great effort to Dim and the other competitors.
They did really well.
Definitely
[Oz du Soleil]
You made it.
[Bill Jelen]
Let's have a chat with our runner up.
[Oz du Soleil]
Diarmud, hey.
[Bill Jelen]
Tough day there.
[Diarmuid Early:]
Yeah, I wasn't keeping an eye on the time.
Which in retrospect was a very poor choice.
[Oz du Soleil]
Oh, okay.
[Bill Jelen]
What a great day you had starting off just
sweeping the first two, giving you 1000 points
first on both of those, and then coming so
close here.
[Diarmuid Early:]
Yeah.
And then I choked when it counted.
[Bill Jelen]
Yeah, right.
[Oz du Soleil]
Um.
[Diarmuid Early:]
Oh, well.
[Bill Jelen]
Right.
If you would've told me 20 years ago that
we would all be watching Excel competitions,
I would've thought you were crazy, right?
But it is actually, it's fascinating to watch—
[Oz du Soleil]
It is.
[Bill Jelen]
…these people who are really good at Excel
come up with different ways to solve problems
[Oz du Soleil]
And to see the things that get built.
The reels, the regatta, this tunnel with the
guy jumping and the aliens.
[Bill Jelen]
Right.
Yeah.
[Oz du Soleil]
All of this is in Excel.
[Bill Jelen]
Wow.
That was great.
[Oz du Soleil]
Cool.
Yes, it was.
[Bill Jelen]
I want to thank everyone for tuning in and
watching our eight household name competitors,
providing edge of your seat competition today
in the Excel world.
[Oz du Soleil]
It was sweet.
It was sweet.
It was spicy.
It was intense.
[Bill Jelen]
Hey, thanks everyone.
Oz.
We'll see you next time.
[Oz du Soleil]
Bill.
