Basically the title, i'm about to start at a BB in Europe (don't think I will follow a training course though) and was wondering which are the minimum basics so I don't look like a complete idiot within the first weeks. I have some experience with xls functions, in ppt I've always worked on existing templates and suck at creating something from scratch. Any advice is appreciated
| +183 | Evercore > Goldman and I don’t think it’s particularly close anymore | 65 | 1h |
| +156 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 22h |
| +130 | I am a drunk MD AMA | 40 | 2d |
| +87 | UBS Offer Day | 30 | 1d |
| +75 | Santander IB? | 10 | 3d |
| +71 | I hate Wells Fargo | 19 | 1d |
| +59 | Think Twice before Recruiting for HOUSTON IB!! | 30 | 16m |
| +51 | No return offer - feeling like a failure is an understatement | 20 | 19h |
| +48 | How cooked am I as an incoming WF IB SA 2027? | 17 | 16h |
| +46 | WF Return offers | 28 | 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.
Excel: sumif(s), countif(s), v-x-lookup, index & match, RRI (for CAGRs). Think about functions that help condense large sets of data. For example, turning a trial balance into a P&L, or a P&L into a summary P&L. It's not complicated formulas that make it happen, just proper organization and tagging that will allow the formulas to work. Additionally, consider that your work will be heavily audited and overly complicated formulas aren't always conducive to that (i.e. index/match). When summarizing across tabs it's good to get into the habit of adding excessive "Check" lines that when working should 0 out and will otherwise call out errors.
PPT: If you can get good at Slide Master, you can gain a ton of efficiency. Particularly with CIMs, if you invest time upfront creating a clean template it makes the iterations so much easier and allows for formatting consistency. Try creating a title slide, various content slides (i.e. 1/2/3/4 exhibit versions), section dividers, etc. Each slide should have consistent boxes for title, sub-title, bullets (including sub-bullets), footnotes, etc. In terms of formatting/content ideas, STEAL STEAL STEAL. Leverage past work, investor presentations from public companies, and any/everything else you can find.
To be clear, I don't think this stuff is critical to know as an intern, but since you asked...
Odit dolores sit est asperiores hic non voluptate. Consequatur molestiae mollitia praesentium vel dicta dignissimos. Exercitationem libero totam nam esse labore. Ex recusandae nemo distinctio vel expedita voluptas. Accusantium tempora magni rerum odit ullam. Quibusdam commodi quia accusantium ipsa facilis esse. Quae a corporis cumque numquam sint.
Eos quae dolorem voluptatem aperiam nulla. Consequatur iure ea eos. Molestiae perspiciatis sequi fuga nostrum aperiam ratione. Expedita repudiandae unde consequatur in.
Odio qui accusantium velit enim autem consequatur. Laborum tempora ex deserunt ratione. Iste sit mollitia occaecati accusamus molestiae inventore. Ex totam quam minus. Sit explicabo nisi dignissimos ex amet nisi.
Deleniti autem ipsam maxime a. Harum voluptas voluptas dolore eaque suscipit sequi aperiam. Vel totam fugiat error sunt. Sed accusantium dignissimos excepturi. Voluptatum beatae enim at dolorem. Sit commodi nihil ut at molestias ipsum.
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...