Updated: Apr 29, 2020
Excel interview test is awaiting and you are looking for online sample questions and answers as well as practice tests to improve your skills.
Whether you are going to be interviewed for data analyst, financial analyst, accountant or any other role, expecting online, paper or on-site test, simply searching for vlookup syntax night before won't be enough in the competitive job market such as in London or the UK.
There are however things that you can improve even on that last evening.
Free bonus: Get our detailed to do list here
Interviewing is not only about testing your skills but also about how you sell them. The interviewer would like you to pass the test, but also to present that you can:
Do the entire job, not just convert data inputs to outputs
Be effective and quick
Relate spreadsheet data to real business scenarios
Understand data limitations
Communicate issues (also to non-technical stakeholders)
Look for or offer help when needed
Present data in a concise and simple way
Tip 0: Assess your skills. If your Excel interview test won't be focused on specific functionalities that you've used for last 6 months, you should spend at least several intensive days or couple weekends of intensive studying to not rely on pure luck. The famous Excel Bible has over 1'000 pages, median Excel test is about 1-hour-long and booked just a couple days in advance. Therefore, it's best to get ready beforehand and take a steep slide from the pick of the Dunning-Kruger Effect curve...
...or take this 3-minute Excel test to diagnose your skills
The following tips will help you to take a test independently, but if you live in London, you can register for my unique, on-site course. You will be able to grasp majority of Excel interview tests in just one Saturday, learning through the practice. You will work on spreadsheet assessments and will be supervised and supported during the class conducted by me. I organise them only several times a year, and they get fully booked fast.
Here are 7 tips that will help you pass an Excel interview test:
1. It is more than just providing the right answers
show your problem-solving approach
present your tenacity and enthusiasm
don't be afraid to ask questions, especially to understand the bigger picture and how the skills tested relate to the future work activities
2. Do your due diligence
make sure to learn who is going to interview yourself, what's their background,
check the company (their website, LinkedIn, social media profiles),
check the specific department or team (What kind of data they work on? What skills they would like you to have?)
3. Learn what type of test it's going to be
online or on-site
closed book or open book
supervised or unsupervised
4. Narrate if you can
learn industry essentials
relate to them
uncover broader context
5. Workarounds are OK if not too frequent
very often there are multiple solutions
you can be creative, but should remain realistic
don't overkill easy tasks
6. Know where to look
break the problem down to simpler tasks
build up the solution step by step
last resort: search the ribbon
7. Master the buzz topics
don't memorise, understand the mechanism or syntax
repeat: lookups, pivot tables, sumifs, countifs, nested ifs
don't forget about data cleansing, dollaring, dragging down, setting right data format
Michael Sena. The founder of Senacea – MS Excel consultancy & training services provider, based in London, operating in the entire UK. If you are looking for MS Excel Experts or VBA developers to automate and improve your spreadsheet work or help you repair Excel files, contact us now.