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?