The first problem is what is meant by the term ‘Advanced’. For a variety of reasons this is almost a meaningless word. Anyone who attended a 1 day level 3 Excel course will claim advanced skills even though in our terminology they will be Intermediate. People also often rate themselves compared to the peers they recently worked with. This results in them under or over rating their abilities and there is no commonly acceptable rating scale.
This site allows you to test if your user is actually at the skill level they claim and is perfect for recruitment, inter department transfers and identifying training needs where Excel is a core skill.
It also allows use to benchmark what skill level you are looking for in our terminology AND what job needs are being addressed by Excel so that the testing focusses on these areas.
To get the best out of this site, buy a quiz bundle. You will gain access to the dashboard which will allow you to send quizzes to candidates and see there results. You can either email them a link to do the assessment offsite, or else have them do the assessment onsite on a phone, tablet or computer. Great for screening applicants before any interviews and confirming assessments during the interview process.
As an individual you can also use this site to improve your skill levels and see where you stand in terms of Excel skills.
We test whether the person can perform to the level they claim on there CV. As such we don’t place much regard for whether the candidate uses the shortcuts we like, knows the definitions of items in Excel, or can remember where in a ribbon a button is located. The tests are designed to see if they can do their job using Excel and understand the relevant tools in Excel.
The scoring of the questions are done on a question be question basis.
We don’t disclose the scoring or the answers. Scoring depends on the importance of that question in that particular quiz. As such the points scored for correct answers can depend on the importance of the question in context. So a simple (beginner) question in the Intermediate quiz will score less points than the same question in the Beginner quiz. Similarly, incorrect answers could score zero or a negative score. Based on our years of experience, certain questions (answered right or wrong) are more indicative of skill level than others.
The first problem is what is meant by the term Advanced. For a variety of reasons this is almost a meaningless word. Anyone who attended a level 3 Excel course will claim advanced skills even though in our terminology they will be intermediate at best. However, it is generally used. We suggest you read on to see how it should be done, but if you just want to test a claim that the user is a Level 3 or 4 user, use this test.
Another misconception is that once Advanced, the user is Advanced for any role. Excel use is so varied it is important to know what is required in the job? Are you looking for Advanced financial modelling skills or Advanced data analysis. The 2 are very different and require different types of tests. In our assessments a Beginner Financial modeler we would expect to be at least an Intermediate Excel users.
Given the above, how do you check if the claimed skill is valid. Firstly if you are looking for an Excel level 3, we have prepared a test for this on xyz. We believe this is an Intermediate user but if you are comfortable this is the correct level for the job, use this test to test the validity