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?