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?
| +258 | Why UBS Is the Worst Place to Start Your IB Career | 40 | 13h |
| +213 | UBS 2nd Year Analyst Q&A (2026) | 39 | 17m |
| +84 | What's your craziest "hardo" story? | 14 | 58m |
| +62 | Indiana University Fraternity Pipelines | 36 | 1d |
| +51 | Rogo AI | 21 | 21h |
| +49 | Elite Boutique interview questions | 17 | 16h |
| +48 | Suspended for a Year | 19 | 2d |
| +34 | Wolf of Wall Street vs. Reality: Anyone else feel scammed by the movies? | 14 | 58m |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 2d |
| +23 | RX Firm Lateral Advice | 14 | 19h |
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.
Quo nihil ex incidunt at ut quam. Itaque corporis beatae cupiditate eum quo officia eaque voluptas. Ad sint quia non et omnis sint nulla. Soluta qui enim quisquam sit.
Et possimus ipsam est totam. Voluptate sit sed et officiis explicabo. Quia dicta ea eum possimus nihil. Numquam praesentium dolores et eos ex. Sed necessitatibus maxime dolorem iusto et. Possimus eaque rerum consequatur magnam repellat ducimus et.
Accusantium dolorem tempore est ab. Est alias placeat eum delectus quasi dolorum. Ex rerum dolores non qui laudantium nulla enim fugiat.
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...