Excel test for Internship at a Credit Rating Agency

crunch276's picture
Rank: Chimp | banana points 10

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

Find Your Mentor

  • Increase your chance of landing a job by matching with one of our 200+ mentors.
  • Our mentors are top employees at the most selective firms.
  • Proven process with over 1,100 clients over 10 years.

Comments (1)

Jan 1, 2019