EXC19I/EXC0365I: Microsoft Excel 2019 / O365 Intermediate

Course Information

Course Name

EXC19I/EXC0365I: Microsoft Excel 2019 / O365 Intermediate

Exam code

MO-200

Duration

1 Day

Certification

Microsoft Office 2019 OR O365

Overview

This Intermediate Microsoft Excel training class is designed for students to gain the skills necessary to work with formulas, functions, worksheets and tables.

Audience Profile

This training is suitable for intermediate of Excel 2019 user and is recommended for user to already have the basic knowledge of Excel 2019 usage.

Prerequisities

At Course Completion

Course Outline

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

Module 2: Working with Functions (I)

• 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: Working with Functions (II)

• Using Statistical functions: AVERAGEIF, COUNTIF

• Using Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP

• Using Text functions: TEXTJOIN, CONCAT

• Using Statistical Functions: MAXIFS and MINIFS

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

All Microsoft certification courses are conducted by certified trainers from Iverson.

Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.