Topic outline

• 

  Lessons

  • Modelling Data (Spreadsheets) Bundle (£) URL

    • All our Modelling Data lessons in one bundle. 
      
    • Save on purchasing separately!
    • Works well with home learning /teaching remotely as well

    
    

    
    

• 

  Activities

  • Microsoft Excel Skills Workbook (£) URL

    • 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.

  • Basic Spreadsheet Formulas Folder
  • Budget Planner Folder
  • Formulas and Functions Wall Exercise Folder
  • Formulas Practice with Video Folder
  • Min, Max Average Practice File
  • ROUND IF ABSOLUTE File
  • Elf Tracking (Christmas Spreadsheet Lesson): SUM MIN MAX COUNTA Functions (£) URL
• 

  Revision

  • Spreadsheet Revision Guide Task File
  • Theory Revision File