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.
| +119 | Give your 21y/o self advice: | 38 | 50m | |
| +73 | Anyone else think Oppenheimer is overrated? | 26 | 13h | |
| +60 | Cocktails to order at bars? | 39 | 7h | |
| +59 | Isaiah Is Prestigious | 8 | 1d | |
| +47 | Thoughts on UFOs | 23 | 2d | |
| +41 | Stay with College GF? | 20 | 11h | |
| +40 | Which is more prestigious? WSO Light mode or WSO Dark mode? | 8 | 2d | |
| +29 | Favorite Corporate Jargon | 12 | 2h | |
| +19 | Imagine accidentally being unmuted on a call | 2 | 1d | |
| +18 | Do I have a chance for SA 2027?? | 3 | 4h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Comments (132)
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 :-)
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
what was your time chief?
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
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.
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.
alt est bro
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.
^^ 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.
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?
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.
Impressive time
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.
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
Had fun with this!
Whassup Jr Mining?
http://www.youtube.com/embed/muUpAUekDzM
Damn, nice time man.
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...
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
tshirts have been sent, congrats guys!
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Here's my take. Well, since I can't post links it's on youtube with movie id: niMIIVQc7xY ;)
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 .
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
Bahaha
http://screencast-o-matic.com/watch/cI1ZVJVx84
around 20 or so seconds
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:):
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.
Where can I download the Excel file for this challenge? Just curious how I stack up in time
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..
kind of defeats the purpose, right?
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
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
Lag really threw me off, was doing it in about ~1:20, but heck there don't seem to be many competitors and I'd dig a free shirt.
Can't post links, but here is the youtube code HAhLYBEIcdM
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.
damn im slow compared to you guys lol
//www.youtube.com/embed/1oJ1Zll8mRs
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)
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?
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
My attempt. Could've easily shaved 10 seconds off from the hesitation, but the fast mess from the previous attempt proved otherwise. Can't embed, here you go (unlisted): watch?v=C7sxcX94Tec
Just a quick question: Could we win the competition twice in two months and receive two t-shirts?
no one shirt per participant :-)
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Here is mine:
A bit slow but under 2 minutes.
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.
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
CompBanker’s Career Guidance Services: https://www.rossettiadvisors.com/
Little delay in the computer:
//www.youtube.com/embed/cSf3pMw7fXw
Hey I can't post the link of my excel challenge :(((
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.
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
i want to post my video but WSO won't let me
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.
heello
^^^^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
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
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?
you can do it on google sheets yes,
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Deleted. see below
I am gonna 1 up you sir.
WSO Excel Challenge Revenge from AJOE on Vimeo.
How did you past G and H into A and B like that??
not sure what you mean
WSO Challenge from AJOE on Vimeo.
just sent a link to your shirt!
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
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
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
Here is my attempt:
youtube . com/ watch?v=tTGQ5iO9eXU&feature=youtu.be
thanks for posting, will write you on pm
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
thanks for posting, will write you on pm
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Here's my attempt:
Dotcom/watch/coX1cyhlOW" rel="nofollow">http://screencast-o-maticDotcom/watch/coX1cyhlOW
Just replace the 'Dot' with '.' I'm not able to post a link.
thanks for posting !
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
test
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
39 seconds!
WSO Excel Challenge - JL3vy 2015.11.30 from Jaqueline Levy on Vimeo.
Missed the dollar signs at the end, won't let me edit the above. /watch?v=e4jMHJJTAUc
23 seconds, no shortcuts.
37 seconds /watch?v=MbChnTSCSKo
Posted to YouTube.
Well, I did this using mouse (touchpad actually) in 39s... see if I can do it faster without mouse.
ALT + H + FP
In case ALT + H + FP is considered cheating (even though it's not copy/paste), here is using individual short cuts
dws29, DM_Swoosh, FFM, OptimusPrimeofExcel, jl3vy
Thanks for posting your scores, our assistant Ivy will pm you with a link to a free t-shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
39 seconds till final keystroke
great, our assistant Ivy will email you about a free WSO t-shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
2 minutes 7 seconds
thanks for posting!
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Hey I'd like to post a link to my video, but I'm not able to :(
can you try posting the link again?
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
39 seconds! Here's the link: https://www.dropbox.com/s/109ntbembpo35rc/WSO%20Excel%20Recording.mp4?d…
thanks for posting, our assistant will pm you about your free t-shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Boom 32 sec. thank you gentlemen!
thanks for posting! we'll get you a shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
well done, our assistant ivy will pm you about sending you a shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
in 35 seconds!
great! thanks for posting. we'll get you a shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
about 36 seconds I think
pretty good, thanks for posting, ill get you a shirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Just under 38 seconds. Using a mac too so I had to make my own shortcut for "paste formatting".
not bad, i'll pm you about a tshirt :-)
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Just under 17sec :D
Did it under 5 seconds... Won't let me post a link because I'm a new user
well done, we'll pm you link for the tshirt
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Great time via ThePiker (5 seconds)
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Here is my link. Under 13 sec.
Ctrl+shift+arrows to select alt+h+fp to copy format ctrl home to paste it into a1:d8 alt+h+o+i to auto-fit
It won't let me post a link because I am a new member but I PM'ed you!
thanks!
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
Done in 3 seconds.
(Ending is a bit fast to ensure video cuts out immediately after it's completed)
[
](https://youtu.be/2qij7-Ahe1E)
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!
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-%20Exc…
thanks for posting, will pm you
WSO Content & Social Media. Follow us: Linkedin, IG, Facebook, Twitter.
About 36 seconds
[
)
I can't upload my video to the thread since I don't have enough points. I just sent an email with the link
https://screencast-o-matic.com/watch/cYeXcDxrqA
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
DELETED
I got right around 1:08. Beginner monkey here... YouTube link:(
)Is this challenge still going?
https://youtu.be/8k-gIOlpdNU
JUST under 40 seconds: https://1drv.ms/v/s!Aj0XsMlsmL-qsC_KLyabzkrxIfzf?e=YQxIMM
Vel velit quo quos eveniet quis. Blanditiis provident quas autem assumenda. Voluptatem cupiditate repudiandae dignissimos doloremque voluptatem et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Quo consequatur harum omnis eveniet est. Ducimus aut enim temporibus dolor laborum exercitationem. In voluptatum quisquam qui autem earum. Fugit est excepturi modi nisi.
Delectus eos est expedita ab. Deserunt iure voluptatem iusto inventore qui repellat. Quas adipisci voluptas est ipsam laborum. Reiciendis sed voluptas debitis sit excepturi rerum cum. Tenetur voluptate magni error enim corrupti rem quidem.
Commodi in eos dolore sint quia. Vitae dicta molestiae deserunt quis.
Error quia nobis provident harum officia id quis. Ut eligendi molestias enim dignissimos occaecati. Nam quia veniam facilis enim. Beatae possimus sit pariatur quae sunt vel.
Nihil et occaecati consequuntur fuga cupiditate autem facilis. Nesciunt reiciendis cumque enim voluptatem sed nam occaecati. Eligendi at quibusdam ipsa enim et. Iusto rerum rerum quidem aliquid molestiae quo. Sunt et enim aut nulla sed nihil sit.
Aliquid molestiae impedit alias. Sint a omnis officiis vitae. Eligendi maxime ad et explicabo. Qui voluptatem dignissimos autem sed ut quia voluptatum. Aliquam et sed quod dolorum eius. Consequuntur consectetur nemo exercitationem nam. Et inventore aliquid et explicabo doloremque.
Ipsam necessitatibus minus aliquam quis. Quo et illum earum. Corrupti molestiae dolorem autem praesentium. Ipsa esse alias dolore ea. Ut voluptas quis aspernatur.
Est nam laborum est id non. Quos hic quia vitae ut quae. Accusantium eius doloremque odio fuga ab.
Tenetur aut magni et labore. Sequi accusamus eum cum illum consequatur ex. Maxime et ipsum atque non aut commodi voluptate. Esse sapiente aut quaerat.
Quae voluptatem modi ipsum aut deleniti necessitatibus ut. Praesentium cupiditate quis velit unde accusamus culpa veritatis similique. Mollitia molestiae aut velit vel nihil. A illum suscipit ullam voluptatem quia et.
WSO Elite Modeling Package | PE Interview Course | IB Interview Course | All WSO Courses
Sit delectus consectetur placeat voluptatem. Sunt error impedit voluptatibus est. Corrupti maxime expedita sunt commodi ipsa distinctio.
Quo fugit perferendis quam quod vero perferendis veniam. Tenetur excepturi atque atque et.
Labore assumenda placeat sunt aliquid possimus voluptatum saepe. Voluptatem qui quia omnis non non. Voluptate natus fugit autem atque cum sunt aut. Autem necessitatibus recusandae praesentium consequuntur nemo.
Vel cum rem mollitia qui ratione optio. Vero eum at aut omnis vero dolorem reprehenderit enim. Dolorum accusantium fuga ut delectus sunt consequatur.
Debitis aperiam fugiat impedit quaerat. Nihil exercitationem eum rerum. Officiis dicta necessitatibus molestias ex.