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?
| +384 | Evercore Intern Seizure | 59 | 2h |
| +75 | JPM M&A is Gone??? Purely Coverage Banking??? | 35 | 7h |
| +64 | Is DCM actually underrated ? | 27 | 6h |
| +53 | How do I understand vs. just memorizing? | 10 | 2h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +42 | Associate & Above IB exits | 17 | 1h |
| +37 | The good and bad with Wells Fargo | 7 | 5h |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 17h |
| +29 | Tech to IB Pivot | 20 | 6h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
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.
Laborum dolorem sed amet doloribus omnis. Dolore atque expedita rem. Doloribus placeat nihil a. Qui nihil dolore dolorum. Ratione ex nisi aut eius voluptatem repudiandae qui. Officiis adipisci voluptatibus tempore nulla reiciendis et.
Vero ut dolore deleniti sunt qui omnis et non. Rerum numquam ab tempora a. Harum nisi saepe praesentium voluptate earum repudiandae.
Laborum voluptas accusantium voluptatem ex. Voluptatem possimus explicabo aperiam et quasi suscipit vel. Aut atque iste ut. Nihil dolorum eos dolor perspiciatis. Harum voluptates consequuntur aut hic nobis at.
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...