Interact Efficiently Using Google Sheets

What You'll Learn



  • Build a further understanding on the Google Sheets functions

  • Create charts and graphs using Spreadsheet data

  • Creating dynamic reports with Pivot Tables

  • Import and Export Data in Google Sheets

  • Data Consolidation from multiple worksheets

  • Format, filter and manipulate data in Google Spreadsheets






Who Should Attend

User who want to get better at analyzing data or building spreadsheets

Business professionals, who want to increase the efficiency of their reporting work

Anyone who wants to learn, and take advantage of the power of Google Sheets


Course Content

  • Getting to know about Google Sheets Template

  • Working with Google Sheets Functions & Formulas

- Conditional Formatting (Create, Copy and Find Duplication)

- Working with Counting function (COUNT, COUNTIF, COUNTA, COUNTBLANK)

- Data Protection function (WORKSHEET / RANGE / CELL PROTECT)

- Others function (DATA VALIDATION, NAMED RANGES, SPLIT)

  • Supercharge your Google Sheets data

- Consolidate Data from Multiple Spreadsheet & Linking Worksheets (IMPORTRANGE)

- Working with IF function (IF, NESTED IF, IFERROR, IF with AND, IF with OR statement)

- Filter data for specific data extraction (FILTER, SORT, UNIQUE)

- Working with Lookup function (VLOOKUP, HLOOKUP, LOOKUP, INDEX, MATCH)

- Retrieving Data with Google Function (QUERY,, ARRAYFORMULA)

  • Presenting your Google Sheets data

- Data Slicer

- Pivot Table

- Chart

  • Recap

  • FAQ

Course Schedule & Fees

Slots in 2022:

( TBA )


Session Duration:

9:30am - 5:30pm

Session Venue:

Virtual via Google Meet

Course Fees:

RM600/pax (subject to 6% SST)