one hour long excel test at interview

[chaosmonkey]

Any hints and tips on what to revise? I use excel all the time, but mainly for basic spreadsheet stuff. Have checked vlookup and pivot tables, but pivot tables are so easy on excel 2013 - what if they ask me do to it on an older version where it's more actual coding type stuff? Tis for a finance type job...

Interview is on Monday...

TIA

Check you're comfortable with IF, AND, OR formulas. And sumif, counta etc.
I think there'll probably be some formatting and sorting/filtering too in which case the subtotal formulas might be handy.

If you use excel a lot I'm sure the test will be a doddle

Thank you! Will spend at least some of today making sure I can do that!

Am not so sure about it being a doddle, because I basically use Excel as a calculator, not a clever spreadsheet!

I think a quick call to the HR department to check the version of excel they use would be acceptable. that way you can focus on the task not the software.

Good luck!

Very good point fields - I have done so and now know that I will be using 2013 - phew!

Right. Just a quick panic about hair/shoes/do i fit into my interview suit and a quick read around the subject and reread of my application form, and I'm sorted!

Thanks all