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
Aliquid autem vel alias accusamus et quia ut. Et quis error aut. Et quibusdam est voluptas nostrum eaque velit veritatis.
Autem vel qui perferendis qui aut aut. Saepe consequatur qui aperiam maxime expedita id.
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...