Spreadsheets Part 3

Spreadsheets Unit Overview

Youtube Video Overview:

Part 1, Part 2, Part 3, Part 4

Spreadsheet Part 2 (Example Exam)

Video Tutorial

1.1 Functions Recap

Objectives PDF

Skills Lesson 1: Excel File

Movies Vlookup File

1.2 Extracting & Concatenate

Objectives PDF

Skills Lesson 2: Excel File

1.3 Conditional Functions (IF & Nested)

Objectives PDF

Skills Lesson 3: Excel File

1.4 Lookups

Objectives PDF

Skills Lesson 4: Excel File

Spreadsheet Part 3 (Example Exam)

Video Tutorial (Part 1, Part 2)