2022 Academy Intake On-going. Learn more

Essential Formulas & Functions In Excel (Level 1)

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

  1. Getting Started with Excel Formula
  2. Text Functions
  3. Date & Time Functions
  4. Logical Functions
  5. Lookup & Reference Functions
  6. Math & Trig Functions
  7. Statistical Functions