Interact Efficiently Using Google Sheets – Matrix Connexion Sdn Bhd

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

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

Contact Sales

Home

Fundamental Google Workspace Admin Console

Bringing Data Alive with Google Forms & Sheets

Interact Efficiently Using Google Sheets

Create Your Own Library with Google Classroom

Build Your Own Intranet with Google Sites

Malaysia :

Wisma UOA Damansara, Unit 50-7-7, Jalan Dungun, Bukit Damansara 50490, Kuala Lumpur

Call Us: +603-7688 7186

Page Contents