Course Details
Course Code: GSSA-1; Instructor-led
Audience
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Google Sheet.
Prerequisites
Basic knowledge of Google Sheet is essential with the following pre-requisites:
- Have attended Google Sheet – Foundation & Intermediate Level; OR
- Able to switch between task applications
- Able to create simple to complex formulas and functions
- Able to validate data in a Worksheet
- Able to apply Filter data using Auto & Advanced Filters
- Able to clean Duplicate Records
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- Create Subtotal Using the Subtotal Function
- Analyze data Using Pivot Tables
- Use lookup Function
- Combining & Consolidating Data
- Summarizing & Analyzing with Pivot Table and Pivot Charts
Outlines
Module 1: Organize Summary and Details on Your Data
- Topic A: Grouping Data
- Grouping Data
- Displaying and Collapsing Levels
Module 2: Retrieve, Compare or Compiling Data with Functions
- Topic A: Using the LOOKUP Function
- Using VLOOKUP to Find Data
- Using HLOOKUP to Find Data
- Topic B: Alternative LOOKUP Function
- Using the INDEX Function
- Using the MATCH Function
- Combining the MATCH and INDEX functions
- Topic C: Split Data
- Split text to columns
Module 3: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts
- Topic A: Create a PivotTable
- Create PivotTable Dialog Box
- PivotTable Fields Pane
- Summarize Data in a PivotTable
- Show Values as Functionality of a PivotTable
- Topic B: Filter Data by Using Slicer
- Insert Slicers Dialog Box
- Topic C: Analyzing Data with PivotChart
- Creating PivotChart
- Editing a PivotChart
Module 4: Navigating Large Spreadsheet
- Topic A: Linking Sheet
- Inserting links
- Editing links
- Using links
- Remove the link
- Topic B: Protecting sheet and range
- Protecting Range
- Protecting sheet
- Set Permission
