Dynamic Dashboard with Google Sheets - Advanced

8 Hours
Study Mode
Part Time
Study Type
Start Date
5 Aug, 2021
RM 280
Buy Course
Experience advanced google sheets formula, dynamic charting, pivot table and create a dashboard by using Google Sheets.
Upcoming Course Dates
5 Aug, 2021
Starting in 3 days
Khor Siew Fei
Siew Fei is the Google Workspace (formerly known as GSuite) trainer with Redbeat Academy. With 10 years of experience in Airasia with ICT background as well as Google Project Manager, he has transformed Airasia's office productivity environment into the Google environment. His expertise lies in change management, focused around operations and training for the Airasia Group's digital transformation. Today, he is the Microsoft and Google productivity tool expert and he is always ready to share his knowledge through his hands-on sessions.
Course Details
What to Expect

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. It’s features include charts, pivot tables, linking between multiples sheets to achieve data needs of every sector of industry.

This one day hands on practical program allows you to experience with advanced google sheets formula, dynamic charting with Google Sheets, pivot table and at the end of the session, you will be able to walk away with the skills and knowledge to create a dashboard by using Google Sheets.

In this class, you will have a hands-on experience with Google Sheets advanced formula, charts, pivot tables and dashboard creation with Google Sheets.

Who Should Attend This Course

Anyone who who is looking for an alternative spreadsheet from Excel, interested and required a dashboard creation.


Knowledge of basic formula, experience with Google Sheets or Excel

Course Outline
General Program

Morning Session (Advanced Formula):

  • Vlookup
  • Importrange
  • Importhtml
  • Sumif, Sumifs, Countifs
  • Query
  • Google Finance
  • Filter
  • Remove duplicates
  • Charting
  • Pivot Table
  • Slicer

Afternoon Session:

  • Live Dashboard creation with sample data

Certificate of Completion

Course Dates & Schedule
5 Aug, 2021

8 Hours

8 Sept, 2021

8 Hours

Will I get a certificate at the end of the course?

Long Tracks: Yes, you will! The certificate will be issued by Redbeat Academy and endorsed by Google Cloud.

Byte Sized Courses: Yes, we will award you with a certificate for all byte sized courses with ten (10) learning hours and above. The certificate will be issued by Redbeat Academy and endorsed by Google Cloud.

BINA Digital: Yes, we will award you with a certificate upon full attendance of the program. The certificate will be issued by Redbeat Academy and endorsed by Google Cloud.

Can I get a job after the course?

Your certificate is recognised by the industry which is sufficient to land you a job. If you stand out, our trainers may recommend you to companies within the airasia and Google Cloud ecosystem, or their extensive network of businesses.

Who can I refer to get more insight on the courses?

You may drop us a message at Contact page. Our team will reply to you as soon as we can. Our working hours are 9am - 6pm on Monday to Fridays therefore do expect a slight delay in reply over the weekend.

What payment methods do you accept?

Currently, we accept online bank transfer & credit card payment.

Do you offer any free learning resources?

Yes, we do! Kindly refer to the Resources page. We have conducted free introductory sessions via our YouTube channel where you can watch it anytime and anywhere.

Can I apply the 30% discount I obtained during sign up for this course?

Yes you can! The promo code is applicable to all courses with a start date. To enjoy the discount, simply apply the promo code, RBABEST30 and check out! Do note that the promo code can be used multiple times on any of our available courses on our platform. This promo code is valid until the 31st of July 2021.

One-stop tech, leadership and innovation academy aiming to be the primary catalyst to leverage people in the digital economy within the ASEAN region. Redbeat Academy is supported by airasia Digital and Google Cloud.

© Redbeat Academy