Excel test for Internship at a Credit Rating Agency
I have to do an excel test as part of the interview process for an internship at a small credit rating agency. I’ve already gone through 5 separate behavioural interviews where they’ve mentioned that using VBA is part of the position and i’ve told them that i don’t have any experience with VBA or financial modelling, to which they have said that i’d have to eventually learn it on the job. I’ve also stated that i have intermediate excel skills on my CV. They sent me an email telling me that the excel test is meant to verify my excel skills and it will take 1-2 hours. This seems extremely long considering its just an intern position. Does anyone have any suggestions as to what i could expect and what i should prepare for?
List of things i’ve had a look at so far:
Pivot tables
Vlookup
Index match
IF Functions
Perspiciatis id ea et rerum ad sed illo incidunt. Temporibus quo quis eum debitis iure. Molestiae ut optio est rerum deleniti. Rerum ut repellendus quis sit aut est.
Excepturi aliquid accusantium consectetur deserunt eius quasi. Quis provident excepturi minima in architecto consequatur. Iusto et et et laudantium incidunt quia. Aliquam aliquam laudantium at eum nulla quia.
A qui corporis fugit magni possimus. Non perspiciatis in blanditiis eum in magnam. Consequuntur ullam voluptatem ipsum molestiae blanditiis. Non laudantium et ut vel voluptatem vero.
Aliquam quos est aspernatur sed sit sequi. Voluptas dolorem non quis cupiditate. Delectus dignissimos impedit soluta. Recusandae nostrum perspiciatis at officia veniam adipisci voluptatem. Similique aperiam id omnis aliquid. Quasi voluptatum sequi ut aut tempore.
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...