Excel Spreadsheet Unit Lessons for KS3/KS4

10 Lessons on Microsoft Excel skills.
Lesson 1 - Intro to Excel, Simple Formula & Formatting Techniques
Lesson 2 - Simple Functions (SUM, MAX, MIN, AVERAGE) & Data Types
Lesson 3 - Functions (Count, CountA, Countblank, Round, IF) & Graph Types
Lesson 4 - Functions (IF, SUMIF, COUNTIF) & Intro to Conditional Formatting
Lesson 5 - Recap Functions (IF, SUMIF, COUNTIF) & Using Conditional Formatting
Lesson 6 - Functions (Concatenate, Now, Today, Vlookup)
Lesson 7 - Data Validation Techniques, Sorting Data & Filtering Data
Lesson 8 - Recap Sorting & Filtering Data, Functions (LEFT & RIGHT)
Lesson 9 - Protecting a Sheet, Protecting a Workbook, Encrypt a Workbook with Password, Protect a Workbook using Read Only
Lesson 10 - Creating Macros to link sheets & Creating Pivot Charts

Each lesson includes:
Teacher Slides Powerpoint
Starter/Do Now Tasks (Word Documents or Excel Spreadsheets)
3 - 5 Student Lesson Tasks (Excel Spreadsheets)
Extension Tasks (Excel Spreadsheets, Word Documents or PDF Documents)
Plenary/Exit Tasks (Included in the Teacher Slides Powerpoint)