Training Needs Analysis - Excel

This form will help to determine the correct level of training that you require. Please answer the questions below in relation to your day-to-day needs.

 

Name:
Email:
 
Do you currently use Excel

Yes

No

if yes, how frequently do you use spreadsheets

Daily  Weekly  Less Frequently

 

Select if you can do the following

 

Select if you need training

Create, save & open spreadsheets

Create formulas for calculating

Use autosum & other functions

Cut, copy and paste

Format spreadsheets - bold, italics, underline, add borders, colours, autoformat

Columns & rows - change the width, height, insert, delete

Set print options for larger spreadsheets

Control pagination, by inserting page breaks

Create charts

Work with lists of information, which needs to be sorted & interrogated, use autofilter

Use autofill & create custom lists

Create pivot tables to present data

Link worksheets with formulae to consolidate information

Record macros to carry out repetitive tasks

Customise & create toolbars

Use advanced functions such as IF, Lookup

Protect your spreadsheet with password protection

 
Enter the code below in here: