|
Name
|
|
|
Company
|
|
|
Department & Manager
|
|
|
Date
|
|
|
Telephone No
|
|
|
Email Address
|
|
|
Briefly describe your job and how you use or are planning to use Microsoft Excel i.e. what documents you may produce
|
|
If you have never used Excel before please tick Never on the question below, then complate the last question at the bottom of the page and press the Submit button.
|
|
How often do you use Microsoft Excel?
|
Never
Occasionally
Frequently
|
Level 1
|
|
Are you confident with how to create a New workbook?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how move around Excel workbooks?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to minimise, maximise and restore the Excel screen?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to enter data in Excel?
|
Not Confident
Fairly Confident
Very Confident
|
|
Do you understand this formulae: =SUM(A1:A3)
|
No
Somewhat
Fully Understand
|
|
Do you understand cell references i.e. B67
|
No
Somewhat
Fully Understand
|
|
Are you confident with adding and deleting columns?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with adding and deleting rows?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with creating simple formulae using functions such as Count?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to add and remove a currency symbol?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to save and recall an Excel Spreadsheet?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to wrap text in a cell?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to print and print preview your spreadsheet?
|
Not Confident
Fairly Confident
Very Confident
|
Level 2
|
|
Are you confident with using Autofill?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with to use the Date and Time function?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with how to create a chart or graph?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with Vat and Percentage Calulations?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident in using Absolute and Relative cell references?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with IF and Nested IF Functions?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with number series?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with data series?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with creating named cells?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with using named cells in formulas?
|
Not Confident
Fairly Confident
Very Confident
|
Level 3
|
|
Are you confident in creating subtotals within a worksheet?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with PivotTables and PivotCharts?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with changing the source data of a PivotTable or PivotChart?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident in using HLOOKUP AND VLOOKUP?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident in using Filters and Advanced Filters?
|
Not Confident
Fairly Confident
Very Confident
|
|
Are you confident with Tracing the Precedents and Dependants of a formula?
|
Not Confident
Fairly Confident
Very Confident
|
|
What are the most important new skills that you would like to gain after completing your training?
|
|
| |
.gif)
