EDEXCEL IGCSE ICT Unit 6 – Excel Advanced: Data Validation & VLOOKUP (Lesson 1 of 2)

This fully resourced ICT IGCSE Edexcel Unit 6 lesson introduces advanced Excel skills, including how to create drop-down lists with data validation and use VLOOKUP to display data based on the selected list value. It is the first part of a two-lesson Excel project and uses the Red Bull Air Races (held in Abu Dhabi until 2019) as an engaging theme for students, particularly those in the UAE.

The lesson includes:

Literacy and numeracy settler activity

Bespoke online quiz to assess progress throughout the lesson

Stretch task with each activity

Recap task for homework

Example videos throughout, allowing students to re-watch demonstrations at their own pace for independent learning

Complete lesson plan

Additional files for students to quickly begin editing datasets

This resource provides clear, step-by-step guidance for developing advanced Excel functions, while linking learning to a high-interest real-world event.

All profits from this resource support charitable initiatives, including refugee assistance, youth sports, educational programmes, and environmental carbon capture, making our work carbon negative.