Microsoft Excel Formulas and Functions

Home > Courses > Microsoft Excel Formulas and Functions

Course Overview

Upon completion of this program, candidates should be able to:

Create formulas and use built in functions in MS Excel.
Use “What if Analysis” tool to automate tasks in spreadsheet.
Build report and charts using Pivot Table tool.

Who Should Attend?

This course takes users to a high level of knowledge using functions available in Excel.

Pre-requisite

Delegates should have an understanding of the Windows operating system. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Essentials course.

Module 1: Advanced Functions

Creating and Using Functions
Using Built-in Functions
- Using PMT and FV
- Using IF, AND, and OR
- Using VLOOKUP and HLOOKUP

Module 2: What If Analysis

Module 3: Charting Data

Module 4: Summarizing Data

Not Available

Course Detail

Calendar 2025

15-16 Jan

19-20 Feb

12-13 Mar

16-17 Apr

15-16 May

11-12 Jun

9-10 Jul

13-14 Aug

10-11 Sep

8-9 Oct

12-13 Nov

8-9 Dec

Have Any Question?

If you need further information about this course, please contact: