Cart 0
Training
Certificate
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
Overview
Audience Profile
Prerequisities
At Course Completion
Course Outline
Overview
This Intermediate Microsoft Excel training class is designed for students to gain the skills necessary to work with formulas, functions, worksheets and tables.
Overview
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
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
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
Related Courses
You might also being interested in this course
Others
WOR19I/WOR0365I: Microsoft Word 2019 / O365 Intermediate
- RM420.00 exc. 8% tax
- 1 Day
Others
PPT19A/PPT0365A: Microsoft PowerPoint 2019 / O365 advanced
- RM420.00 exc. 8% tax
- 1 Day
Others
PPT19I/PPT0365I: Microsoft PowerPoint 2019 / O365 intermediate
- RM420.00 exc. 8% tax
- 1 Day
Others
EXC19A/EXC0365A: Microsoft Excel 2019 / O365 Advanced
- RM420.00 exc. 8% tax
- 1 Day