Excel Learning Needs Evaluation Test: Beginners or Intermediate?

This Excel learning needs assessment tool takes the form of a simple quiz intended to assist you to determine whether your staff need beginners or intermediate Excel courses.

Microsoft Excel learning needs evaluation tool

We have two Excel Learning Needs Analysis questionnaires. The test on this page which will help you to evaluate whether you need a beginners or intermediate course (level 1 or level 2) and also one which will give you an indication of whether you need an intermediate or advanced course (level 2 or level 3). See the link below for the intermediate or advanced evaluation.

Calculator 1: beginners or intermediate?

Calculator 2: intermediate or advanced?

Which Excel course should I take?

To work out which Excel course would best fit your needs you can use the sliders provided on our Microsoft Excel Learning Needs Calculator to answer the questions about your present Microsoft Excel knowledge level. This guide will help you to evaluate whether you need a beginners or intermediate course for Excel or whether you might benefit from some degree of blended learning.

In order to get the most accurate test results please answer honestly and do your best not to exaggerate your present level of knowledge.

Excel Learning Needs Assessment: Beginners or Intermediate?

Answer the 14 questions below to find out whether you should start to learn Excel at a beginners level or whether you are ready to embark upon an intermediate level Excel training course.

As a general rule of thumb, scores of 85% or over on this test would usually indicate that you are ready to take an intermediate course. Anything below 35% and you should start at a beginners level. Scores between 36% and 84% suggest that you might benefit from some level of beginners/intermediate blended learning weighted in favour of beginners at the lower end and weighted in favour of intermediate topics at the higher end.

Our Excel TNA calculator is super fast and you can usually complete the evaluation test and get your results in under two minutes.

Your privacy is important to us and you can complete this Excel Training Needs Analysis Quiz completely anonymously without any need to provide your name or email address and there is no server-side processing involved in taking this TNA test.

Learning Needs Assessment Calculator 1
Question 1: Do you know the difference between a workbook and a worksheet?

NO SOMEWHAT YES

Question 2: Do you understand the difference between a formula and a function?

NO SOMEWHAT YES

Question 3: Can you enter data using the fill handle cursor to drag and drop from one cell to fill data into other cells?

NO UNSURE YES

Question 4: Can you create simple maths formulas (add, subtract, divide, multiply) to perform calculations on your Excel data (e.g C3+C4/D8)?

NO PARTLY YES

Question 5: Do you know how to copy formulas to surrounding cells?

NO PARTLY YES

Question 6: Are you confident inserting rows and columns and adjusting their width and height?

NO SOMEWHAT YES

Question 7: How confident are you working with absolute references in formulas (e.g. $A$2, A$2, $A2)?

NOT AT ALL SOMEWHAT VERY

Question 8: Do you know how to format cells?

NO SOMEWHAT YES

Question 9: How confident are you at using Print Settings in Excel (Print Range, Print Selection, Print Area)?

NOT AT ALL SOMEWHAT VERY

Question 10: How confident are you creating simple formulas using common functions such as AVERAGE, SUM, COUNT, MAX AND MIN?

NOT AT ALL SOMEWHAT VERY

Question 11: Do you know how to merge cells?

NO PARTLY YES

Question 12: How confident are you filtering data in Excel?

NOT AT ALL SOMEWHAT VERY

Question 13: Do you know how to insert, rename and delete an Excel worksheet?

NO PARTLY YES

Question 14: How confident are you at creating a basic chart from your data (including formatting your chart and adding/editing legends, series, labels and titles) and choosing the right type of chart for your data.

NOT AT ALL SOMEWHAT VERY

We really ❤ love helping organisations to master Microsoft Excel. Our only question is: Will it be yours?

Organise, Analyse, Forecast

Make your data work for you with Microsoft Excel

Our Excel Trainers are:

Specialist educators with a wealth of experience and expertise, proven track records and excellent feedback.

Our Closed Excel Courses are:

Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.

Education is Our Passion:

Over 18,000 students trained across almost every industry, sector and background.

Call 0844 493 3699

Or email info@foursquaretraining.co.uk

We come to you: Our regional, mobile Microsoft Excel trainers cover most locations of mainland UK for on-site visits including the English regions of the North West, North East, Yorkshire and the Humber, Greater London, the East of England, West Midlands, East Midlands, and also some parts of the South West of England (including Wiltshire, Bristol area and Gloucestershire) and South East of England (including Buckinghamshire, Oxfordshire, Berkshire, Hampshire and Surrey). Virtual classroom courses are available from anywhere via live video conferencing.

MS EXCEL LEARNING ASSESSMENT... FourSquare Training

Excel Learning Needs Evaluation Test: Beginners or Intermediate?

Which Excel course should I take?

Excel Learning Needs Assessment: Beginners or Intermediate?

Our Excel Trainers are:

Our Closed Excel Courses are:

Education is Our Passion:

Training Courses