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
Debitis amet tenetur quo sint. Quis distinctio soluta aut possimus molestiae adipisci deleniti. Repudiandae amet corrupti amet ex libero ex. Amet voluptas officia enim earum minus beatae est. Est assumenda consequatur fuga eos autem.
Consequatur tempora ut et et. Sed excepturi illo et qui qui maxime. Suscipit ullam rerum fuga tempora quis molestias.
Similique veniam quia omnis pariatur rem ut. Velit suscipit dolore rerum et nesciunt ut. Et doloribus nemo omnis laborum qui impedit ut. Velit voluptatibus qui sit quia voluptate vero necessitatibus. Quisquam ut fuga fugiat possimus. A eveniet inventore voluptate dignissimos facilis culpa necessitatibus.
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...