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?
Index(match) vlookup Hlookup nest if, thens
in general know how to organize data efficiently so it may be synthesized.
I can't imagine it'd be too difficult.
How big is the REIT?
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.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...