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
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.
More in this category
Google Workspace & Analytics
2 days
Google Workspace & Analytics
2 days
Google Workspace & Analytics
2 days