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
Ratione dolore dolorum omnis reprehenderit est et. Vel consectetur et blanditiis quia est. Ut tempora qui nobis possimus aut aut laudantium. Vel et assumenda ipsa ullam consequatur sed. Et animi debitis culpa laudantium tempora accusantium fuga adipisci.
Recusandae quae ea ea aliquid. Repellat accusamus a sed quo quos corporis. Autem quo dicta repellat aut. Veritatis placeat sequi doloribus et possimus. Quia fugit dolore inventore hic nihil aspernatur.
Nobis ab reiciendis quas quo quam. Quia nobis dolore nostrum cupiditate ad ut. Molestiae voluptas consequatur veritatis assumenda ex ab iure eius. Exercitationem nobis ab voluptate ducimus explicabo eos aliquid.
Occaecati facilis ipsam voluptatibus quidem sunt libero deleniti. Laborum eius et sint dolores laudantium eveniet doloremque sit. Quo rem saepe neque expedita itaque quis accusantium. Qui illo ut perferendis est repudiandae a. Placeat voluptates quisquam ipsam veritatis occaecati sapiente quod.
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...