WSO Excel Challenge Contest

Please embed the videos of you completing our WSO Excel Challenge to win a WSO T-shirt. Every month, we will be taking the fastest time and sending out a free t-shirt.

All new members now get access to our 6 free financial modeling lessons, so you can click the sign up button in the menu above. If you are already a member and would like these lessons you can sign up in the form below.

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (131)

Apr 24, 2013 - 7:39pm
WallStreetOasis.com, what's your opinion? Comment below:
jr_mining:
http://www.youtube.com/watch?v=NMAYRcfP8uE&feature=youtu.be

http://www.youtube.com/embed/NMAYRcfP8uE

holy crap, impressive time. I can't believe that was the first posting, lol...now everyone else will be scared to post :-) it's early though so I wouldn't be surprised if someone tries to post before April is up to claim the free WSO T-shirt :-)

May 2, 2013 - 12:31pm
AndyLouis, what's your opinion? Comment below:
WallStreetOasis.com:
jr_mining:

http://www.youtube.com/watch?v=NMAYRcfP8uE&feature=youtu.be

http://www.youtube.com/embed/NMAYRcfP8uE

holy crap, impressive time. I can't believe that was the first posting, lol...now everyone else will be scared to post :-) it's early though so I wouldn't be surprised if someone tries to post before April is up to claim the free WSO T-shirt :-)

what was your time chief?

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

  • 2
Feb 27, 2015 - 8:18am
Sean W, what's your opinion? Comment below:

Without a word of a lie, I can do this in less than 5 seconds! It's called the 'format' key (look for it in the top left of the home ribbon). You're wasting your time if you do this any other way. Add to which, you can set up defaults such as rounding to zero decimal places. When you highlight a set of numbers and click the 'comma' key in excel, it will, by default, adjust the formatting to how you've set it up.

Feb 27, 2015 - 12:21pm
AnonymousJoe, what's your opinion? Comment below:

Without a lie, I believe you. It's not really about copying format though, it's about navigating only using the keyboard to create a table that looks like the other one. It only takes 5 seconds to understand the main point of this challenge.

Never let success go into your head and failure go into your heart.
  • 1
Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
May 17, 2021 - 11:27pm
lakshayjain, what's your opinion? Comment below:

True. I was also confused at the start about why are they giving 2 minutes to copy the format when we can do it in less than 5 secs using Paste Special? Now I got it. It is just for beginners who don't know about it. So the ones who have already worked with excel will do it quite easily.

Apr 24, 2013 - 5:45pm
jr_mining, what's your opinion? Comment below:
kmzz:
^^ ctrl-shift-4 and alt-h-9 are your friends

Regarding alt+h+9, you have to format the number/currency to have brackets around negative numbers, thus I had to use the CTRL+1 menu to format the number and changed the decimals while in there instead.

I used CTRL+SHIFT+4 in the video.

Apr 27, 2013 - 11:30pm
magid, what's your opinion? Comment below:

Total rookie here, so I imagine this has an easy answer, but when I do ALT+H+9, nothing happens. In fact, I need to do ALT+H+H just to highlight (ALT+H just takes me to the Home ribbon), and then I navigate to the color by the arrow keys. I'm using Excel 2010, same as you.

What am I doing wrong here?

Apr 28, 2013 - 12:08am
D M, what's your opinion? Comment below:

I don't know if this is your issue, but sometimes computer companies like Dell, HP, etc fuck with keyboard shortcuts. Might affect Excel, but honestly I have no clue.

"You stop being an asshole when it sucks to be you." -IlliniProgrammer "Your grammar made me wish I'd been aborted." -happypantsmcgee
  • 1
Apr 28, 2013 - 12:20pm
BlackHat, what's your opinion? Comment below:

Maybe I'm missing something but I'd just paste special formats the entire thing on the right and win via loophole?

I hate victims who respect their executioners
Apr 28, 2013 - 1:36pm
WallStreetOasis.com, what's your opinion? Comment below:
BlackHat:

Maybe I'm missing something but I'd just paste special formats the entire thing on the right and win via loophole?

that is cheating :-) you need to use the keyboard shortcuts to do each step. usually you won't have an exact replica of what you are trying to make on the same spreadsheet, so that kind of defeats the purpose.

May 1, 2013 - 10:36am
WallStreetOasis.com, what's your opinion? Comment below:
grainflow:

I don't have much Excel experience but am starting to prepare for my new IB job with the WSO Modeling Lessons. I like this exercise.

I'm proud of myself, I just broke a minute... and May is a new month.

Under a minute is very solid...once you're under a minute I think it's probably best to practice other keyboard shortcuts that are frequently used in some of the models and templates we'll be sending you. And yes, it's a new month :-)

We'll be sending a free t shirt to both members in April since they were the first ones to get us started and both had super impressive times...

