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
Prerequisites
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
- Lookup & Reference Functions
- Quick Tips in Array Formulas
- Quick Tips in Excel Formulas & Functions