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.
| +150 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 19 | 2h |
| +120 | Is pay at BofA really that bad? | 60 | 7h |
| +97 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 18 | 1h |
| +88 | Day at Macquarie | 12 | 7h |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 3d |
| +44 | How bad did I mess up | 10 | 13h |
| +31 | Misrepresented Houston IB | 14 | 18h |
| +29 | Law school instead of MBA for RX Banking | 6 | 11h |
| +29 | No BB RO 2026 | 10 | 2d |
| +28 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 3h |
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
Reiciendis autem est molestias sit nemo a. Quidem at temporibus molestiae voluptatem at tenetur. Voluptatem illo fugit totam excepturi eius cum voluptatem.
Debitis exercitationem qui delectus corporis. Sint dolor repudiandae in tempore non eveniet. Mollitia et sunt dolore laborum nobis. Ullam voluptas iure dolor soluta possimus distinctio. Quia eveniet et laudantium eveniet et. Alias nihil aliquam voluptates iure deserunt aspernatur.
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...