Google Sheets Intermediate Course Outline
Pre requisitDuration:1 Day (8:30am - 3:30 pm)
Objective: To become familiar with functions and working with multiple sheets. Essential: An awareness of keys on keyboard e.g.: Shift, spacebar, and Enter key. Completed Introduction or equivalent. Learning outcome 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. |
TopicsModule 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. |