How I won the 2023 Microsoft Excel World Championships

Подписаться 819

Просмотров 13 тыс.

50% 1

This is a re-enactment of my performance in the MEWC 2023 Final last month.
I solve it (roughly) the same way as I did on the day and talk through what I was thinking during each stage of the case.
If you'd like to see a polished solution to the full case, check out Diarmuid Early's video: • Eve online Excel chall...
For more info on Excel eSports or to register for the 2024 season, visit fmworldcup.com/
00:00 Intro
01:31 Rules and Case Overview
03:36 Level 1
05:05 Level 2
06:28 Level 3 (Attempt 1)
10:50 Bonus 1
12:28 Level 3 (Attempt 2)
19:13 Level 4
26:41 Level 5? / Bonus 2
30:00 Bonus 3
33:54 Bonus 4
35:42 Level 5?
38:57 Conclusion

Опубликовано:

28 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@quoit99training83 5 месяцев назад

Can you video with most of formulas and keyboard shortcuts you use? I would be happy if I can learn even half of your techniques 😊

@ExcelWithElliott 3 месяца назад

"Then I started looking at the scoreboard and hoping it would stay the same" I felt this to my core, glad it's the same right at the top! Thanks for sharing, great to see

@Patrick_from_Youtube 5 месяцев назад

Amazing, thanks for showing this and congrats on the win

@Ago468 5 месяцев назад

Congrats with the win and thank you for the video, enjoyed it!

@xXPhixiusXx 5 месяцев назад

First 🥇 of many hopefully! It will benefit us all to have a glimpse into the mind of another Excel genius!

@kanewilliams1653 4 месяца назад

Wonderful, thank you!

@LeviBailey 5 месяцев назад

Nice one Andrew. Congrats on the win and good luck with the RU-vid career!

@XFaramir 4 месяца назад

Really good ! Quick thinking

@shanabenjamin8945 Месяц назад

Brilliant job!❤

@sledgehammer-productions 5 месяцев назад

Exciting, looking forward to watching it. It would have been interesting to see the live event - FMWC could, next time, have streams on all the finalist individually. Just a thought. Happy to learn from the best!

@DimEarly 5 месяцев назад

8:31 This might be why I will never beat you! (One of the reasons anyway 😂) Sometimes I’m too purist for my own good… there weren’t even that many of them, but I don’t think it would have even occurred to me to just do them by hand! 15:28 I should do that more often! I hope you can be persuaded to make more of these : )

@andrew_ngai 5 месяцев назад

Haha well you don't need to do it by hand if you have your colour macro 😂

@DimEarly 5 месяцев назад

@@andrew_ngai That was the one good investment I made in my finals prep... it didn't save me though! 😂

@Tim_Heng 5 месяцев назад

On this point, I always go back to Andrew's approach to the Excelopolis problem in the 2021 FMWC Open, where everybody else tried to solve it using fancy formulae and even VBA, and Andrew just solved every line of each question manually... and topped the scoreboard! Sometimes the manual approach is the best 😂

@DimEarly 5 месяцев назад

@@Tim_Heng I know exactly what you mean - it was the Share the Ride case, which was theoretically doable with circular references, but very tricky to get right. I think that round might not play out the same way today though… using circular references was a very unusual idea at the time, but it’s come up a few times since. Maybe one or two people would crack the general solution in the time today??

@Tim_Heng 5 месяцев назад

@@DimEarly Yes you're right, it was Share the Ride. Your memory is better than mine! I think that with recursion better understood and easier to implement with lambdas now, it might be a conceptually easier task to follow as well. I'll be honest and say that I still don't think the circular general solution is terribly intuitive, but that's why I sit on the commentator side and leave the competing to you good folks! :D

@omori3007 4 месяца назад

thanks for the video!

@Reduce_Scan 5 месяцев назад

Excellent. I hope you continue to solve these problems and teach us how to think to reach solutions Thank you very much And more success

@CaribouDataScience 5 месяцев назад

Thanks

@AIR_TANAH 2 месяца назад

Congratullation 🎉🎉🎉🎉

@RemyMS 3 месяца назад

Insane!

@jldocherty 5 месяцев назад

Good video thanks. Keen to see if you can make one similar about Excel Road to Vegas battle 1 (and onward). Thanks

@beiraodoaloucura9295 Месяц назад

Great athlete

@doctorofkickboxing 5 месяцев назад

This video helped me realise Microsoft Excel is an insane ESport!

@calvinchen8739 Месяц назад

Hey Andrew, big fan. I aspire to be just as good as you one day.

@benlim0707 3 месяца назад

what sorcery is a data table @19:04 & @26:00 was trying out this excel today.

@andrew_ngai 3 месяца назад

can find it in Data > What-If Analysis > Data Table, sorry i'm clicking stuff underneath the banner i placed on the video

@user-wq2zb3zg9k 5 месяцев назад

How important is the kind of computer you are using? what keyboard is best ? I am a beginner. Could we get a Computer Setup video in future? Thanks

@andrew_ngai 5 месяцев назад

I don't think the type of computer is that important, Excel doesn't use a lot of resources (at least for the cases in the competitions), you probably just want any keyboard and mouse that you find comfortable and a decent size monitor

@Felix-ef8mg 2 месяца назад

How do you create that symbol in front of the dates at 10:04?

@andrew_ngai 2 месяца назад

I didn't create that, it was a special type of data object that came with the question

@pyl-3136 3 месяца назад

What is this magical move at 19:04 ? I don't even understand how it can automaticaly go to pick the good prices at the good date knowing all the initial calculations are being done with the prices of 3 jul 23...

@andrew_ngai 3 месяца назад

oh that's a data table, sorry i'm clicking the Ribbon but it's hidden behind the banner which I added to the video to keep track of the question/scores Data > What-If Analysis > Data Table, then set column input cell to the cell which you want to vary (in this case A1)

@pyl-3136 3 месяца назад

@@andrew_ngai Thank you so much ! :)

@AdhySulistyo 5 месяцев назад

Auto subscribe suhu anda banyak di cari HRD perusahaan Indonesia

@khansaif5698 2 месяца назад

May I know your Educational background? I am thinking if After matric I wil spend my time learning Ms excel then is it important to have strong educational background for Ms excel jobs? Or only the skill is important?

@andrew_ngai 2 месяца назад

I'm an actuary. I suppose it depends on what job specifically but in general I'd say both are important