Google Sheets Intermediate Course Outline
Duration:1 Day (8:30am - 3:30 pm)
To become familiar with functions and working with multiple sheets.
An awareness of keys on keyboard e.g.: Shift, spacebar, and Enter key.
Completed Introduction or equivalent.
By the end of the Day you will be able to:
Understand Absolute cell references, have a greater understanding of Functions & linking sheets. You will be more confident in manipulating data.
Module 1 Cell Referencing: Mixed Absolute Cell Referencing.
Module 2 Range Names: Creating a Range Name,Using range names in Functions,Delete Range Names.
Module 3 Functions: Basic IF Function,SumIf, CountIf,If Function,Vlookup.
Module 4 Working with Sheets: Create Multiple Sheets using Group mode,Naming/ Deleting/Inserting,Moving/Copying,Linking sheets,3D Formulas.
Module 5 Working with Data : Sorting/Filtering,Sheet Protection,Workbook Protection.
Module 6 Graphs: Creating Graphs ,Manipulating Graphs,Advanced Edits.