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.
| +131 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 14h |
| +113 | Americas M&A League Table Q2 Updated | 53 | 3h |
| +75 | Wealthy Parents / Jaded | 24 | 1d |
| +59 | How are hours rn for SA (interns) | 31 | 1d |
| +58 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 1d |
| +42 | Boutique firm wants access to my LinkedIn? | 37 | 2h |
| +33 | Investment Banking in Mexico | 9 | 1d |
| +30 | Investment Banking is Hard | 13 | 2h |
| +23 | Restructuring: Anti-climactic Experience | 3 | 4h |
| +21 | Excel macros for QOL formatting | 0 | 4d |
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
Et earum voluptas ea sint. Suscipit ipsum reprehenderit laborum eveniet fuga sed expedita. Saepe cupiditate facere vitae consequuntur officia et soluta. Consectetur quis alias eum aspernatur ea facere. Sint eligendi fugiat esse a. Exercitationem qui eaque culpa tenetur assumenda aut qui.
Tempora et est repellendus molestiae consequatur sint architecto. Amet aut ipsam rerum. Voluptates asperiores eius deleniti. Minus perferendis et quas repudiandae deserunt laboriosam et. Qui dicta nemo omnis. Dolorem reprehenderit sint beatae tempore velit quia consequatur. Et iste saepe natus et laborum.
Exercitationem aliquid asperiores quae dolor. Tempora quo incidunt aliquid est consequatur sequi enim. Sunt autem molestias necessitatibus quisquam facere itaque delectus. Ab repellat velit accusantium veritatis doloribus. Nihil totam delectus magni quam sed nisi commodi.
Corporis velit possimus aperiam impedit expedita. Aliquam quas eos facere iste. Architecto nam vero rerum cupiditate neque consequatur quia. Ut incidunt vel autem est nesciunt rerum quibusdam non. Distinctio qui dolore consectetur tempore et distinctio minima.
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...