90 min excel test - what to expect

[CoCoaButter85]

Hello,
I am applying for a role in finance and they require me to do a 90min excel test.

Tbh, that seems excessive. But it is a good role. I don't have issues with my Excel skills at work and the position is similar to what I do now.

Has anyone done it and what to expect from it?

I'm going through various YouTube videos on excel tests but not sure if that's sufficient in terms of preparation

It could be absolutely anything it could be specific to the requirements of the role or it could be basics to gauge your existing skill level.

If your skills are fine I wouldn't worry about it

@DreamW3aver - thanks for getting back. I looked through the job spec and it does says Excel skills but doesn't mention anything that would require more complicated functionality I'm not familiar with.

I just think 1.5hr tests is way too excessive. I suppose will find out tomorrow exactly what it's all about

Have ChatGPT generate you some sample exercises and then mark them to prepare.

It will likely something like a question/problem statement to answer through cleansing and formatting the data, then analysing the data by creating pivot tables, vlookups, some formulas like COUNT, SUM, average and IF statements then probably ask you to provide a summary at the end to test if you can interpret the data and communicate the insights. If you have reasonable excel skills I would say you should be fine and focus on addressing the question and checking that there are nothing that might trip you up, eg money in a mix of M and MM.

They'll have given 90 minutes, doesn't mean. You have to spend 90 minutes on it

Hi @CoCoaButter85
Hopefully you see this as several months have passed. Did you discover what was on the test? I take my 90 min excel assessment next week. Some pointers would save me.