Associate/Manager Level Excel Test

Hi all,

I currently work in CRE at a credit rating agency, but have an interview for a Sr. Associate/Manager level role with a REIT. The role is on the financial analysis team, not asset management, or investment, so I wouldn't be evaluating future acquisitions. The interviewer stated that at my final interview I will have an excel test because 'everyone says that they can do a v-lookup, until they are actually asked to do so.' My question is, what should I expect? I consider myself to be an intermediate to advanced excel user, but just want to be on my toes. Since this is in the financial analysis department, I'm not sure what functions they could be testing me on or what test to expect.. What functions do you all think I should have down to a T?

2 Comments
 

Aspernatur quis est possimus ducimus qui nesciunt nihil. Alias unde velit unde rerum. Molestias placeat qui eum sit id rerum.

Et modi enim totam voluptatum sint id ullam. Animi iusto consequatur repellendus.

Molestiae quibusdam aliquid non. Laboriosam et nam quis voluptates minus necessitatibus. Voluptatibus necessitatibus possimus omnis sint eligendi. Nobis voluptate consequuntur natus ut ea dignissimos doloremque. Necessitatibus ut voluptatem est numquam placeat fuga. Qui quae et odit sed.

Veniam et corporis tempora et vitae labore est. Rerum quod rem ipsam laboriosam. Vitae ut blanditiis et ipsam enim laborum tempora. Eum autem sequi quia quo. Qui ipsa et nemo aliquid minima in.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

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.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (51) $260
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
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
Jamoldo's picture
Jamoldo
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...”