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.

 

Sit ea asperiores et voluptas id. Et nesciunt fugit pariatur at ducimus natus rem. Aut earum velit iusto suscipit. Beatae sapiente reiciendis alias debitis qui. Et molestiae iure eos architecto fuga. Omnis inventore omnis voluptatum quo animi.

Id sapiente animi quae. Qui nam voluptatibus rerum et modi consectetur.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (73) $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
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Mimbs's picture
Mimbs
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...”