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?
| +433 | Is UBS really that bad? | 77 | 8h |
| +265 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 14h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +74 | Useless associates | 14 | 4h |
| +66 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 18 | 1h |
| +60 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 10 | 1h |
| +52 | Differences in Restructuring Teams? | 24 | 10h |
| +44 | FIG Pigeonholes you - is it true? | 15 | 2m |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 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.
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.
Autem eius vero qui dignissimos excepturi velit corrupti. Est maiores maiores deserunt qui.
Itaque tempora deserunt voluptate debitis quia id id repellendus. Et consequatur dolorem exercitationem temporibus nostrum.
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...