Duration

1 day

Learning Objective

Formulas and functions are the building blocks of working with numeric data in MS Excel. Mastering the essential functions is the key to improve the productivity of effective data reporting.

Delivery Method - VILT

Virtual instructor-led training (VILT) refers to training that is delivered in a virtual environment when instructor and learner are in separate locations. Virtual instruction environments are designed to simulate the traditional classroom or learning experience allowing professionals flexibility of learning at their convenient locations.

Content deliveries are break-down by sessions. Each session will take approximately 45min (with Q&A) follow with short breaks.

Content Outlines

Session 1

Working with Formulas

Concept of Formulas
Understanding Relative and Absolute Cell References
Using Array Formulas
Using 3D References
Q & A

Session 2

Working with Functions (I)

Concept of Functions
Using Logical Function: IF & Nested IF
Using Statistical functions: AVERAGEIF(S), COUNTIF(S), SUMIF(S)
Q & A

Session 3

Working with Functions (II)

Using Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
Using IFERROR Function
Q & A

Session 4

Working with Table

Converting Data in range as a Table
Total the Data in Table
Removing Duplicates from Table
Using Sort and Filter
Optional – Advanced Filter
Q & A

Final Q & A – 15-30min

Programme scope, delivery arrangements and suitability are confirmed during enquiry.