Google Sheets Advanced Course Outline
Pre requisitDuration:1 Day (8:30 am - 3:30 pm)
Objective: To create templates with complex formulas. Manipulate and analyse data. Essential: An awareness of keys on keyboard e.g.: Shift, spacebar, and Enter key. Completed Introduction and Intermediate or equivalent. Learning Outcome By the end of the Day you will be able to: create complex functions, manipulate data. |
TopicsModule 1 Functions: Nested If Functions,IF with And/Or/Not,IsBlank, IsText, IsError,IFError.
Module 2 Complex Functions: Lookup,Choose ,Index, Match. Module 3 Clean up Functions: Using Text to Column,Upper case,Lower case,Left/Right,Trim,Len,Concatenate,Text. Module 4 Workbook Tools: Validation Rules,Creating List. Module 5 Pivot Tables,Creating Pivot Tables,Group data,Create Calculated fields,Creating a Pivot Chart. Google Sheets Intermediate |