About This Course
This course is designed for the Advanced Excel user that is comfortable with basic formulas and functions and would like to explore more of the functions that the package has to offer. If you have a good working experience of Excel but wish to get a better hold on formulas and functions, this course is meant for you.
Learning Objectives
By the end of the course, learner will be able to:
- use various Text functions, Date & Time functions, Logical functions, Lookup & Reference functions, Math & Trig functions, and Statistical functions
- create nested functions
Prerequisites
Learners must have at least Intermediate knowledge & skill in Microsoft Excel.
Target Audience
Learners who need to use Excel formulas & functions to create advanced reports and charts for number analysis.
Training Outline
- Getting Started with Excel Formula
- Text Functions
- Date & Time Functions
- Logical Functions
- Lookup & Reference Functions
- Math & Trig Functions
- Statistical Functions