Home
Google Sheet Essential Training

Sessions 1 day
Duration 7.5 hrs
Level Beginner
Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Google Sheet Essential Training

Course Code: C817

21 Review(s) | Add Your Review

Embark on a journey to mastering Google Sheets with our essential training course. This course is meticulously designed to provide you with a comprehensive understanding of Google Sheets and its powerful features, transforming you into a proficient user capable of harnessing the full potential of this versatile spreadsheet tool. Whether you're managing data, creating charts, or performing complex calculations, our expert instructors will guide you step-by-step, ensuring you gain practical skills that are immediately applicable to your daily tasks and projects.

Our Google Sheet Essential Training covers a range of topics, from basic spreadsheet navigation and formatting to advanced data analysis techniques and automation with Google Sheets. You'll learn how to efficiently organize and analyze data, create visually appealing charts and graphs, and automate repetitive tasks to save time and boost productivity. By the end of the course, you'll be confident in your ability to leverage Google Sheets to its fullest, giving you a competitive edge in today's data-driven world. Sign up now and unlock the full potential of Google Sheets!

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - Enhance Data Insights with Google Sheets and Looker Studio

Course Fee

$350.00 (GST-exclusive)

$381.50 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time *

Sponsorship

Self-Sponsored
Employer-Sponsored

No. of Participants

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Topic 1: Spreadsheet Basics

Introduction

Pre work: Creating a Google drive account

Pre work: Creating a copy of my spreadsheet templates!

Spreadsheet basics

Toolbar walkthrough

Data types in Spreadsheets

Navigating Spreadsheets with shortcuts

Simple formatting tricks – beautify your Spreadsheets

Topic 2 Introduction to functions

Get familiar with SUM, COUNT, AVERAGE, COUNTA, MIN, MAX

Activity

Topic 3: Conditional Functions

IF Statement

AND / OR statements

IF’s and nesting IF

Conditional formatting

Conditional arithmetic functions (eg: SUMIF)

Topic 4: Pivot Tables, Sorting & Filtering

Introduction to raw data and the new section format

Pivot tables

Sorting and filtering

Topic 5: Charts & graphs

Creating charts and graphs in Google Sheets

Topic 6: Data Validation & introduction to Dynamic Models

Data validation

Creating basic dynamic model

Data validation and intermediate modelling

Topic 7: Errors, IF Error and Creating named ranges

Errors that we need to know and how to fix them

IFERROR formula

Named ranges

Topic 8: VLOOKUP, Lookup and Index Match

Vlookup

Hlookup

Index Match

Topic 9: Text functions

Adding words together and changing their case

Extracting first and last names from a cell

Left function

Right function

Len function

Trim function

Topic 10: Date & time functions

Edate, EOMonth

Interactive calendar

Topic 11: Rounding and Randomizing

Randomizing using RAND and RANDBETWEEN

ROUND, ROUNDUP and ROUNDDOWN

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

Able to operate using computer functions
Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

Positive Learning Attitude
Enthusiastic Learner

Experience

Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

Job Roles

Data Analyst
Administrative Assistant
Office Manager
Project Manager
Accountant
Financial Analyst
Marketing Coordinator
Sales Representative
Human Resources Coordinator
Research Assistant
Business Development Manager
Product Manager
Operations Manager
Educator
Small Business Owner

Trainers

Ken Yuen is an ACTA-certified adult educator specializing in STEM education, IoT systems, and programming. With a background in electrical and electronics engineering from NTU, he has conducted WSQ and SkillsFuture courses in Arduino, Raspberry Pi, micro:bit, Jetson Nano, and Python. He is also a registered MOE instructor, having taught coding and robotics programs in over 50 schools, equipping students and professionals alike with practical IoT and programming skills. In his IoT courses, Ken focuses on hands-on experimentation with microcontrollers, sensors, and automation systems. His prior experience as a Technical Consultant at Anson Engineering saw him develop IoT-based SCADA and temperature monitoring systems for industrial applications, giving him strong industry insight. By blending educational expertise with technical project experience, Ken ensures learners develop the confidence to build, test, and apply IoT solutions in real-world contexts.

Terence Ee is an experienced IT leader and consultant with more than 25 years of expertise in technology management, information systems, and digital transformation. He has served as Chief Information Officer at the Supreme Court of Singapore and Vice President of Information Systems at Senoko Energy, where he led major IT modernization projects. Since 2017, he has worked as an independent consultant and ACLP-certified trainer, specializing in guiding SMEs and enterprises in adopting future-ready digital platforms. As a WSQ-accredited trainer, Terence delivers programs in digital collaboration, IT governance, and productivity tools. His facilitation emphasizes case studies, simulations, and hands-on practice, enabling learners to apply modern IT systems such as Microsoft 365 and Google Workspace to improve collaboration and business efficiency. With his leadership background and deep IT expertise, Terence prepares learners to thrive in digitally transforming environments.

Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.