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.

 

Voluptatibus ut molestiae magnam sed incidunt voluptatem deleniti. Iure provident est aliquam neque explicabo. Voluptatem sit molestiae repellat enim natus.

Career Advancement Opportunities

September 2026 Investment Banking

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

Overall Employee Satisfaction

September 2026 Investment Banking

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

Professional Growth Opportunities

September 2026 Investment Banking

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

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (56) $261
  • 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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
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...”