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)
- Will Recommend Review by Course Participant/Trainee
-
Internet access (Posted on 10/11/2018)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
Write Your Own Review
- Recommended Courses
- Related Courses