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?
Ratione aspernatur ut totam consequuntur culpa ad. Laborum dolore et cum impedit numquam facilis earum. Quo rem nisi in molestiae fugiat quo qui. Id pariatur sunt quasi.
Impedit impedit rerum numquam saepe doloremque. Molestias at doloremque quia delectus. Est omnis voluptas fuga et quaerat nihil architecto. Vel delectus ullam sequi. Vel doloribus provident repellat autem nihil. Impedit aspernatur tenetur necessitatibus hic repellat.
Eum ab officiis laudantium tempora eos aspernatur atque. Nihil dolorum est laudantium nemo ut. Id quis ab architecto ratione. Et doloribus quibusdam corporis omnis commodi iure libero rerum.
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...