training needs analysis

Excel VBA

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 ever recorded Excel macros?
Do you know how to access the Excel Visual Basic Editor to make minor changes to macros?
Do you understand the purpose of the Personal Macro Workbook? (personal.xls)
Do you understand the basic layout and syntax used in the Visual Basic Editor?
Can you modify your Quick Access toolbar to give access to your macros?
Do you understand the difference between relative and absolute referencing in a macro?
Are you familiar with the ActiveCell and Offset method for referencing your workbook in macros?
Can you create variables in your code?
Can you make a macro call another macro?
Do you know how to declare variables of different data types?
Can you create a macro which toggles a feature (on and off)?
Can you get simple user input to be included in your macro?
Can you create conditional statements in your code (IF, THEN, ELSE statements)?
Can you add loops to your code (FOR or WHILE loops)?
Do you know how to compile your code before running a macro?
Can you use break points in your code?
Do you know how to program workbook and worksheet events?
Can you include error handling routines in your macros?
Can you create basic dialogue boxes to be displayed and used by your macros?
Can you populate combo-boxes in dialogue boxes from data in your spreadsheet?

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

To book your course contact us at or telephone us on 01949 21 21 21.

Cancel and return to list of Needs Analysis forms.

View the related course outlines

Login form