1
2
3
4
5
6
7
8
9Spreadsheets Part 3 |
|---|
Spreadsheets Unit OverviewYoutube Video Overview:Part 1, Part 2, Part 3, Part 4 Spreadsheet Part 2 (Example Exam) - Year 8 MockVideo Tutorial
1.1 Functions Recap: Objectives PDFSkills Lesson 1: Excel FileMovies Vlookup File
1.2 Extracting & Concatenate: Objectives PDFSkills Lesson 2: Excel FileVideo Tutorial
1.3 Conditional Functions (IF & Nested): Objectives PDFSkills Lesson 3: Excel FileVideo Tutorial Part 1Video Tutorial Part 2
1.4 Lookups: Objectives PDFSkills Lesson 4: Excel FileVideo Tutorial
XLookup - FileVideo Tutorial
Spreadsheet Part 3 (Example Exam)Video Tutorial (Part 1, Part 2)
|
Extension Tasks:
Formulas
Spreadsheets - HW 1
Spreadsheets - HW 2
Spreadsheets - HW 3
Car Rental
Phone Contract
Nested Ifs
Graphs Part 1, Part 2
