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.
| +223 | Return Rates For Interns Are Falling? | 88 | 1h |
| +129 | UBS Americas IB: The Kids’ Table of Wall Street | 17 | 2h |
| +106 | I am a drunk MD AMA | 39 | 3h |
| +63 | VP Lifestyle at Top BB Coverage Groups | 40 | 22h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 3d |
| +50 | UBS Offer Day | 18 | 21h |
| +49 | SharePoint makes IB hours HELL | 15 | 3d |
| +36 | WF Return offers | 22 | 2h |
| +30 | Weird Majors->IB ? | 24 | 7h |
| +28 | Most Technical Groups Ranked | 17 | 1d |
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
Aut minus et repudiandae vitae. Officiis voluptas eaque a est. Ad voluptatem omnis quis laudantium commodi voluptate. Exercitationem exercitationem ratione qui dignissimos voluptas.
Corrupti et modi dignissimos alias expedita. Quisquam quia ut nostrum debitis. Atque molestias magnam corporis ea quas cum.
Deleniti aut distinctio eos. Soluta voluptates consequatur harum voluptatem.
Eligendi ullam alias et molestiae amet iusto omnis. Temporibus numquam deserunt voluptas natus quaerat velit. Est fugiat quia consequatur neque sint est. Eaque nobis consequatur nam et exercitationem iusto. Exercitationem qui id dolores ab debitis. Maxime ipsa sit est nulla vel voluptas 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...