Course Details
Course Code: GSSI-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 Level; OR
- Able to switch between task applications
- Able to create a spreadsheet with simple formatting
- Able to print a spreadsheet with headers and footers
- Able to create basic formulas – Addition, Subtraction, Multiplication and Division
- Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
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 simple to complex formulas and functions, like:
- COUNTA & COUNTIFS Function
- AVERAGEA &AVERAGEIFS Function
- SUMIF & SUMIFS Function
- IF Functions
- Nested Functions
- Validate data in a Worksheet
- Filter data using Auto & Advanced Filters
- Create & Format Chart
- Clean Duplicate Records
- Sorting data
Outlines
Module 1: Referencing Calculations
- Topic A: Formula Reference
- Relative References
- Absolute References
- Mixed References
- Topic B: Named Range
- Adding Range with Name
- Using Range Names in Formulas
- Viewing Named Ramges
Module 2: Working with Functions
- Topic A: Conditional Data Summary
- COUNTIF / COUNTIFS
- AVERAGEIF / AVERAGEIFS
- SUMIF / SUMIFS
- DSUM
- Topic B: Logical Function
- IFERROR
- IF
- IFS
Module 3: Organizing Dynamic Data Range with Tables
- Topic A: Organize a Range
- Alternating colors
- Remove duplicates
- Topic B: Sort and Filter Data
- Sorting Data
- Filtering Data
- Topic C: Data Validation
- Lists
- Number
- Date
- Check Box
Module 4: Performing Simple Calculation
- Topic A: Conditional Formatting
- Single color
- Color scale
- Topic B: Create Charts
- Chart Types
- Resizing and Moving the Chart
- Chart style
- Chart & Axis Title
- Series fill color & line color
- Legend
- Format horizontal axis
- Format vertical axis
- Gridline & ticks
