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.

Course Brochure

Prerequisite

This course is for beginners. No prerequisite is required.

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

Gemini for Google Sheet

Course Code: C817
Share

What's This Course About

Gemini for Google Sheet shows you how to use Gemini, Google's AI assistant, inside Google Sheets to build formulas, clean and organise data, analyse trends and create reports in a fraction of the usual time. Instead of searching for the right function or manually reworking data, you can describe what you need in plain English and let Gemini do the heavy lifting while you check and refine the results. The course is designed for professionals, administrators, analysts, teachers and anyone who works with spreadsheets in Google Workspace.

You will start by getting started with AI in Google Sheets, learning how to access Gemini in the side panel, write effective prompts and use AI to create tables, generate formulas and explain how existing formulas work. You will practise cleaning and organising data, such as removing duplicates, splitting and combining columns, standardising formats and categorising entries. Next you will analyse and automate data with AI in Sheets, asking Gemini to summarise data, highlight trends and outliers, build pivot tables and charts and suggest insights.

Throughout the course you will also learn how to use AI functions to process text and data at scale, connect Sheets with other Google Workspace apps and automate repetitive steps. You will cover how to verify AI results and protect sensitive information. Every exercise is hands-on with realistic business datasets. By the end, you will be able to use Gemini in Google Sheets confidently to work faster, reduce errors and turn your spreadsheet data into clear, useful insights.

This course is part of our AI training in Singapore, where you can browse all our AI courses. See more Gemini training.

Why Take This Course?

  • Hands-On Learning Learn by doing. Every topic is practised hands-on, so you leave with skills you can use at work straight away.
  • Live Coaching Experienced instructors coach you live, answer your questions and guide you step by step.
  • Free Post-Course Consultation Stuck after class? Message your trainer any time for guidance as you apply what you have learned.
  • Always-Updated Materials Materials are refreshed to stay relevant. Log in to our LMS any time to get the latest version.

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: Getting Started with AI in Google Sheets

Topic 2: Analysing and Automating Data with AI in Sheets

Course Info

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:

You will need the following for this course:

  • A Google account with Gemini in Google Sheets (included in Google AI Pro and eligible Google Workspace plans)

Hardware: Windows PC or Mac laptop

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

Spreadsheets sit at the centre of many of the automations Dr. Alfred Ang designs, which makes Gemini in Google Sheets a natural course for him to lead. He is a full-stack AI developer, Agentic AI solution architect and corporate trainer, and Managing Director, CIO, CTO and Chief Instructional Designer of Tertiary Infotech Academy Pte Ltd. He works extensively with Google's AI stack, including the Google Gemini Agent SDK, alongside other frameworks such as n8n, the Claude Agent SDK and the OpenAI Agents SDK. His data credentials are solid: he holds a PhD in Electrical Engineering from NUS and is a Microsoft Certified Power BI Data Analyst (PL-300) and Data Scientist (DP-100), with more than 20 peer-reviewed papers to his name. Several projects among his 300+ public GitHub repositories use Google Workspace and Gemini directly: an AI inventory audit and forecasting agent that reads stock levels, flags items below the reorder threshold, computes replenishment and reports through Google Sheets and Gmail; a no-code RAG demo in which a Telegram AI agent powered by Google Gemini answers questions from uploaded documents; and a course chatbot built with n8n and Gemini. He also designs customised corporate training in AI and data engineering. He also holds an MSc in Electrical and Electronic Engineering from NTU and a B.Sc (Hons) in Physics from NUS, and is an ACTA-certified trainer and DACE-certified curriculum developer. As Chief Instructional Designer, he focuses on practical skills that learners can use at work the very next day, rather than theory alone.

In this course, Dr. Ang shows professionals, administrators, analysts and teachers how to let Gemini do the heavy lifting in Google Sheets while they stay in control of the results. Learners begin by getting started with AI in Sheets: describing in plain English what they need, generating and explaining formulas, and cleaning and organising messy data into a usable structure. They then move on to analysing and automating data, asking Gemini to summarise trends, build tables and charts, and assemble simple reports that once took hours to produce. Drawing on his analytics background, he emphasises checking AI-generated formulas, spotting errors in source data and understanding the logic behind a result rather than accepting it blindly. He also shows where Sheets fits into wider automation, for example as the reporting layer of an AI agent workflow, so learners can see what is possible beyond the spreadsheet itself. His teaching is hands-on and patient, using realistic office datasets so participants build confidence quickly and leave with time-saving techniques they can apply immediately. He also shares practical prompting habits for spreadsheets, such as naming columns clearly, giving Gemini an example of the desired output and asking it to explain a formula step by step before using it. These small habits make the results more reliable. Learners are welcome to bring their own anonymised spreadsheets to practise on during the class. To see his Google Sheets and Gemini automation projects, view his GitHub portfolio at https://github.com/alfredang and connect with him on LinkedIn at https://www.linkedin.com/in/angchewhoe/

