"Basic Excel Test" at HFF/Eastdil

Guys,

Could use some help. I recently interviewed for an analyst position at a debt placement team in NYC at an HFF/Eastdil type shop. I had two rounds of interviews where most of the questions were personality/fit based (very few technical q's), but I have now been asked to come in for a "basic excel test".

What would you expect this to be? Amort tables/building out a proforma? Or something less modeling related such as seeing if I know how to do things like countIF/sumIF statements?

Any insight would be greatly appreciated.

11 Comments
 

depends on the shop. I had an obscure 3rd party excel test i took about a year ago for a similar brokerage and it was nothing related to modeling and asked random excel questions like "under data tab, what does x mean" and then it gave definitions of the term. so from several excel tests i have taken pre/post interviews, I would say it depends.

 

Facilis quo occaecati voluptate et a necessitatibus. Ex blanditiis itaque illo asperiores velit sunt voluptas. Eum quidem vel molestiae et nisi rerum pariatur.

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%
  • Goldman Sachs 02 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 (79) $150
  • 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
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
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...”