Dynamic Dashboard with Google Sheets - Advanced

8 Hours
Study Mode
Part Time
Study Type
Start Date
28 May, 2021
RM 560
Buy Course
Experience advanced google sheets formula, dynamic charting, pivot table and create a dashboard by using Google Sheets.
Upcoming Course Dates
28 May, 2021
Starting in 14 days
Khor Siew Fei
Siew Fei is the Google Workplace (formally known as GSuites) trainer with RBA, With 10 years of experience in Airasia with ICT backgrounds, Google Project Manager, he transformed Airasia's office productivity environment into the Google environment. His expertise lie in change management, focused around operation and training for the Airasia group's digital transformation.
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
28 May, 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.

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