Microsoft Excel Skills Workbook (£)

  • A number of Excel skills in an Excel workbook that is self-marking including: basic formulas, IF; COUNTIF; COUNTBLANK; HLOOKUPS; VLOOKUPS; MACROS, USEFUL FORMULAS; GOAL SEEK; LAYOUT; CASCADING MENUS;CELL PROTECTION. 
  • Useful as a skills revision, testing or introduction or as a teaching tool to prepare students for spreadsheet work.
  • Suitable for ECDL - students just won’t need to cover all of the workbook to prepare for the exam. 
  • I’ve included an xlsm version and answers plus an .xls version as the instructions are slightly different. 
  • Macro helpsheet included for one of the tasks.