Microsoft Excel Formula & Functions - Advanced

8 Hours
Study Mode
Part Time
Study Type
Start Date
2 Sept, 2021
RM 560
Buy Course
Upcoming Course Dates
22 July, 2021
Starting in 40 days
2 Sept, 2021
Starting in 82 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

A full-day, hands-on practical experience course, with case studies to go thru advanced Excel formula and functions. A deep dive session into how to utilize function like index/match, vlookup, linking multiple excel and array formula, this course is designed to equip you to handle Excel like a pro.

Who Should Attend This Course

Anyone who wants to master formulas in Microsoft Excel

  • Knowledge of basic formula
  • Have previous experience with Google Sheets or Microsoft Excel
Course Outline
General Program
  • Vlookup / hlookup
  • Index match
  • sumproduct
  • Sumif, Sumifs, Countifs
  • Arrayformula
  • Filter
  • Remove duplicates
  • Web Scraping with Werservice & Filterxml
  • if/ifs

Certificate of Completion

Course Dates & Schedule
22 July, 2021

8 Hours

2 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 30th of June 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