Free Excel Test :

What are your  ‘Actual’ Excel  Skill  levels .

                                                                                  Excel assessment  Tests  for  Beginners & Intermediate Level .

 

 

Ideal if you are going for a job that requires Excel or  if you want to test your team’s or potential employees “real” excel skills. Can you complete practical ‘real Life’ Excel tasks  correctly and safely ?  How long is it taking you to complete these Excel tasks?
Most employers these days dont ask Excel  interview questions , they set excel assessment tests to know for sure .

We have designed  a  Free to Download  ‘Excel Test” Workbook ‘ which reveals the true story- the ‘real’ existing skill levels in terms of  knowledge and  also timing. Our  unique  Excel Test  Workbook  requires  you to   complete  12  ‘Real life’  practical  Excel  tasks on an  actual Microsoft Excel workbook.

The free Excel Test Workbook checks Not only if they can complete these tasks but  it also benchmarks  how long it is taking them. It times you as you complete the tasks  and  auto-corrects your solutions ,  producing  a personalized report  showing your..

  •  Efficiency  Rating.
  •  Excel Skill  Grading
  • Highlights the areas  you  are weak  in.

How we Selected the Tasks  for Excel Assessment Tests &  Benchmarked the Timings.

We have 12 years of Excel training data to assist us.
Since 2013, our online Excel Course system has served tens of thousands of lessons, replayed lessons , online exams and repeat exams  to thousands of students and companies all over the world.
Using this online data  and feedback from various industries together with our trainers’ experiences, we created  a bank of practical question tasks  that reflect the use of Excel in the real life office environment.  And  from our extensive Excel exam data results,  how quickly these tasks  can and should be completed.

Please note that marks assigned to tasks are weighted relative to their importance as is the time taken to complete them.

Here are  Sample  tasks /Question  from the Excel Test ..

It tests up to intermediate level. So whether you are doing an excel test for accounts department  or excel test for hr or buying  department , this will reveal your actual skills.

Using the worksheets in this workbook  fix , correct or build solutions to the following practical Excel tasks in a quick , safe and efficient manner.

 

  • This Worksheet has been created by AI. Can you Spot the 7 Mistakes in it.
  • A budget spreadsheet has columns of data that  need to  add together and  averaged. Also you need to  calculate  the percentage  of  each expenditure in relation to total expenditure.
  • The  Sales  spreadsheet lists  the sales records   of our 150 salespeople.  You need to calculate  the commission payable to each salesperson and  then convert these commissions  into  Dollars   based on an exchange rate provided in a cell reference.
  • To many errors  are occurring when staff are inputting data  into our spreadsheets. You need you to create   a drop- down list and only allow certain numeric values to be allowed into certain cells.
  • Our Accounts team want you to update  the accounts worksheets so that  customers  who have paid all their fees  are automatically highlighted in a blue colour and those customers who are 30 days overdue  are automatically highlighted in red.
  • Why are these Xlookup Functions not working ??
  • There are   20,000+   records in  the   Orders Spreadsheet, you need to perform a treble sort on it.
  • The  Marketing Manager  needs  you to build a   report  showing   customers who have bought  certain products , yielding  a specific profit margin and quantity ordered using  Pivot tables.
  • Salespeople who  reach  a certain target  are to get an extra bonus. You need to calculate, using an IF function who is entitled to the extra payment and  then work out the correct payments now due to  all our 150 sales people.
  • Using this table, create a dynamic reporting using the Filter and Sort

So whether you are

  1. Want to test  your own excel skills before your test .
  2. Trying to avoid bad hires. Hiring people who need to have competent Excel skills.
  3. Planning an Excel training course.

our  Free ‘Test Excel Skills  Workbook’ will  give you the  real insight into their actual Excel skills within 20 minutes.

 

How to use?

How to Get  your copy ?

While the Excel Test workbook is very easy to use , the  short  2 minute  video below shows you how to use it  properly. You can  download it directly  in the comments section in our new YouTube  Channel  .
When there, please take  a second to click the free subscribe  button. Subscribers can access the workbook password and get notified when the new “Test your Excel skills in the AI era” comes out.

Click here to Download.
The Excel Testing workbook contains NO macros, so it’s safe to download and works on all versions of  Microsoft Excel.

Scroll to Top