Dwight Nuwan Fonseka is an ACLP-certified trainer and Head of Data Science at Plano Pte. Ltd., with deep expertise in data analytics, machine learning and AI applications. He has hands-on experience preparing data, developing predictive models and building interactive RShiny dashboards with R and Python, and his professional background includes healthcare, finance and customer analytics. Dwight brings an applied perspective to AI, focusing on both the opportunities and the risks of emerging technologies. With a Masters in Education from NTU and eight years of teaching experience in international schools, he explains analytical concepts in a clear, accessible way.

In Gemini for Google Sheet, Dwight applies his data analytics experience to everyday spreadsheet work. He helps learners get started with Gemini inside Google Sheets, describing what they need in plain English to build formulas, clean and organise data and analyse trends. Participants then use AI to analyse and automate data tasks and produce reports far faster than by hand. Drawing on his analytics practice, Dwight emphasises checking and refining AI-generated formulas and results rather than trusting them blindly. Learners leave with practical techniques to work smarter in Google Sheets and turn raw data into reliable, well-presented insights.

Ken Yuen is an ACTA-certified adult educator specialising in STEM education, IoT systems and programming, with Python among the languages he teaches. He has worked as an instructor, Application Development Engineer, Technical Consultant and Project Manager, and as a Technical Consultant at Anson Engineering he developed IoT-based temperature monitoring and SCADA systems for industrial applications. He holds a Bachelor of Electrical and Electronics Engineering from Nanyang Technological University and a Diploma in Electronic Engineering from Singapore Polytechnic, and is a certified PMP and MOE-registered instructor.

Ken brings his data-handling and programming background, rather than a spreadsheet specialist career, to Gemini for Google Sheet. Having built industrial monitoring systems, he understands the value of clean, well-structured data and clear reporting. He guides learners through getting started with AI in Google Sheets and then analysing and automating data with Gemini: describing a need in plain English, generating formulas, cleaning and organising data, spotting trends and producing reports. His practical, hands-on teaching helps participants check what Gemini produces and apply it confidently to their own everyday spreadsheet tasks.

Terence Ee is an independent consultant and ACLP-certified trainer whose current areas of focus include office productivity applications, project management and information security management. As a WSQ-accredited trainer he delivers programmes in digital collaboration and productivity tools, helping learners apply platforms such as Microsoft 365 and Google Workspace to improve collaboration and business efficiency. He brings more than 25 years of corporate IT experience, including roles as Chief Information Officer at the Supreme Court of Singapore and Vice President of Information Systems at Senoko Energy, and he holds a Master of Science in Technology Management.

In this course, Terence builds on his Google Workspace and productivity training to show how Gemini's AI features can speed up everyday spreadsheet work. Learners start by getting comfortable with AI inside Google Sheets, then use it to analyse their data and automate repetitive tasks. Drawing on his years of leading information systems in large organisations, he keeps the emphasis on practical business outcomes and on checking AI output before relying on it for decisions. His facilitation uses case studies and hands-on exercises, so participants leave able to apply Gemini to their own spreadsheets with confidence and to work more efficiently with data across Google Workspace.

Review

Customer Reviews (21)

Average Rating: 4.7 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
Trainer is engaging. (Posted on 5/22/2026)
Recommended 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
A huge thanks to Dr Alvin Ang for the carrying out the 2 days online training. I learned new things and refreshed old ones. Best part was when we worked together to solve issues, which would most likely happen when dealing with Gsheets at work. All the best (Posted on 11/24/2025)
Recommended 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
I realise there's more that I need to learn through this course. Thanks, Dr Alvin! (Posted on 11/24/2025)
Recommended 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 11/24/2025)
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/20/2024)

Items 1 to 5 of 21 total

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

Write Your Own Review

You're reviewing: Gemini for Google Sheet

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