Skip to content

Mr Ali's ICT Blog

Work for Mr Ali's Classes

  • Home
  • GCSE Computing
    • GCSE Revision Videos
    • Year 10 Linux Tracking
  • Btec ICT
    • Btec U1 Component 2
    • Unit 43 – P1
    • Unit 43 – P5
    • Unit 43 – P6
    • Unit 38 – P1, M1 & D1
    • Task 1 – Interactive multimedia authoring
  • ICTED VLE
  • Personal
    • My Arabic Books
    • Arabic II
    • Calendar
    • Equipment Form
    • ICTED Owncloud
    • Moderation Form
    • My Email
    • School Timetable
    • Timesheet
  • Resources
    • Fireworks Tutorials
    • English padlet
    • Learn English
    • Comped links
      • Pupil Review
      • Year 7 Course
      • Year 8 Course
      • Year 9 Course
      • Comped Online
      • Computing Central
      • Festive Fun
    • Audio Resources
    • E-Safety
    • Examples of OCR Nationals Animation work
    • Pe link1
    • Pe link 2
    • ICT Pupil Voice
    • Kirklees Options
    • Year 8 Homework
    • Cover Mr Ali
Mr Ali's ICT Blog

Tag: Vlookup

Spreadsheets Vlookup Formulas

Lesson Aim

  • Create Vlookup formulas
  • Create Nested IF formulas
  • Sort Data tables

Task

Download the worksheets below and complete the tasks

VlookupsDownload

Example completed task

Index-formulasDownload

Help on formulas

https://www.excel-easy.com/examples/vlookup.html

Author Mr AliPosted on October 8, 2020October 16, 2020Categories Advanced Spreadsheets, SpreadsheetsTags Functions, Spreadsheet, Vlookup

Spreadsheets – IF formulas

Lesson Aim

  • Re-inforce creation of formulas
  • Create IF Formulas
  • Created Nested IF Formulas

Task

Download the worksheets below and complete the tasks

If-Statment-Tasks1Download
If-Statment-Tasks-ExtensionDownload
If-Statment-Tasks-Part-2-New-TaskDownload

Extension

VlookupsDownload
Author Mr AliPosted on October 2, 2020Categories Access to Higher Education, SpreadsheetsTags IF Formula, spreadsheets, Vlookup

Time in Huddersfield

  • Home
  • GCSE Computing
    • GCSE Revision Videos
    • Year 10 Linux Tracking
  • Btec ICT
    • Btec U1 Component 2
    • Unit 43 – P1
    • Unit 43 – P5
    • Unit 43 – P6
    • Unit 38 – P1, M1 & D1
    • Task 1 – Interactive multimedia authoring
  • ICTED VLE
  • Personal
    • My Arabic Books
    • Arabic II
    • Calendar
    • Equipment Form
    • ICTED Owncloud
    • Moderation Form
    • My Email
    • School Timetable
    • Timesheet
  • Resources
    • Fireworks Tutorials
    • English padlet
    • Learn English
    • Comped links
      • Pupil Review
      • Year 7 Course
      • Year 8 Course
      • Year 9 Course
      • Comped Online
      • Computing Central
      • Festive Fun
    • Audio Resources
    • E-Safety
    • Examples of OCR Nationals Animation work
    • Pe link1
    • Pe link 2
    • ICT Pupil Voice
    • Kirklees Options
    • Year 8 Homework
    • Cover Mr Ali
Mr Ali's ICT Blog Proudly powered by WordPress