Microsoft Excel – Training Needs Analysis (TNA)

    Training Needs Analysis : Microsoft Excel




    Tasks

    How would you rate your confidence with each task

    Would you like to know more

    Entering, editing & selecting data

    NoneMinimalGood

    YesNo

    Opening, closing, saving and printing spreadsheets

    NoneMinimalGood

    YesNo

    Moving data with Cut, Copy & Paste

    NoneMinimalGood

    YesNo

    Create basic formulas using plus, minus, multiply, divide

    NoneMinimalGood

    YesNo

    Using the AutoSum feature

    NoneMinimalGood

    YesNo

    Make a cell reference absolute ($)

    NoneMinimalGood

    YesNo

    Changing the appearance of cells

    NoneMinimalGood

    YesNo

    Creating and formatting charts

    NoneMinimalGood

    YesNo

    Linking worksheets and workbooks using formulas

    NoneMinimalGood

    YesNo

    Using Conditional Formatting to highlight data

    NoneMinimalGood

    YesNo

    Using Range Names for navigation and in formulas

    NoneMinimalGood

    YesNo

    Conditional Functions and using the IF function

    NoneMinimalGood

    YesNo

    Restricting input with Data Validation

    NoneMinimalGood

    YesNo

    Working with Data Lists & Auto-filter

    NoneMinimalGood

    YesNo

    Creating and using Templates

    NoneMinimalGood

    YesNo

    Manipulating text with Functions

    NoneMinimalGood

    YesNo

    Using SUMIF, COUNTIF & AVERAGEIF

    NoneMinimalGood

    YesNo

    Using VLOOKUP & HLOOKUP

    NoneMinimalGood

    YesNo

    Summarising data with Pivot Tables and Pivot Charts

    NoneMinimalGood

    YesNo

    Using Goal Seek for problem solving

    NoneMinimalGood

    YesNo

    Using Solver for problem solving

    NoneMinimalGood

    YesNo

    Using Scenario Manager for What-If-Analyses

    NoneMinimalGood

    YesNo

    Recording and running Macros

    NoneMinimalGood

    YesNo

    Are there any other topics you'd like to cover?