Topic 1: Spreadsheet Basics
Introduction
Pre work: Creating a Google drive account
Pre work: Creating a copy of my spreadsheet templates!
Spreadsheet basics
Toolbar walkthrough
Data types in Spreadsheets
Navigating Spreadsheets with shortcuts
Simple formatting tricks – beautify your Spreadsheets
Topic 2 Introduction to functions
Get familiar with SUM, COUNT, AVERAGE, COUNTA, MIN, MAX
Activity
Topic 3: Conditional Functions
IF Statement
AND / OR statements
IF’s and nesting IF
Conditional formatting
Conditional arithmetic functions (eg: SUMIF)
Topic 4: Pivot Tables, Sorting & Filtering
Introduction to raw data and the new section format
Pivot tables
Sorting and filtering
Topic 5: Charts & graphs
Creating charts and graphs in Google Sheets
Topic 6: Data Validation & introduction to Dynamic Models
Data validation
Creating basic dynamic model
Data validation and intermediate modelling
Topic 7: Errors, IF Error and Creating named ranges
Errors that we need to know and how to fix them
IFERROR formula
Named ranges
Topic 8: VLOOKUP, Lookup and Index Match
Vlookup
Hlookup
Index Match
Topic 9: Text functions
Adding words together and changing their case
Extracting first and last names from a cell
Left function
Right function
Len function
Trim function
Topic 10: Date & time functions
Edate, EOMonth
Interactive calendar
Topic 11: Rounding and Randomizing
Randomizing using RAND and RANDBETWEEN
ROUND, ROUNDUP and ROUNDDOWN
