• Home
  • Google Sheet Essential Training

Google Sheet Essential Training

Course Information

  • 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

Certification

  • 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

What's This Course About

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!

Funding Options

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)

Course Date

* Required Fields

Additional Note

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

Post-Course Support

  • 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.

Cancellation & Reschedule Policy

  • 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

Course Details

What You'll Learn

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

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

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.

Review

Customer Reviews (21)

will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 2/23/2024)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
.. (Posted on 10/11/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Supply Refreshment (Posted on 10/11/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Longer training hours (Posted on 10/11/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 10/11/2018)

Items 16 to 20 of 21 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5

Write Your Own Review

You're reviewing: Google Sheet Essential Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment