Google Sheets
A one-day hands-on programme for teams building spreadsheets in Google Sheets without using most of what it can do beyond basic formulas. Sheets has real advantages over a desktop spreadsheet for a team: live co-editing, version history that actually shows who changed what and when, and a built-in automation layer that does not require installing anything.
The day moves from core formulas and functions through pivot tables for summarising data, data validation for building forms that resist bad entries, and a gentle introduction to Apps Script for small automations, with no coding background assumed. A short closing comparison helps teams deciding between Sheets and Excel make that call based on how their team actually works rather than habit.
HRD Corp SBL-Khas Claimable
Programme Agenda
9:00 AM - 9:15 AM
Welcome and Programme Overview
Introduction to the session, objectives, and housekeeping.
9:15 AM - 10:15 AM
Core Formulas and Functions
Lookup functions, conditional functions, and combining functions to answer real questions rather than building a wall of manual calculations.
10:15 AM - 10:30 AM
Break
10:30 AM - 11:30 AM
Pivot Tables for Summarising Data
Building a pivot table from raw data, common summarisation patterns, and keeping a pivot table updating as source data grows.
11:30 AM - 12:30 PM
Data Validation and Simple Forms
Dropdown lists, validation rules that reject bad entries at the point of entry, and linking a Google Form to a sheet for structured collection.
12:30 PM - 1:30 PM
Lunch
1:30 PM - 2:15 PM
An Introduction to Apps Script
What Apps Script is, and a small automation built live, such as a notification when a cell changes or a scheduled report, with no coding background assumed.
2:15 PM - 3:15 PM
Sharing, Version History and Protected Ranges
Sharing permissions, recovering an earlier version after a mistake, and protecting specific ranges so critical formulas cannot be accidentally overwritten.
3:15 PM - 3:30 PM
Break
3:30 PM - 4:15 PM
Google Sheets Versus Excel: Making the Call
Where each tool is genuinely stronger, and a practical framework for a team deciding which to standardise on.
4:15 PM - 4:45 PM
Applied Practice
Participants bring one spreadsheet from their own work and apply at least one formula improvement, a pivot table, and a data validation rule to it.
4:45 PM - 5:00 PM
Wrap-Up and Q&A
Key takeaways, next steps, and close.
Key Outcomes
- Use lookup and conditional functions to answer real questions from data
- Build and maintain a pivot table that updates as source data grows
- Apply data validation to prevent bad entries at the point of entry
- Build one small automation using Apps Script without a coding background
- Recover an earlier version and protect critical ranges in a shared spreadsheet
- Apply a practical framework for choosing between Google Sheets and Excel
Training Mode Physical / Online / Hybrid / e-learning
HRD Corp SBL-Khas Claimable
Level Foundation to intermediate, suitable for all staff who build or maintain spreadsheets, with particular value for finance, operations and administrative teams
Duration 1 Day (8 Hours) | 9:00 AM to 5:00 PM
Venue In-house at the client's premises, or delivered via the client's preferred platform (Microsoft Teams, Zoom, or equivalent)
Assessment Hands-on practical tasks plus a 10 to 15 question knowledge assessment
Certificate Certificate of Completion issued to all participants upon full attendance