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

Upskill
Part Time
Online
8 Hours: 10am - 6pm
Upcoming Courses
Start Date
27 Oct 2022
Buy now
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

  1. 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.

  2. 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!

  3. 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)

  4. 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.

  5. 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.

  6. 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
RM560.00
HRDC Claimable

Upskill
Part Time
Online
8 Hours: 10am - 6pm