phone call us Inspizone+65 8586 4485
Email us Inspizoneenquiry@inspizone.com
Send Enquiry
Chat with us InspizoneChat With Us
Access Course Singapore

Learn Google Sheets Advanced Course in Singapore

microsoft access training singapore
microsoft access course singapore
microsoft access courses singapore

Enhance your Google Sheets skills with our advanced course in Singapore. Explore complex functions, data analysis, automation, and collaboration for improved productivity.






Course Start Date


Schedule


Day: 2 Days
Duration: 14 Hours
Timings: 9:30 AM - 5:30 PM

10 Anson Road, 26-08A International Plaza, Singapore 079903

Register Now

Why Choose Us


  • Expert Local Trainers
  • Hands-on Training by experts
  • Certificate of Achievement
  • Free Refresh Class within 6 Month

Quick Register

Who Should Attend This Google Sheets Advanced Course in Singapore


Professionals, analysts, and spreadsheet users seeking advanced skills in Google Sheets. Ideal for data analysts, financial experts, and business professionals in Singapore.

Course Completion Requirements:

Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

Entry Requirements

Above 16 years old

High School Level English

Basic internet & computer operation skills

Google Sheets Advanced Course in Singapore


Overview: Explore the Google Sheets Advanced Course in Singapore to elevate your spreadsheet skills. This comprehensive program delves into advanced functions, data analysis, automation, and collaboration features. Learn to create complex formulas, analyze large datasets, automate workflows with scripts, and collaborate effectively with team members. Elevate your spreadsheet proficiency and gain the knowledge and techniques needed to excel in business and data-driven decision-making. Join us in Singapore for an in-depth Google Sheets experience designed to enhance your professional capabilities.

Prerequisites: Prior experience with Google Sheets basics is recommended for our Advanced Course in Singapore. This course delves into advanced functions, data analysis, automation, and collaboration techniques, catering to both experienced users and those looking to take their Google Sheets skills to the next level. Join us and excel in spreadsheet management!

microsoft access training course singapore

Google Sheets Advanced Course Outline


Lesson 1: Essential Sheets Functions to Summarize

  • Data Types, Function types
  • SUM(IFS) by Criteria (also COUNT, AVERAGE, MAX, MIN)
  • Rounding Values
  • Unique & Sort Functions
  • Logical functions
  • IF, Then & IFS
  • Handling Errors & Pro Tip
  • Named ranges

Lesson 3: Lookup & Filter Functions

  • Overview of Helpful Lookup Functions
  • VLOOKUP and HLOOKUP
  • VLOOKUP Approximate Match (Replacement for many IFS)
  • FILTER function to return Multiple Match Results
  • Lookup Pictures & Images
  • SortN for Ranking
  • Challenge: Find the Mistake in the Formulas
  • Solution: How to Correct the Formulas

Lesson 5: Collaborate, Publish & Protect

  • Sharing Files with Others & Pro Tips
  • Publishing Sheet or Chart (& Embedding in a Web Page)
  • Protection: Sheet & Cell Level
  • Use Google Form to Collect Data
  • Printing & Page Breaks

Lesson 7: Pivot Tables in Google Sheets

  • Explore option in Google Sheets
  • Pivot Table Basics
  • Custom Formulas in Pivot Tables
  • Slicers & Grouping in Pivot Tables
  • Create Pivot Table of results

Lesson 9: Query Function

  • Query Function – the Guidelines you need to follow
  • ImportRange by matching columns
  • Advanced Query
  • Query and Import Range to append data from other sheets

Lesson 11: Introduction to Scripting

  • What you can achieve with Google Scripts
  • Record a macro (Prepare sheet for reporting)
  • Add your script to the menu
  • Reset data Validation example & how to copy and paste a script into your project
  • Record a macro to perhaps copy new data under another set of data

Lesson 2: Overview of Helpful Google Sheet Functions

  • Detect language and Translate
  • Image Function (QR Code)
  • Google Finance
  • Import HTML
  • Import XML

Lesson 4: Text and Date Functions

  • Overview of Text & Date Functions
  • Split Values to Multiple Columns / Row
  • Text Functions
  • Essential Date Functions

Lesson 6: Charts to Impress

  • Sparklines
  • Chart Basics (Column, Line & Map Charts)
  • Slicer with Charts and Tables
  • Combo Charts
  • Chart Trick: Conditionally Format Line Chart Max and Min
  • Connect Your Chart with Checkboxes
  • Key takeaways: Charts

Lesson 8: Advanced Functions & Formula Combinations

  • Index Match
  • Index Match with Multiple Headers
  • The Power of Sequence Function
  • Array Formulas
  • Generate Random Data & Text (Rand Between & Choose)
  • Advanced Sort N
  • Indirect Function
  • Challenge: Solve the Problems
  • Solution: Answers & Steps

Lesson 10: Advanced & Hidden Features

  • Custom Number Formatting Explained
  • Conditional Custom Formatting
  • Conditional Formatting with Formulas
  • Find the Difference between two lists
  • Dependent drop-down lists (do it on a single on and then multiple ones)
  • 10 things on Improving Performance and dealing with slow files

Lesson 12: Useful Add-ons

  • Where to Find Add-ons & How to Install Them

google logo Reviews of our students


Sarah Lah
Sarah Lah
4 months ago

Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.
Arun Dixit
Arun Dixit
11 months ago

I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.
Wenyan Yeo (W)
Cara Chan
4 days ago

Attended WORDPRESS WEBSITE CREATION COURSE on 25 Sep 2023. Really appreciate the training made simple for beginners like myself. The trainer Mr Abhinay gave clear explanations and repeated many times to make sure we understood. Understanding how Wordpress works enabled me to navigate my company website and make updates efficiently. Unfortunately, the plug-in used by my company website was not taught in the course; which is understandable given the many different types of plug-ins available.The staffs were helpful and understanding when I was unable to log-in my singpass for attendance. It was overall an enjoyable experience to me. Snacks and beverages at the pantry was a bonus, too! Thank you, Inspizone!
Joanna
Joanna
10 months ago

Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.
Guido Sudero
Guido Sudero
11 months ago

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
Avira Dixit
Avira Dixit
a year ago

I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!
Leanie Lee
Leanie Lee
a year ago

I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.
Wenyan Yeo (W)
Wenyan Yeo (W)
7 months ago

Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.
Lucia
Lucia
a year ago

I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.
J Quek
J Quek
2 years ago

I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.
Katherine Ang
Katherine Ang
a year ago

I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!
Patricia Tong
Patricia Tong
5 years ago

Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.
alex koh ming
alex koh ming
3 years ago

BEST EXCEL TRAINING
Jacqueline Lee
Jacqueline Lee
2021-09-22

Went for a accounting course, Steven was friendly and helpful
Wenyan Yeo
Guido Sudero
2021-09-01

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
Ken Cheong
THIRUMALA DEVI
2021-09-15

Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.
Josephine Low
Lachu Gandhi
2021-09-07

Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.
shengwei tan
shengwei tan
2021-07-01

Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.
Chiqui Ehong
Grace CH Ong
2021-06-11

A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