Lesson 1 – Basic Spreadsheets
- Borders
- Backgrounds
- Merging cells
- adding rows/columns
- Adding / Renaming sheets
- Text size, color, font.
- Page Layout / fit to page
Lesson 2 – Bar charts and graphs
- Why use bar spreadsheets for charts
- favourite pet / sports starter
- Adding bar charts
- Adding charts
Lesson 3 – Simple Formulas
- Cell references Cluedo style starter
- equals, numbers and cell references
Lesson 4 – Advanced Formulas (Fixed cells)
- Fixed cells
- using brackets
Lesson 5 – Freezing and Filtering Sheets
- How to freeze rows / columns.
- How to use the filter functions.
Lesson 6 – Vlookups & Conditional Formatting