2024 Intake On-Going. Click to learn more.

Essential Formulas & Functions In Excel (Level 2)

About This Course

This course is designed to take you beyond the Advanced Level in Excel Formulas & Functions. Basically, those are the commonly used techniques to calculate complicated formulas in working environment.


Learning Objectives

By the end of the course, learner will be able to:

  • create nested formulas for complicated calculation
  • use wildcards for text filtering in formulas


Learners must have completed the Essential Formulas & Function in Excel (Level 1)


Target Audience

This course is designed for advanced Microsoft Excel users who wants to explore more of the functions in Excel in order to create a report with the correct and faster calculation method.


Training Outline

  1. Lookup & Reference Functions
  2. Quick Tips in Array Formulas
  3. Quick Tips in Excel Formulas & Functions