WhatsApp us Skip to content
Corporate Training Malaysia Request a quote
Google Workspace training · In-house & public

Google Sheets, Apps Script and dashboard training

For teams that run on Google Workspace: cleaner sheets, automated routine work with Apps Script, and live dashboards in Data Studio (formerly Looker Studio). 100% HRD Corp claimable programmes.

Pick what your team needs

From your first sheet to automated, live dashboards

Take one, or run them as a series. Tell us what your team does in Google Sheets today and we’ll recommend where to start.

1 day · Beginner

Google Sheets Basic

Set up, calculate and share a clean spreadsheet with confidence.

  • Getting started with Google Sheets
  • Entering and formatting data
  • Basic formulas and calculations
  • Organising and checking data
  • Charts for everyday reporting
  • Sharing and working together
1 day · Intermediate

Google Sheets Intermediate

Analyse, summarise and connect your data across sheets and files.

  • Logical and lookup functions
  • Text and date functions
  • Cleaning imported data
  • Pivot tables and data visualisation
  • Importing and linking data
  • Collaboration controls
1 day · Intermediate to advanced

Google Sheets Master Class: reports to a live dashboard

From everyday lists to clean reports and a live management dashboard.

  • Core to advanced formulas, lookups and data matching
  • Data cleaning and pivot table analysis
  • A one-page dashboard with key figures, a chart and a table
  • Feeding the dashboard from other files with IMPORTRANGE
  • Protecting and sharing it view-only with management
1 day · Intermediate to advanced

Google Sheets Advanced with Apps Script

Automate repeat tasks and reports across Sheets, Gmail, Forms and Drive.

  • Introduction to Google Apps Script
  • Automating Google Sheets tasks
  • Custom functions and triggers
  • Google Workspace integration
  • Reporting and dashboard automation, including automatic refresh
Dashboards · On request

Dashboards in Data Studio (formerly Looker Studio)

Connect your Google Sheets to Google’s free dashboard tool and share live reports with management. Data Studio was called Looker Studio until April 2026.

  • Ask us for the outline

Your team works in Microsoft Excel instead? See Excel training and Power BI training.

At your office, or in a public class

In-house

We come to your team

  • Exercises built on your own sheets and forms, if you share samples
  • Works with your company’s Google Workspace accounts
  • Anywhere in Malaysia, at your office or live online
Public class

Send one or two staff

Common questions

Is the training HRD Corp claimable?

Yes — 100% HRD Corp claimable programmes. We send the outline and quotation your HR team needs to apply.

What do participants need?

A laptop with Chrome and a Google account. For in-house training, company Google Workspace accounts are best, so scripts and dashboards can be shared inside your organisation afterwards.

Is Data Studio the same as Looker Studio?

Yes. Google renamed Looker Studio back to Data Studio in April 2026. The free version is the same report and dashboard tool.

Do we need to know coding for Apps Script?

No. We start from recorded steps and simple examples, and show how to use AI tools to write and fix scripts if your team wants that.

Tell us what your team does in Google Sheets

We’ll suggest where to start and send an outline and quotation.