Training Needs Analysis for Microsoft Excel

Please take a few minutes to complete this form. It will help us determine your current skill level and design a tailored training programme to suit you. Please be honest and accurate with your answers. Thank you.

How would you rate your knowledge of these tasks?
Name: 


  1. Working with Windows and the mouse
    None
    Minimal
    Good


  1. Creating a worksheet; entering and editing data and basic formula
    None
    Minimal
    Good


  1. Techniques for selecting data to work with
    None
    Minimal
    Good


  1. Opening, closing, saving and printing worksheets
    None
    Minimal
    Good


  1. Moving and copying data and formula
    None
    Minimal
    Good


  1. Relative and absolute cell referencing
    None
    Minimal
    Good


  1. Using statistical function (SUM, MAX, AVERAGE, etc)
    None
    Minimal
    Good


  1. Using the Auto sum tool and Auto calculate
    None
    Minimal
    Good


  1. Using Conditional Logic (the IF statement) and Nested formula
    None
    Minimal
    Good


  1. Formatting cells, data, fonts and worksheets
    None
    Minimal
    Good


  1. Creating cell notes and protecting data
    None
    Minimal
    Good


  1. Creating and using templates
    None
    Minimal
    Good


  1. Linking worksheets and workbooks
    None
    Minimal
    Good


  1. Changing page layouts (page breaks, margins, headers/footers)
    None
    Minimal
    Good


  1. Creating and applying lookup tables
    None
    Minimal
    Good


  1. Sorting data and using filters
    None
    Minimal
    Good


  1. Using Excel for a database
    None
    Minimal
    Good


  1. Using Pivot tables and Pivot charts
    None
    Minimal
    Good


  1. Recording and running Macros
    None
    Minimal
    Good




Templates provided by QUIA.COM.