May 24, 2013 - 6:02pm
macocha, what's your opinion? Comment below:

Here's my take. Well, since I can't post links it's on youtube with movie id: niMIIVQc7xY ;)

Jun 6, 2013 - 1:24pm
GlenHarryGlenBoss, what's your opinion? Comment below:

I'm trying to paste my link from my upload to Screen o matic, but it says I may not post links due to recent membership. Consequently, I cannot embed it, but here is the link: http://screencast-o-matic DOT com/watch/cI11b0Vv5O

Just replace the DOT and the space on both sides of it with an actual .

Jun 6, 2013 - 1:37pm
heister, what's your opinion? Comment below:

alt + f4 will really speed up your times guys.

Follow the shit your fellow monkeys say @shitWSOsays

Life is hard, it's even harder when you're stupid - John Wayne

  • 1
Jun 6, 2013 - 2:01pm
D M, what's your opinion? Comment below:
heister:

alt + f4 will really speed up your times guys.

Bahaha

"You stop being an asshole when it sucks to be you." -IlliniProgrammer "Your grammar made me wish I'd been aborted." -happypantsmcgee
Jul 16, 2013 - 4:57pm
saulius.cuz, what's your opinion? Comment below:

Well, only thing I can say that Excel 2013 is a worthless peace of LAG :) 1x1 cm ctrl key on my laptop keyboard also doesn't help, but here's what I got, though only on a second try (1 big reason mentioned previously:): http://youtu.be/QvivQZY1fAk

Jul 19, 2013 - 9:56am
Flake, what's your opinion? Comment below:

I feel like whoever wins this also loses in so, so many ways. With that said I am undoubtedly the quickest. Just not in excel.

Under my tutelage, you will grow from boys to men. From men into gladiators. And from gladiators into SWANSONS.
  • 1
  • 1
Aug 20, 2013 - 8:25am
jane.l, what's your opinion? Comment below:

Wouldn't it be faster if you just copy formatted cells, pasted format, and then autofit columns? Well.. that would take 10 seconds, negating the difficult aspect of this challenge..

Nov 14, 2013 - 6:58pm
Zampano, what's your opinion? Comment below:

not if the purpose, as explained in the email I received this challenge in, was to complete tasks in excel as quickly as possible so that you could get work done faster .... this really shouldn't take more than 10 seconds

Dec 31, 2013 - 6:53pm
Corregidor, what's your opinion? Comment below:

I guess since I'm a newbie I can't embed video or add links, but here's the code for mine: NHAS6833E9Y. 51 seconds is insane. This one's about 1:10, but I can't see shaving twenty seconds off that.

Jan 18, 2014 - 3:26pm
cloww, what's your opinion? Comment below:

attempted to do this on a mac, got stuck on the first step… apparently mac has no shortcut key for auto formatting the column (someone correct me if I'm wrong)

Oct 29, 2014 - 7:06am
Aldo, what's your opinion? Comment below:

I just started the challenge and I'm having the exact same problem with auto-fitting the columns. Did you end up figuring it out in the end?

Best Response
Jan 27, 2014 - 2:47pm
Clementan, what's your opinion? Comment below:

Oh, and Virginia, my t-shirt size is a medium, and my right arm is just a little longer than my left.

//www.youtube.com/embed/DVP7TWR7RWA

Mar 31, 2014 - 9:50pm
DCgirl, what's your opinion? Comment below:

Here is mine: http://youtu.be/Uqn-_AHjn-U A bit slow but under 2 minutes.

Apr 23, 2014 - 7:01am
Cplusplus, what's your opinion? Comment below:

Here is my attempt: watch?v=EGRvHPnxFh4

Sorry I can't embed it because I am a new user here. But I completed the challenge in 27 seconds.

May 26, 2014 - 11:50pm
CompBanker, what's your opinion? Comment below:

I couldn't find the original excel so I recreated it. Here is what I managed to come up with:

//www.youtube.com/embed/wqWEkS1ZT1g

Mentorship with CompBanker: https://www.RossettiAdvisors.com

  • 1
Oct 3, 2014 - 11:45am
AndyLouis, what's your opinion? Comment below:

i got you points so you can post your video (or a link to it), let me know when it's up

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

Aug 27, 2014 - 4:57pm
brandyn, what's your opinion? Comment below:

hey, can someone give me a point? WSO isn't letting me embed my video until i get a point...I did the challenge in ~23 seconds

Oct 3, 2014 - 11:44am
AndyLouis, what's your opinion? Comment below:

i got you points so you can post your video (or a link to it), let me know when it's up

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

Oct 29, 2014 - 7:15am
Aldo, what's your opinion? Comment below:

^^^^Or did anyone have the same problem as i did that can help. Using Excel for mac 2011. Is there a way to change all the shortcuts to match the instructions? Thanks in advance

Oct 31, 2014 - 1:47pm
eltiburon, what's your opinion? Comment below:

See my submission below. The number and currency formats do not look the exact same as demanded since I use a German system, but the commands performed are exactly the same. Looking forward to a t-shirt. :-)

Youtube: waj4SPRZJ2A

Nov 28, 2014 - 3:36am
ry_z, what's your opinion? Comment below:

Hello, I got a macbook but I don't have the mac excel because it costs a lot to me. How can I do the test? Can I do it in google doc? Any help?

Feb 24, 2015 - 8:09pm
AnonymousJoe, what's your opinion? Comment below:

Deleted. see below

Never let success go into your head and failure go into your heart.
Feb 27, 2015 - 12:17pm
AnonymousJoe, what's your opinion? Comment below:

not sure what you mean

Never let success go into your head and failure go into your heart.
Jul 24, 2015 - 8:41pm
WallStreetOasis.com, what's your opinion? Comment below:

It always shocks me when people use the solution to complete the exercise, when the entire point of the exercise is to practice quick keys in excel.

In real life, the solution won't be sitting there for you guys to copy off of using painter...smh :-)

A+ for @Pascal-Su"
F for @mohit.S" ;-)

AndyLouis

Nov 5, 2015 - 7:36pm
MonkBidnezz, what's your opinion? Comment below:

Here's my attempt:

http://screencast-o-maticDotcom/watch/coX1cyhlOW

Just replace the 'Dot' with '.' I'm not able to post a link.

Jan 24, 2016 - 4:29pm
OptimusPrimeofExcel, what's your opinion? Comment below:

http://youtu.be/iiXAsJD0o34?hd=1

Going all in on Finance.
  • 1
Jan 24, 2016 - 6:11pm
OptimusPrimeofExcel, what's your opinion? Comment below:

Missed the dollar signs at the end, won't let me edit the above. /watch?v=e4jMHJJTAUc

Going all in on Finance.
  • 1
Mar 18, 2016 - 6:14pm
FFM, what's your opinion? Comment below:

23 seconds, no shortcuts.

https://youtu.be/tF2XDuqWj_Q

.
  • 1
Jul 26, 2016 - 3:18am
Bayoumonkey, what's your opinion? Comment below:

39 seconds till final keystroke https://youtu.be/DFeRXvY-OGA

“The only thing I know is that I know nothing, and i am no quite sure that i know that.” Socrates
  • 1
Aug 4, 2016 - 1:10pm
AndyLouis, what's your opinion? Comment below:

great, our assistant Ivy will email you about a free WSO t-shirt

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

Dec 5, 2016 - 1:34pm
AndyLouis, what's your opinion? Comment below:

thanks for posting, our assistant will pm you about your free t-shirt

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

Apr 1, 2017 - 1:28pm
AndyLouis, what's your opinion? Comment below:

well done, our assistant ivy will pm you about sending you a shirt

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

Oct 23, 2017 - 6:46pm
lc21, what's your opinion? Comment below:

https://youtu.be/LXa7BYfUX8Y Just under 38 seconds. Using a mac too so I had to make my own shortcut for "paste formatting".

May 23, 2018 - 1:08am
amy-lin98, what's your opinion? Comment below:

It won't let me post a link because I am a new member but I PM'ed you!

May 28, 2018 - 7:59pm
AndyLouis, what's your opinion? Comment below:

thanks! https://www.youtube.com/watch?v=j3prhYOSDNQ&feature=youtu.be

WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.

Jul 18, 2018 - 7:32am
PipEvangelist, what's your opinion? Comment below:

Did it in about 40 seconds.

Quick question:

Does anyone know how to change the default currency symbol to USD $ instead of the British Pound?

Thanks!

Aug 27, 2018 - 8:55am
mibs, what's your opinion? Comment below:

Won't let me post the link but did it in just under 30 seconds

https://www.dropbox.com/s/cooykjfv1tfmpiw/WSO-Excel-Challenge%20-%20Excel%202018-08-25%2010_25_50%20AM.mp4?dl=0

Nov 30, 2019 - 9:54pm
onebel, what's your opinion? Comment below:
Hi, I'm usually scared to post discussions because I've seen how people talk in trading chat rooms. Please be nice. I know the finance industry is tough and emotions shouldn't get in the way, but mental health is more important. :(
  • 1
Jul 6, 2020 - 4:39pm
Lucas Tajra, what's your opinion? Comment below:

https://youtu.be/l3VnEX8F-lw

Jun 3, 2021 - 10:54pm
jatin_rao, what's your opinion? Comment below:

My new personal best! Under 30 seconds :) I am not sure why it doesn't show the formatting menus while I am formatting but that is why there are some pauses, but that's what I'm doing. Microsoft Screen Recording ain't it obviously...

