14 Comments
 

i dont get it. why are knowing these shortcuts related to finance or PE. i guess they can help make some things faster but why do people connect excel with finance if youre just looking at stocks on a screen all day?

 
Best Response
ricochetXi dont get it. why are knowing these shortcuts related to finance or PE. i guess they can help make some things faster but why do people connect excel with finance if youre just looking at stocks on a screen all day?

Take it away, LSO (from 2006)

"I watched in horror as Josh busted out some dirty old hideously colored model to build off of, and nearly passed out when I saw him start navigating.

Get this…HE WAS USING THE MOUSE!! …“WTF?!” I nearly shat myself with incredulity. I was so embarrassed that he was my colleague and I was his that I almost went and told one of the partners about the act of blasphemy I had just seen and that I would quit if some action wasn’t taken. But I restrained myself. I had to calm down. I turned back to my computer, loaded up ESPN.com, took several deep breaths and let myself get hypnotized by the ever-flashy Flash advertisements. After a moment, I knew what I had to do.

I turned and tapped Josh on the shoulder to get his attention. I didn’t say a word, but my face said “Yo…yeah you, McKposer.” We locked eyes. I slowly and dramatically reached for my mouse cable. Staring him down, I methodically unplugged it from my computer’s USB port. The cable came out slowly but smoothly and with it’s final, climactic release, I heard Josh gulp with fear.

I continued to glare at him as I started to “fly around.” My eyeballs burned through his unweathered, 60-hour-a-week-when-he-should-have-done-90 face as I hid and unhid sheets and conditionally formatted and applied validation to cells with triple nested conditional and indirect functions and then culminated by on-the-fly writing a macro that took my data and made it into a Marimekko (and we don’t even use that shit!). I never turned to look at the screen, and my eyes never left his.

“Welcome to PE, bitch,” I growled.

 

you used excel to come up with models. if you know the shortcuts, it will save you at least 80% of the time. In IB and PE as an analyst, u do a LOT modeling and thus knowing the shortcuts is essential.

 

Ut facilis sunt eum impedit. Est unde ipsum et. Exercitationem est nobis sunt et. Molestias eum aut odio aliquid consequuntur. Assumenda minus enim est aut. Maxime ea et sed distinctio commodi ad incidunt. Et eaque vero nisi sed qui vitae id.

Career Advancement Opportunities

October 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

October 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

October 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

October 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

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
CompBanker's picture
CompBanker
98.9
6
DrApeman's picture
DrApeman
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
98.8
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...”