Dynamic Dashboard with Google Sheets - Advanced

Khor Siew Fei

Experience advanced google sheets formula, dynamic charting, pivot table and create a dashboard by using Google Sheets.

Price

RM560.00

HRDC Claimable

Certificate of Completion

8 Hours

Offline

1 Day: 10am - 6pm

Upcoming Courses

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.

Prerequisites

Knowledge of basic formula, experience with Google Sheets or Excel

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

Certificate of Completion

Will I get a certificate at the end of the course?
Complete Reskill Programs: Absolutely! The certificate will be issued by airasia academy and powered by Google Cloud.
Byte Sized Courses: Yes, we will award you with a certificate for all byte-sized courses with EIGHT (8) learning hours and above. The certificate will be issued by airasia academy and powered by Google Cloud. If you completed less than 8 hours, no certificate will be given.
BINA Digital: Yes, we will award you with a certificate upon full attendance of the programme. The certificate will be issued by airasia academy and powered by Google Cloud.
Can I get a job after attending the course?
The certificate from airasia academy is recognised by the industry which is sufficient to land you a job. But, if you manage to stand out and earn excellent results, our trainers may recommend you to companies within the airasia group and Google Cloud ecosystem, or to their extensive network of businesses. That means you will have a good shot kickstarting a new career!
Who can I refer to get more insight of the courses?
You may drop us a WhatsApp message at 010-5008787. Kindly take note that our working hours are 9 am - 6 pm from Monday to Friday and our friendly team will reply to you as soon as we can. However, do expect a slight delay in reply in enquiries over the weekend. Or you can follow our social media accounts @airasiaacademy (Facebook, Instagram, Linkedin)
What payment methods do you accept?
We currently accept debit card and credit card. We're also happy to announce that we now have interest-free* instalment plans!
*Interest-Free Instalment plans are currently available for ILT courses only, and applies to Maybank and Public Bank credit card holders, with a minimum purchase of RM500 and above.
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.
What is the difference between RCOC-B and RCOC-EVLOS Module 1?
The Remote Pilot Certificate of Competency - Basic (RCoC-B) satisfies the requirements within the Specific category (medium risk category). The RCoC-B satisfies the competency requirements of a published *PDRA or *STS that involves *VLOS flights. The following operations usually falls within the specific category:
- Agriculture
- Flying the drone above 400ft
- Flying Beyond Visual Line of Sight (BVLOS)
- Pre-Defined Risk Assessment (PDRA)
- Standard Scenario (STS)
- Visual Line of Sight (VLOS)
The Remote Pilot Certificate of Competency Extended Visual Line of Sight Module 1 (RCoC (EVLOS) Module 1) is an additional module which enables Extended Visual Line of Sight operations. The prerequisite for attending Module 1 is RCoC-B which will imply that all Remote Pilots are required to be competent on RCoC-B before attending the Module 1 course.

Meet your instructor

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.

Price