I have a last round interview coming up where I've already talked to most of the senior people in the two main offices they have for the asset management department. All I have is an excel test and it's the last step and I don't want to fuck it up. I thought this was the most basic step and usually the first but they leave the test for last and if I fail now I'm not sure I'll get this dream job. Does that mean they don't care if I pass the test or not because of training or is it because of some other reason?
Trending Content - Real Estate Forum
Career Resources
Sounds to me that they are thinking of giving you an offer and want to make sure you are not monkey on excel.
Probably true. I think I'm prepared but this is my first job out of undergradute so probably too trusting on there end.
We give an excel test more so for critical thinking skills. We allow the interviewee to google how to do things in excel. I would just make sure you can do some excel look ups like v/h lookup, sumifs, conditional formatting , sumproduct, maybe some of the finance functions excel has built in. Luckily for you google has infinite amount of resources for this.
Apply the technicals you got in other interviews on excel, AM is broad - if its portfolio construction, then know how to do variance, stdev, expected returns, different rations ie sharpe, covariance matrix etc
Yes, taking an excel test as part of the interview process for an entry level position is totally normal
lol at all these boomers missing OP's concern
Et qui magnam dicta expedita. Soluta deserunt consequuntur ut quia eum nesciunt. Quo autem voluptas delectus aliquid sint nisi eius aut.
Perferendis illo vitae non distinctio officiis velit rerum. Neque voluptatem praesentium dolorem maxime.
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...