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)
    • 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
  •  

Courses Schedule & Fees

Slots in 2022:

( TBA)

Session Duration:

9:30am - 5:30pm

Session Venue:

Virtual via Google Meet

Course Fees:

RM550/pax
(subject to 6% SST)

Contact Sales

Scroll to Top