My excel skills are very weak. What's the best way to pick up and learn the skills before my FT role in Sept 2023. I try to watch YT but I tend to forget without any practice. Are there any class you are recommended to build up skills in the IB M&A fields?
| +295 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 38 | 2m | |
| +151 | Investment Banking US League Table YTD 2024 (FactSet) | 84 | 11h | |
| +144 | Big Layoff at Barclays - 5/1/24 | 83 | 2s | |
| +87 | “Americans just work harder” | 53 | 1d | |
| +83 | Would comitting to ATL İB be stupid? Please give feedback. | 45 | 3d | |
| +69 | Sleeping on Jefferies??? | 33 | 2h | |
| +66 | A shitter's comprehensive guide to sophomore year recruiting | 7 | 22h | |
| +59 | NEED NY RESTAURANT RECOMMENDATIONS | 38 | 3d | |
| +59 | What's up with RBC nowadays? | 24 | 22h | |
| +50 | 5-Step (Borderline Psycho) Pre-Superday Routine I Used to Land Every IB Internship Offer | 4 | 2d |
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.
WSP excel and ppt courses are pretty cheap and good. Found that they were pretty structured so helped with muscle memory
I’ve found Marquee Group to be helpful.
It really depends on the level of proficiency you wish to attain. From my experience, the best way to learn is by doing. Many of the course listed above are helpful insofar as they teach you the necessary skills for IB (e.g., best formatting practices, commonly used financial formulas etc). Fair warning… some of my suggestions may come across as overkill, but I’m a relatively lazy person who likes to spend time upfront and sit back and relax after. I suggest you pick up a random project. It could be anything (e.g., build a simple model, spread comps etc.) and think about how you can optimize it. Back in the day, my mentality centered around building things to last. Think about when, how often and who will be updating the spreadsheet. Can you make it dynamic? Can it be easily understood? Play around with a few formulas, stress test them and see what can be improved. Admittedly, this thought process could be applied to anything (continuous curiosity + practice = mastery)
Get a template with all the excel shortcuts, print it off, and start doing things on excel without touching the mouse. At first, it will take you time as you will have to go back to the page every minute, but in the long run is 100% worth it.
People tend to focus on learning shortcuts for excel, but being efficient on PPT is also essential . I will also recommend you to learn how to navigate through windows (file explorer, outlook…) just using the keyboard
Honestly? Just learn how Excel works. What things do, how they connect. Don't stress about not using a mouse before starting.
Honestly, once you know your way around Excel it's so easy to speed up. Do each shortcut 2/3 times and you'll have it memorised. You pick that up when starting.
The Excel shortcuts link shared here is super helpful!
Looks like you're in need of some serious Excel-lence.
Jokes aside, get Wiley's Financial Modeling and Valuation book. It covers practical excel applications
Facilis aperiam quis iusto ab minus temporibus dolores. Eius eos facere dignissimos laudantium ea. Dolores aut neque nostrum. Molestiae voluptates in ut id ipsum. Assumenda quo ut nam expedita sint omnis commodi. In non qui qui quos pariatur recusandae rerum.
Culpa et sint ea commodi. Aut dolorum omnis dolor aut at. Ut perferendis alias quasi. Asperiores ea cum culpa voluptas maxime.
Sit deleniti dolores est aut beatae deserunt laudantium. Maiores omnis ad laudantium consequatur labore cupiditate vitae. Dolores molestiae voluptatum quod repellat. Repudiandae soluta qui quis quaerat. Vel dolores iure est doloremque tempora.
Sed voluptatem est odit voluptas. Vero fugit odio vitae quibusdam doloremque recusandae quae. Sed inventore optio quod tempora atque.
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...