Microsoft Excel Formula & Functions - Advanced

8 Hours: 10am - 6pm
Study Mode
Part Time
Study Type
Start Date
6 Oct, 2021
Buy Course
Be a pro at navigating Microsoft Excel! Deep dive into advanced excel formulae and functions with us.
Upcoming Course Dates
6 Oct, 2021
Starting in 13 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

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
6 Oct, 2021

8 Hours: 10am - 6pm

9 Nov, 2021

8 Hours: 10am - 6pm

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

Complete Reskill Programs: 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 WhatsApp message at 010-5007878. Do take note that our working hours are 9am - 6pm on 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.

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.