Excel Skills Test
The Excel skills assessment test assesses the person’s aptitude for Excel learning and allows you to match your Excel skill level to the correct training material.
Adjacent is an example report comparing our average visitor (dashed line) to the traditional Excel 1,2 and 3 skill levels (notice that a person with Excel level 3 is still only touching the surface of what Excel can do).
Unlike other tests, there is often more than 1 correct answer and our intricate scoring system provides a better overview of the person’s actual skills. The report will provide an overall score as well as ratings in the following areas:
- Fundamental Knowledge- the basics
- Using Tools- using the tools available in excel e.g. sort, autofilter, pivot
- Using Functions- using Excel’s key formula functions e.g. vlookup, sumif etc
- Super User Attributes- ability to solve problems in excel using all the above
For more details you can download the Excel Aptitude Tests Brochure explaining each area.
You can download the Excel Skills Assessment Handout and complete it (instructions and questions sheets). Send it to info@AuditExcel.co.za with proof of purchase and we will score the test and send back the report.
You will notice that throughout the site there are scores from 0 to 10 on the free video tutorials and courses. Once you have your score you will be able to assess the Excel training material that is most appropriate for you.
Below are some interesting results from the full Excel skills assessment. Once you have your report you can compare yourself to these graphs.