JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Home
Google Sheet Essential Training

Google Sheet Essential Training

13 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!

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

No funding is available for this course.

Course Code: C817

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$300.00 (GST-exclusive)

$327.00 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
On-Site Training (5 pax and above)

NRIC (Last 3 Digits and Alphabet)

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

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 and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

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: Ken Yuen is a ACTA certified trainer. He has more than 10 years of experience working as an instructor, Application Development Engineer, Technical Consultant and Project Manager. He is an MOE-Registered Instructor teaching STEM programs for past 3 years such as Arduino, Micro:bits and robotics to schools and libraries based on the smart nation initiative roadmap.

He completed his Diploma in Electronic Engineering at Singapore Polytechnic and graduated with Bachelor of Electrical and Electronics Engineering from Nanyang Technological University and certified PMP (Project Management Professional).

Terence Ee: Terence Ee is a ACTA certified trainer that has delivered IT training in Singapore and Myanmar. He has also facilitated faith formation courses for Christians in Singapore and Myanmar. As a trainer, his mission is to co-create insightful and actionable learning experiences with his learners.His current areas of focus include project management, information security management, quality management and office productivity applications.
Terence has more than 25 years of corporate IT experience. He has held senior management roles in the public and private sectors. He holds a Master of Science in Technology Management, a Bachelor of Science in Computer and Information Sciences, a Diploma in Family Education, and the Advanced Certificate in Training and Assessment (ACTA). Part of his spare time goes towards tutoring his children in their studies (while learning a thing or two along the way). He is also imparting to them the essential skills for thriving in a digital world.

Man Guo Chang: Man Guo Chang graduated from Nanyang Technological University, School of Electrical and Electronic Engineering, major in Computer Engineering.

He has more than 25 years of working experience in the Semiconductor field, specialized in IC Testing, Inline Electrical Testing, Product & Yield Engineering, Data Analysis, System Engineering, and Software Development. He is also an ACTA certified trainer, currently providing STEM training to adult learners in the area of Computer Vision, Internet of Things, Embedded Electronics, and Python Programming

Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a ACLP certified trainer. He have a degree in Biotechnology from NUS, Advanced diploma in Pharmaceutical management from MDIS and Masters in Education from NTU. He have 8 years experience of teaching biology at O and A levels/ IB level in international schools in Singapore and overseas.