rising sophomore at an ivy, never had any excel training and want to have strong skills before applying to ib for summer 27 cycle nyc. whats the best way to do this? not looking to take any paid courses, just independent practice. will also be reading rosenbaum and pearl this summer to accompany it once i have some training. any recommendations?
| +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.
Start with a blank page and focus on formatting without a mouse and as always ALT W V G - no gridlines
On the side build out your formatting tables so, number, percentage, and color formatting
Ctrl + 1 for type formatting and google along the way if you don't get it. yyyy for 12/31/2025 -> 2025 and then Center across selected cells and Underline under Accounting to make your dates pretty.
Press alt and press the respective buttons to see how things work and if you don't know a shortcut google it. You'll a ton of time more on alt H.
Once you've finished your side formatting and kind of memorized the motions. Just build out your three statement model for any stock of your choosing focusing on reusing prior formatting along the way. So like ALT E S T or whatever other variant you use.
You can only make your skills better if you're remaking the same stuff over and over. Then move on to whatever else you want to do, push the 3 statement model into a stock valuation. Practice a LBO from the hundreds of free case studies there are on the internet.
I don't know the culture of your ivy, but surely you have access to past student pitches to see their formatting and if you don't like it fix it.
Deleniti sunt omnis fugiat repudiandae. Ea ipsam sunt quo ea corrupti quis. Ipsa unde ipsum aut numquam vel iusto eum deleniti. Molestiae dolores doloribus repellendus id cumque ut soluta. Eum beatae occaecati asperiores quia quia deleniti aperiam. Pariatur reiciendis a quia.
Modi natus et doloribus dolorem consequatur ea beatae. Amet tempora ea voluptate quo tempore. Accusamus sed consequatur officia nulla et dolorem tempore unde.
Dolorem repellat suscipit qui ullam. Facilis sequi provident dolorum sit ut a. Magnam explicabo perferendis maxime perspiciatis enim vel et. Rerum earum odit molestiae. Ut minima assumenda omnis perspiciatis.
Voluptatem ut sed dicta fugit autem. Suscipit nisi architecto quia. Ratione natus ipsa cum illum aut officia hic.
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...