Basic Tech & Web Skills · BEGINNER
Spreadsheet Lookup Concepts
Practise spreadsheet lookup concepts with worked examples, useful checklists and fictional projects. Learn free; a Certificate of Completion is optional.
What you’ll be able to do
- Apply the workflow: define the lookup question.
- Apply the workflow: use exact matches deliberately.
- Apply the workflow: keep lookup and result ranges aligned.
- Apply the workflow: handle missing and duplicate keys.
- Apply the workflow: test and explain lookup results.
Your course, step by step
- Define the lookup question
- Use exact matches deliberately
- Keep lookup and result ranges aligned
- Handle missing and duplicate keys
- Test and explain lookup results
How completion works
Pass the practice question in every lesson first, then pass four assessment sets in order. Each set has 10 distinct questions and requires at least 80% (8 out of 10). All four must be passed; a high score in one cannot compensate for another. It is open-book and must be your own work. This automated assessment checks course understanding; it does not independently verify identity or workplace competence.
Each set attempt has its own 15-minute window. Starting an attempt counts even if you abandon it. Wait 15 minutes from the start before a retake; after every third attempt of the same set wait 24 hours. Passed sets stay saved. A live attempt can be resumed. Retakes and learning remain free.