VLOOKUP for Beginner - Excel & Google Sheets

Khor Siew Fei

Deep dive into how to navigate and use VLOOKUP function for both Microsoft Excel and Google Sheets...

Price
RM280.00
HRDC Non-Claimable

Upskill
Part Time
Online
4 Hours Daily: 2pm - 6pm
Upcoming Courses
What to Expect

In this course, participants will be able to:

  • Cross reference data using VLOOKUP in Excel
  • Understand how to troubleshoot VLOOKUP
  • How to do approximate vs exact matches in VLOOKUP
  • How to do Wildcard matches in VLOOKUP
  • How to use Named Ranges in VLOOKUP
  • How to use VLOOKUP in Google Sheets
Who Should Attend This Course

Anyone who wants to master VLOOKUP in both Excel and Google Sheets

Prerequisites

English Language proficiency

General Program
  • Concept of VLOOKUP
  • When and How to Use VLOOKUP
  • Mastering VLOOKUP in Excel and Google Sheets
  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.

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
RM280.00
HRDC Non-Claimable

Upskill
Part Time
Online
4 Hours Daily: 2pm - 6pm