Module 1: Getting started with Google Sheets
-
Introduction to Google Chrome / Google Drive
-
Google Sheets and the Environment
-
Navigate and Select Data
-
Create a Basic Spreadsheet
-
Open, Save and Close a Google Sheet
Module 2: Modifying a Google Sheet
-
Cut, Copy and Paste Commands
-
AutoFill Options
-
Insert and Delete Options
-
Column Width and Row Height
-
Find and Replace
-
Undo / Redo
Module 3: Using Formulas and Functions
-
Create Relative Formulas
-
AutoCalculate
-
Insert Functions
-
Use AutoSum
-
Copy Formulas
-
Create Absolute Formulas
Module 4: Formatting a Google Sheet
-
Font Formatting Options
-
Add Borders and Fill Colours
-
Cell Alignment
-
Number Formatting
Module 5: Managing Google Sheets
-
Manage Worksheets
-
View different Google Sheets and Files
-
Freeze Panes and Split
-
Navigate around different Sheets within Google Chrome and Drive
-
Print Google Sheets and Change Print Options