file:///C:/Users/jatin/Videos/Captures/WSO-Excel-Challenge%20-%20Excel%202021-06-03%2029%20secods!.mp4

Oct 14, 2021 - 5:02pm
_reek_, what's your opinion? Comment below:

Quisquam quis quia suscipit. Placeat neque dicta quas illum saepe earum at ab. Deserunt nihil omnis vitae excepturi vitae rem consequatur maiores. Soluta recusandae aut magni aut eum.

Eveniet deserunt quaerat natus qui omnis natus. Consequatur architecto inventore provident iste dolorem voluptatem voluptate qui. Reiciendis vitae perferendis qui. Aut aliquam nisi sint.

Apr 17, 2022 - 3:22am
sadiqlawal, what's your opinion? Comment below:

Ut provident totam rerum quis alias quod quos. Hic voluptatibus neque nam aut iure. Et quis rerum aliquid. Aut nihil placeat cum magni consequatur voluptatem nihil. Nulla enim ut ut amet et ducimus. Distinctio modi ipsum labore vel repellendus natus.

Et numquam tempore rem voluptatibus expedita. Pariatur magnam nobis error voluptas qui ipsum et. Culpa perspiciatis id et quisquam. Dolor nostrum quae quos saepe voluptatibus excepturi minus.

Maxime et soluta et voluptate animi quidem. Dolorem amet blanditiis similique doloremque minima praesentium quia. Et culpa voluptatem dolorum laboriosam. Quae qui voluptatem debitis et aliquid et. Ea et repellat qui quis et aut. Et qui qui id voluptatibus dicta nemo ab dolorum.

Est magnam ut optio dolore doloremque commodi ut. Facere illum voluptas officiis illum.

May 29, 2022 - 6:20am
xavier_1, what's your opinion? Comment below:

Eaque possimus consequatur debitis et ut minus voluptate. Hic facilis sunt non a.

Laborum dolorem magnam dolorum et natus. Placeat voluptatem illum quia delectus sit. Quia numquam consequuntur tenetur tenetur inventore rem. Consequuntur esse consequatur et necessitatibus.

Unde aut quos aut enim. Libero suscipit molestias dolorum incidunt voluptatibus eius voluptatem qui. Rerum qui recusandae debitis ut voluptate exercitationem voluptatem.

Jun 2, 2022 - 1:00am
WallStreetOasis.com, what's your opinion? Comment below:

Et modi repellendus dolorem suscipit quo doloribus quia. Consequatur consequuntur incidunt earum minus voluptas iste atque. Quia adipisci voluptas possimus aut sed. Dolor sed dolorem blanditiis. Commodi natus ut sed veritatis nesciunt itaque. Eum quia sunt eaque qui. Iste facere et amet aut.

Ea temporibus et explicabo est. Blanditiis aut id consequatur quo possimus non. Quis nihil similique hic deleniti. Ut alias maxime dolore qui dolorem culpa.

Jun 2, 2022 - 1:45am
xavier_1, what's your opinion? Comment below:

Qui dolores reprehenderit sint. Vel dolorem at fuga qui. Fuga fugit nemo quo unde praesentium in expedita vero.

Iste est sapiente provident labore voluptate doloremque. Neque praesentium mollitia tenetur earum optio. Laboriosam reiciendis quas porro ut recusandae iste blanditiis temporibus. Recusandae quae sunt est ut ex.

Repellat explicabo eveniet quisquam est deleniti aliquam. Delectus autem tempore quibusdam.

Start Discussion

Career Advancement Opportunities

July 2022 Investment Banking

  • Jefferies & Company (▲03) 99.6%
  • Lincoln International (= =) 99.2%
  • RBC Capital Markets (▲07) 98.8%
  • Bank of America Merrill Lynch (▲01) 98.4%
  • Houlihan Lokey (▲06) 98.0%

Overall Employee Satisfaction

July 2022 Investment Banking

  • Lincoln International (▲06) 99.6%
  • Jefferies & Company (▲11) 99.2%
  • Greenhill (▲07) 98.8%
  • Rothschild (▲01) 98.4%
  • Evercore (▽01) 98.0%

Professional Growth Opportunities

July 2022 Investment Banking

  • Jefferies & Company (▲04) 99.6%
  • Lincoln International (▲04) 99.2%
  • RBC Capital Markets (▲09) 98.8%
  • Houlihan Lokey (▲07) 98.4%
  • Bank of America Merrill Lynch (▲04) 98.0%

Total Avg Compensation

July 2022 Investment Banking

  • Director/MD (9) $661
  • Vice President (37) $394
  • Associates (191) $246
  • 2nd Year Analyst (117) $162
  • 3rd+ Year Analyst (17) $156
  • 1st Year Analyst (369) $150
  • Intern/Summer Associate (78) $147
  • Intern/Summer Analyst (292) $92