AUDIENCE
This course is suitable for employees of all levels who uses Google Sheets in their daily work. Personnel who wish to further enhance their knowledge in Sheets are also welcomed.
PRE-REQUISITE
Basic knowledge of Google Sheets is essential with the following pre-requisites:
- Have attended Google Sheets: Intermediate Level; OR
- Able to create simple to complex formulas and functions, like:
- SUM, SUMIF, COUNT and COUNTIF Functions
- IF Functions
- Nested Functions
- Able to apply Filter data
- Able to Validate data
- Stable Internet connection
METHODOLOGY
This program will be conducted with interactive lectures, discussions and practical exercise
COURSE OBJECTIVES
Upon completion of this program, participants should be able to:
- Analyze data using PivotTable
- Linking and sharing file
- Use Lookup Functions to retrieve data
- Apply file protection
COURSE CONTENT
Section 1: Using PivotTable
Lesson 1.1: Creating a PivotTable
- Creating a PivotTable
- Adding and Removing Data
Lesson 1.2: Using the PivotTable Editor
- Sorting Data
- Filtering Data
- Using the Summary to summarise data
- Using the Show As to analyse data
- Formatting PivotTable
Section 2: Linking and Sharing Data
Lesson 2.1: Hyperlinks
- Inserting Hyperlinks
- Hyperlink to the Web
- Hyperlink to other Documents
- Hyperlink within same document
- Editing Hyperlinks
- Removing Hyperlinks
Lesson 2.2: Sharing the Worksheet
- Share and assign users
- Set editing rights
Section 3: Lookup Functions
Lesson 3.1: Useful Lookup Functions
- VLOOKUP Function
- HLOOKUP Function
- Nested VLOOKUP
Section 4: Protecting your File
Lesson 4.1: Protect Sheets
- Protecting a Range
- Protecting the whole Worksheet
Lesson 4.2: Protection Settings
- Set User Permission
- Set Cell Exceptions
- Remove Protection
