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 Sheet Template
  • Working With Google Sheet Functions & Formulas
    • Conditional Formatting (Create, Copy and Find Duplication)
    • Working with Counting function (COUNT, COUNTIF, COUNTA, COUNTBLANK)
    • Data Protection function (WORKSHEET, RANGE, CELL PROTECT)
  • 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

Courses Schedule & Fees

Slots in 2022:

( TBA)

Session Duration:

9:30am - 5:30pm

Session Venue:

Virtual via Google Meet

Course Fees:

(subject to 6% SST)

Contact Sales