Advanced Microsoft Excel Formula & Functions

Khor Siew Fei

Learn how to THINK like Excel to create dynamic and powerful Excel formulas. Be a pro at navigating Microsoft Excel and Google Sheets. ...

Price
RM560.00
HRDC Claimable

Upskill
Part Time
Online
8 Hours: 10am - 6pm
Upcoming Courses
Who Should Attend This Course?

Whether you are a beginner or dream to become an absolute Excel power user, you have come to the right place. Everyone can benefit from learning Excel, from university students to working people, or just anyone hoping to boost their analytics skillset, work efficiently with data, and take their career to the next level.

Learning Excel is one of the most beneficial and powerful skills to have because you will have the ability to analyse data more efficiently and gets your job done faster. That also means businesses are able to move and grow faster too.

Nowadays, having the knowledge of Excel has become one of the most sought after skills when it comes to hiring. You will definitely stand out from other candidates if you do have advanced knowledge of Excel.

Why Do You Need To Join This Course?

Excel is not just for creating tables, it gets your job done faster. Advanced Excel skills enable you and your team to create professional-looking spreadsheets. When you have a deeper understanding of Excel, you will be able to use its more complex tools, which will allow you to complete your tasks and analyse data more rapidly.

Did you know that Excel can do all of the following?

  • Organise data in an easy-to-navigate way
  • Do basic and complex mathematical functions so you don’t have to count yourself
  • Turn piles of data into helpful graphics and charts
  • Analyse data and make forecasting predictions
  • Create, build, and edit pixelated images (creatives use it, too!)

Excel's numerous tools and functionalities are designed to save you time in addition to organising data. Instead of manually adding up 137 columns of monthly spending, Excel does everything for you, and you know it is 100% accurate.

Having an understanding of Excel can instantly improve your career prospects and your starting salary. Any hiring manager realises the importance of Excel as a transferable skill. The benefit of understanding such universal computer software is that it provides you with all the possibilities.

This course is a full-day, hands-on practical experience course with case studies to go through advanced Excel formulas and functions. You will be taken into how to utilise functions like index/match, VLOOKUP, linking multiple excel and array formulas. This course is designed to equip you to handle Excel like a pro.

There are so many things that can be accomplished with Excel and it is definitely one skill that you must have.

Prerequisites

In order to join this course, you will need to have knowledge of basic Excel formulas and have previous experience with Google Sheets or Microsoft Excel as this is an advanced class. If you are looking for beginner classes, we have Google Workspace (GSuites) Office Productivity Tools & Data Studio Basics or VLOOKUP for Beginner - Excel & Google Sheets.

General Program

In this course, you will learn:

  • Vlookup / hlookup
  • Index match
  • sumproduct
  • Sumif, Sumifs, Countifs
  • Arrayformula
  • Filter
  • Remove duplicates
  • Web Scraping with Werservice & Filterxml
  • if/ifs
Certificate

You will earn a Certificate of Completion endorsed by airasia academy and authorised by Google upon completing this course. Refer to our FAQ below for more details.

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

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