Training Needs Analysis

Excel Intro

This questionnaire helps you assess your current skill level, which helps us choose the most suitable course

Please mark each question from 1 to 10. 10 meaning a complete understanding and 1 indicates no previous knowledge. The 'Ability' column is your current knowledge and the 'Need' column indicates how important a topic is to you.

If you do not know what the topic refers to then leave the Need column blank.

*Name: Email:
Company: Phone:


  Ability Need
Have you successfully created worksheets using Excel?
Do you understand the concepts or rows, columns, and cells within an Excel worksheet?
Do you know what the active cell is and how to change its position on the worksheet?
Can you save worksheets to specific folders (directories) and retrieve them at a later date?
Do you know what a range of cells refers to?
Can you create and edit worksheet formulae to perform live calculations?
Do you know the difference between functions and formulae?
Have you used the Sum and Average functions?
Can you copy and move cells and ranges within a worksheet?
Can you use AutoFill to enter lists such as Jan, Feb, Mar as column headings?
Do you know how to adjust column widths and row heights - both manually and automatically?
Can you apply formatting features such as bold and underline?
Do you know how to apply numeric formatting such as % or currency?
Do you know how to change the font, size, colour, and other cell attributes?
Can you control how your work is printed and preview it prior to printing?
Can you print specific regions as opposed to the whole sheet? Can you use page breaks?
Can you change the orientation of individual or group sheets to landscape?
Can you put page numbers on your worksheet print-outs?
Can you change the page margins?
Do you know how to check your spelling?

Ability Total


Need Total


Each question where your NEED is greater than your ABILITY will make this course more useful to you. When these rows total over 50, the course is recommended. 0

Cancel and return to list of Needs Analysis forms.

View the related course outlines

Login form