Main Training Program

GOOGLE SHEETS: ADVANCED

Share:

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.

 

PREREQUISITES

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

 

HOW TO SEND US AN ENQUIRY?

  1. Fill in the form below and submit it to us. A popup message “Thank you for your message, our sales person will contact you soon.” will appear after a few seconds.
  2. Initiate a conversation via live chat on the bottom left of our website by stating: ‘Hi, my name is [your-name]. I’ve already submitted the form for this training.’
  3. We’ll promptly reach out to you regarding the training you’re interested in.

How To Enquiry From Us?

  1. Fill in the form below and submit to us.
  2. Initiate a conversation via live chat on the bottom left of our website by stating: “Hi, my name is [your-name]. I’ve already submitted the form for this training.”
  3. We’ll promptly reach out to you regarding the training you’re interested in.

Program Enquiry Form

    ORGANIZATION DETAILS






    PERSON-IN-CHARGE DETAILS




    FOR FURTHER INFORMATION, PLEASE CONTACT US!