Excel Training Needs Evaluation Test: Intermediate or Advanced?

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

Microsoft Excel learning needs evaluation tool

We have two Excel Training Needs Analysis forms. The test on this page which will help you to evaluate whether you need an intermediate or advanced course (level 2 or level 3) and also a TNA calculator which will give you an indication of whether you need a beginners or intermediate course (level 1 or level 2). See the link below for the 'beginners or intermediate?' 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 Test to answer the questions about your present Microsoft Excel knowledge level. This questionnaire will help you evaluate whether you need an intermediate or advanced course for Excel or whether you might benefit from some degree of blended learning.

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

Excel Training Needs Analysis: Intermediate or Advanced?

Answer the 14 questions below to find out whether you should start to learn Excel at an intermediate level or whether you are ready to embark upon an advanced 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 advanced course. Anything below 35% and you should start at an intermediate level. Scores between 36% and 84% suggest that you might benefit from some level of intermediate/advanced blended learning weighted in favour of intermediate at the lower end and weighted in favour of advanced 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 2
Question 1: Are you comfortable creating a VLOOKUP or XLOOKUP from your Excel data?

NO SOMEWHAT YES

Question 2: Are you comfortable using conditional formatting and paste special?

NO SOMEWHAT YES

Question 3: How confident are you working with data and formulas across linked worksheets?

NOT AT ALL SOMEWHAT VERY

Question 4: How confident are you working with Excel's statistical functions (including MAX, MIN, AVERAGE and COUNT Functions)?

NOT AT ALL SOMEWHAT VERY

Question 5: How comfortable are you creating, naming and defining Data Ranges in Excel?

NOT AT ALL SOMEWHAT VERY

Question 6: How confident are you validating Excel data using input restrictions?

NOT AT ALL SOMEWHAT VERY

Question 7: Do you know how to protect a worksheet?

NO PARTLY YES

Question 8: Do you know how to freeze rows and columns and how to hide rows and columns?

NO PARTLY YES

Question 9: How confident are you creating charts from your data using a variety of Excel's 11 traditional chart types and newer charts types such as maps (Excel 365 only)?

NOT AT ALL SOMEWHAT VERY

Question 10: How confident are you using Excel's financial functions (e.g. PV, RATE, NPER, PMT)?

NOT AT ALL SOMEWHAT VERY

Question 11: How confident are you working with Excel's logical functions (e.g. AND, FALSE, IF, IFERROR)?

NOT AT ALL SOMEWHAT VERY

Question 12: How confident do you feel analysing data using filters, database functions (e.g. DCOUNTA, DGET, DMAX, DMIN) and outlines?

NOT AT ALL SOMEWHAT VERY

Question 13: How confident are you with auditing formulas (e.g. using Trace Precedents, Trace Dependents, Error Checking and debugging with Evaluate Formula)?

NOT AT ALL SOMEWHAT VERY

Question 14: Do you have a basic understanding of how to create pivot tables?

NO PARTLY YES

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 Training Needs Evaluation Test: Intermediate or Advanced?

Which Excel course should I take?

Excel Training Needs Analysis: Intermediate or Advanced?

Our Excel Trainers are:

Our Closed Excel Courses are:

Education is Our Passion:

Training Courses