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 2024:
( TBA )
Session Duration:
9:30am - 5:30pm
Session Venue:
Virtual via Google Meet
Course Fees:
RM600/pax (subject to 8% SST)