Entry Level 3 / Level 1 ICT – Introduction to Excel - 4 Lessons + Assessment - Functional Skills

A complete beginner-friendly unit designed to take students from little or no Excel experience to confidently using formulas and working across multiple worksheets.
Ideal for Entry 3, Level 1, KS3 and KS4 ICT / Computing.
This unit includes 4 fully resourced lessons plus an optional challenge task:
Lesson 1 – Introduction to Excel
• Understanding workbooks and worksheets
• Rows, columns and cell references
• Entering and organising data
Lesson 2 – Professional Formatting
• Formatting text and numbers
• Currency formatting
• Adjusting column widths
• Creating professional spreadsheets
Lesson 3 – Basic Formulas
• Addition, subtraction, multiplication and division
• Using cell references
• Avoiding common formula errors
Lesson 4 – Multi-Sheet Workbook Challenge
• Working across multiple tabs
• Applying the four operations independently
• Reading and interpreting spreadsheet tasks
Optional Extension Task
• Comprehending an existing spreadsheet with pre-entered formulas
• Interpreting calculations
• Identifying errors
Lessons include:
✔ PowerPoint slides
✔ Student task sheets
✔ Practical spreadsheet files
✔ Model answers
✔ Clear learning objectives and success criteria
This unit builds a strong foundation for further topics such as functions (SUM, AVERAGE), IF statements, charts and data analysis (COMING SOON!).
Perfect as:
• An Excel introduction unit
• A computing skills module
• A cover work pack
• A digital literacy scheme