IN-STEP E.X.C.E.E.D. - Google Sheet Advanced

2 days

HRD Corp claimable

Runs in-house for your team

Overview

Google Sheets users learn to analyse and manipulate data with advanced formulas and functions, and to control how others use a sheet. The programme assumes the intermediate Google Sheets course or equivalent knowledge.

Participants record and edit macros to automate tasks, apply conditional formatting with colour scales and formulas, and restrict entry with dropdown and dynamic lists. They protect a sheet while leaving chosen ranges editable, then share it with a colleague. The functions covered include date and time, IF, AND, OR, SUMIFS, INDEX, MATCH and array formulas.

Teaching is by interactive lecture, discussion and practical exercise. Sparklines and importing data from another sheet or a web page round off the programme.

Module topics

  • Automating tasks with macros
  • Conditional formatting with colour scales
  • Data validation and dynamic dropdown lists
  • Protecting and sharing a sheet
  • Date, time and logical functions
  • INDEX, MATCH and array formulas
  • Inserting and customising sparklines
  • Importing data from sheets and web pages

Who runs this programme

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry