Excel Test content

97jro's picture
Rank: Senior Chimp | banana points 18

I have an upcoming interview for an internship at a large Bank in their real estate investing division and I was just told there would be an excel test. I think I'm okay but not amazing with excel. For anyone who has taken one before are there any functions I should make sure I have down pat or anything I should know how to do that usually doesn't come up very often using excel? Thanks.

Private Equity Interview Course

  • 2,447 questions across 203 private equity funds. Crowdsourced from over 500,000 mem.
  • 9 Detailed LBO Modeling Tests and 15+ hours of video solutions.
  • Trusted by over 1,000 aspiring private equity professionals just like you.

Comments (3)

Best Response
Feb 22, 2018

Be familiar with nested if statements and building a waterfall

    • 2
Mar 5, 2018
Re.Monkey:

Be familiar with nested if statements and building a waterfall

Shortcuts and logic statements instead of if statements too to speed things up a bit.

Feb 22, 2018