A free MS Excel skills assessment to help you understand your current MS Excel skill level and how to improve on it. Whether you are worried about Excel questions you will be asked in a job interview, or need a beginner, intermediate or advanced Excel test, our MS Excel Skills Assessment will help you on multiple fronts.
Online MS Excel Skills Test
Our MS Excel test is online and consists of multiple choice Excel questions. You can read below the philosophy of how we test your Excel proficiency and aptitude for work using MS Excel. It takes about 30 minutes and you will receive your report immediately, and it is free.
We can also set up the questionnaire to track participants from the same company and provide a company wide report. Email us for assistance with this.
Note- we have moved the skills assessment to our new Excel Skills Assessment Website. You will be redirected to the correct test that matches this one.
MS Excel Skills Reports
You will receive the following reports relating to your Excel skills (and limitations) after completing the Excel multiple choice questions. The report will come as an email with a link to the Excel skills report page.
Summary Excel Skills Report
The Excel Skills Summary report covers what your AuditExcel skills score and rating is plus recommendations on the standalone and bundled Excel courses you should consider to improve your Excel Skill level and give you practice for any upcoming job interviews and work assignments. The Excel score is out of 10 and the possible ratings are:
- Beginner to Intermediate
- Intermediate to Advanced
The peer comparisons report will show you how your Excel skills and score compares to participants of our skills assessment in your geographic area and a comparison to our worldwide averages.
It will show both your total score and how you compare based on the main Excel skill pillars(Fundamental, Tools, Formulas, Super User)
Specific Excel Strengths and Weaknesses
The specific Excel strengths and weaknesses report focuses on the 4 main pillars of Excel knowledge and where you are strong and weak in terms of our recommended score, your location specific comparative and worldwide comparative scores. This report shows the 4 main pillars in Excel knowledge being:
- Excel fundamental knowledge,
- Using the available Excel Tools and buttons,
- Using Formula and Functions in Excel,
- Excel super user abilities.
What you do in Excel
This report analyses what you do in Excel and allows you to find out which courses match your particular job requirements, particularly relating to Financial Modelling and Budgeting and Forecasting.
The areas that we focus on are Data Cleaning, Manipulation, Reporting and Decision Modelling.
This is particularly relevant if you are preparing for an excel interview test. Understanding what the new job’s Excel requirements are will better prepare you for the likely Excel test they will give you.
This report shows which Excel course bundle would best suit your needs and save you some money.
It covers the combination of courses that best matches your current skill level and job needs.
Options include Beginner to Advanced Excel, Corporate Financial Masterclass (which is Intermediate to Advanced Excel plus Financial Modelling, Budgeting and Forecasting), and a Super Bundle which is if you want to become an all round MS Excel expert.
A summary of your Excel Skills Assessments result with the recommendations. This includes your AuditExcel skills score and skills rating.
Recommendation emphasis is first on the correct skill level courses to consider and what the best Excel bundles would be to not only improve your skill levels, but more importantly to improve your Excel skill levels in the correct areas based on what you are doing, or expect to be doing, with MS Excel in the near future.
It also shows which of our tool and job specific online Excel courses may suit what you have indicated you are, or would be, doing in your job.
You can view an example report of the average participant at MS Excel Skills Assessment Example Report.
Who should use our MS Excel skills assessment test
Excel tests for individuals
Any individual who is
- Preparing for a MS Excel interview test when job hunting,
- Preparing for any MS Excel advanced test,
- Deciding which Excel course to attend,
- Wanting to understand their own skill levels and where they can improve in using MS Excel,
- Wanting to identify which parts of Excel they should practice more.
Although a basic Excel test, the results have been proved time and again with students on our courses who are matched to the correct level of Excel skills.
Excel testing for companies
We also provide company reports where the results of multiple participants from the same company are analysed together.
This is useful for any company that:
- Wants to understand the Excel skill levels in their organisation
- Needs a benchmark of Excel skill levels when hiring new people
- Wants to send staff on the correct courses (how often have your staff complained that they learnt nothing on the Excel course- this will stop those complaints)
Our Excel testing philosophy
The MS Excel Skills Assessment test has been designed to assess your current MS Excel skill proficiency, and includes some weighted scoring and cross checks to ensure it is as accurate as possible.
Understanding Excel, NOT remembering shortcuts or button location
The questions assess your understanding of using MS Excel and is not a memory test. We do not care whether you know a shortcut (there are lots of ways to perform tasks), or where to find the button.
We want to know if you understand Excel. Knowing the shortcut to add $ signs on your formula does not help if you don’t understand why you should use the $ signs. Our questionnaire will check if you understand, in this case, absolute and relative referencing.
Excel capability not Excel version specific
The questionnaire also won’t check whether you are up to date with the very latest features as it is not relevant. Do you understand Excel, NOT are you on the latest version. If you are skilled enough, you will quickly learn the new features when you move to the new versions. If you know XLOOKUP but don’t understand $ signs, your fundamentals are lacking. Our skills test will pick this up.
All questions have multiple right answers and we have weighted the scoring based on our experience. In all cases there is a ‘Don’t Know’ option which you should use if you genuinely do not know the answer. Keep in mind the test is to assess how much you understand of Excel use. Guessing will help no one.
Excel Skills Covered
The report you will receive will cover the following aspects of Excel skills
- Fundamentals Skills- Basics of Excel i.e. entering formula, $ signs etc.
- Using Tools- Using tools like Data Sort, Filter and Pivot Tables
- Using Formula and Functions- Using formula available like IF, VLOOKUP, SUMIF etc.
- Super Excel user abilities- Combining all of the above to derive solutions.
Excel Job Needs Testing
A unique aspect of our Excel skills assessment is the Excel Job Needs section. In this section we ascertain the types of activities you perform with Excel so that you can focus your learnings.
Excel skills required depend on what you do in Excel
MS Excel is so comprehensive that it is impossible to be an expert in everything, all the time. What you need to know depends on your role, and what you will be doing with Excel.
So being an Excel data analysis whiz kid won’t help that much if you require Excel financial modelling skills, but you may be able to transition quickly. Building great Excel dashboards is different from cleaning data and preparing them for dashboards.
We have segmented Excel job needs into:
- backwards looking (management reporting, project tracking, reconciliations, dashboards etc), and
- forward looking (financial modelling, budgeting, forecasting, optimisations etc).
The main areas we report on are:
- Data Cleanup and Scrubbing (everyone using Excel does this, they just do not know it),
- Data Analysis/ Manipulation (merging spreadsheets, creating ratios etc)
- Reporting, and
- Decision modelling (anything forward looking e.g. financial models, budgets, forecasts, estimates etc).
By understanding what you actually do in Excel, you will be better placed to understand which Excel course will help you, and which courses might be nice to know but you will never use!