Have a final round interview coming up later this week with one of the big special servicers (think C-III, CW, LNR, Torchlight) for an analyst position. They have an Excel test that they conduct on-site during their final rounds. When I asked about it after my last interview, the analyst said "as long as you're a 3.5 on a scale of 1-5 in Excel, you should be okay with it." This means different things for different people so I'm trying to be safe and make sure all of my bases are covered.
So far I've been going through the BIWS modeling course and looking at how the core concepts apply to RE. I'm kind of expecting them to just want to test whether or not you know some of the specific functions (like Vlookup, sensitivity tables, etc), so I'm trying to get familiar with those too. Anyone have any more ideas on what to look for?
To begin preparing for an excel test interview, JobTestPrep has everything you need to know for Excel Testing Interviews, including a myriad of questions with thoroughly explained answers.
I heard their excel tests are extremely intense. You should know basic macros, VBA, and how to structure standard return waterfalls. Also, make sure you brush up on dilution analysis and how to create LBO models from scratch. Other than that, you should be good!
^This
PS. A 1-5 scale is for wussys.
know how to model an amort table from scratch
Ut autem ex voluptas necessitatibus. Maxime nihil error deserunt a.
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...