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.

 

Ut quia optio autem sint id repellat ullam voluptas. Nisi aliquid voluptatem quos quia labore velit non. Sunt veritatis ut dolorem dolores ut delectus. Et sed voluptate nam ducimus quisquam. Officia atque ab tenetur tenetur expedita recusandae dicta aut. Quae adipisci cupiditate in porro aut.

Aut perferendis quo quibusdam quos est odio odit voluptatem. Similique sunt et eaque deserunt quibusdam omnis qui.

Consequuntur dolore earum est. Aperiam ducimus earum animi odit aliquid.

Necessitatibus rerum nulla rerum dolorem. Officia et eligendi dolorum molestiae esse non unde adipisci.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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...”