Microsoft Excel 2021 (Intermediate)

Module 1: Working with Formulas

Concept of Formulas

Understanding Relative and Absolute Cell References

Understanding Named Ranges

Defining Named Ranges

Editing Named Ranges

Deleting Named Ranges

Using Named Ranges in Formulas

Using Array Formulas

Using 3D References

Module 2: Working with Functions

Concept of Functions

Using Advanced Functions

Using Logical Function: IF

Using Logical Function: AND

Using Logical Function: OR

Using Logical Function: IFS, SWITCH

Module 3: Dynamic Arrays Functions

Excel Dynamic Arrays

UNIQUE Function

SEQUENCE Function

SORT Function

SORTBY Function

FILTER Function

XLOOKUP Function

LET Function

Course Outline :: EXC21I ::

Module 4: Auditing Worksheets

Tracing Formula Precedents and Dependents

Showing Formulas

Evaluating Formulas

Using Error Option Buttons

Running an Error Check

Module 5: Working with Table

Converting Data in range as a Table

Total the Data in Table

Removing Duplicates from Table

Using Sort and Filter

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