I’m in my final year of college with a full-time BB investment banking offer. I’m trying to maximize this window ahead of my start date in July and hit the desk running.
Could you share any YT Channels/Books/Courses you felt helped shaped your excel competency from a collegiate level to the AN1 level? Thanks.
| +409 | Change My Mind: Banks Shouldn’t Hire Foreigners at All | 111 | 15m |
| +176 | Article - UBS’ Investment Bank Keeps Losing Ground | 34 | 9h |
| +95 | Don’t work at UBS - UBS Sucks | 11 | 44m |
| +77 | An Exhaustive Guide: How to Solve Every Single Accretion/Dilution Question | 7 | 2h |
| +51 | When to Leave Office as Intern | 5 | 2d |
| +43 | Best IB Group Overall? | 25 | 1d |
| +34 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 2d |
| +31 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 22 | 1d |
| +31 | STEM student lost in London IB recruiting | 17 | 19h |
| +20 | Still recruiting SA'27 | 13 | 18h |
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.
Oh, you're in for a treat! Based on the most helpful WSO content, there are a few ways you can boost your Excel skills before you start your job.
Firstly, many people find that learning on the job or teaching themselves is the most effective way to become proficient in Excel. You can start by downloading raw data from your bank or financial institution and coming up with data points that you want to track or analyze. This will help you build your raw Excel skills in a practical way.
Secondly, there are a lot of good (free) online resources like Mr. Excel that you can use to learn more about Excel.
Lastly, the WSO Courses have been highly recommended by users. The Excel Modeling Course, in particular, has been praised for being applicable to day-to-day work and for boosting efficiency. The course covers 95% of what you would do with Excel during an internship, and the keyboard shortcuts can be a real game-changer. The timed tests sprinkled in between really help cement the concepts you learn and allow you to apply them immediately.
Remember, practice makes perfect! So, the more you use Excel, the better you'll get at it. Good luck, and I hope this helps!
Sources: Q&A: 2nd Year REPE Associate, WSO Courses, How to master excel?
Typing tests and repetition. Memorizing commonly used excel shortcuts too
Typing tests wasn’t something I would have considered, thank you for the input.
Make a QAT (sometimes you can add already made ones from TTS or one of them sites iirc). Practice basic modelling or just using excel and ppt when you can to do some exercises and set a goal, like learning 5-10 shortcuts a week, which is basically 1/2 a day at college.
Thanks for the input.
Take a modeling course
Build a bunch of models and make an aim to use your mouse as little as possible.
Make random projects like a study plan or something and make it as intricate as possible with as many features and... Don't use a mouse.
No amount of memorization of formulas beats muscle memory.
Practice Practice Practice Practice Practice Practice Practice Practice
Wall Street prep excel course is a good starting point
Use Excel more. Practice
Dolor iste sed sit voluptatibus. Beatae quis officiis aliquam harum. Numquam culpa fugit deserunt eum quaerat corporis ducimus. Vero voluptatem excepturi perspiciatis est. Non qui aliquam excepturi dolor.
Quam labore eligendi repellendus quasi deserunt et. Id sit corrupti ipsam id sequi ullam. Cum omnis ipsum iusto.
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...