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
- 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)
- 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)
- Data Slicer
- Pivot Table
- Chart
21 May 2025, Wednesday
9:30am - 5:30pm
Virtual via Google Meet
RM700/pax (subject to 8% SST)