6 Comments
 
Most Helpful
  1. Weird goal, go get laid
  1. You can take all the courses you want, but really the best way to learn shortcuts is to just build something alongside someone who shows you all the shortcuts as they move around. Then you take notes and make it habit to only use those shortcuts to rebuild what they did. Then as some become habit, you’ll find other things you do often, and will look up shortcuts for those too. You will repeat taking note and then eventually - you will become so proficient you’ll start adding shortcuts of your shortcuts via QAT or Macros.
  1. It’s best to save this for on the job, because that’s really the only context where you use excel for purpose and it’s the quickest way to learn because it’s how you make your job easier. You should be familiar with excel and basic commands: how to change row/column sizes, go in and out of print view and removing grid lines, changing font colors to the major ones (red,blue,black red etc.) quickly and changing number format quickly (from decimals to percents to dollars etc.). If you are able to do all of these things without a mouse on day one - you will be significantly ahead of your peer group coming full time training.
 

Yeah that could help if you want to practice basic short cuts. I’d caution against getting too entrenched because it’s harder to unlearn bad excel habits then being a sponge when you get there. In terms of the most relevant things to start with, I would literally just build P&Ls. You could full three statement operating models if you want to be a superstar, but if I were you I’d just build P&Ls. Every single firm has a DCF template / sensitivity table template so honestly I’d avoid building those so you don’t learn bad habits. You don’t need to build DCFs to understand their functionality.

 

Necessitatibus omnis sit illo nihil. Ducimus iusto adipisci et veritatis. Similique eos deleniti asperiores eaque commodi odit. Provident ullam ea quasi voluptatem aut.

Quas quo consequuntur et facilis ea. Officia debitis voluptatem est non corporis eos possimus. Molestiae enim nihil laboriosam.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”