When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Advanced Microsoft Excel for Excel 2016, 2019, and O365
Acquire the skills for Exam MO201
This Course Includes
udemy
4.1 (4 reviews )
7h 30m 
english
Online - Self Paced
professional certificate
Udemy
About Advanced Microsoft Excel for Excel 2016, 2019, and O365
Demonstrate your expert-level skills in Microsoft Excel 2016, 2019, and O365 versions and receive the skills you need to pass the MO201 exam. We provide detailed procedure and covers the objectives of the MO201 exam and give you the skills to become the "Go-To" person among your colleagues. The last lecture of each section includes hands-on exercises to reinforced what you have learned. A review of the previous section materials before the commencement of the current section. Sharpen your skills in:
Pivot Tables
Advanced charts
Master conditional formatting with formulas and manage conditional formatting rules
Understand the management of workbook options and settings
Troubleshoot your formulas and protect your valuable data with cell locking. Learn to use the different troubleshooting techniques including formula evaluation, cell precedence and dependence as well as the Watch Window. Understand the fundamental principles of cell locking
Enhance your skills in using various functions, including the new
MAXIFS()
and
MINIFS()
functions
Conquer VLOOKUP/HLOOKUP functions, and see how the
MATCH()
and the
INDEX()
functions are made easy to understand
Master nested logical functions. Learn a simple technique to break down nested logical function with letter substitutions for complex, wordy conditions/criteria We show you how to create Combo charts to enable you distinguish data series of on the same chart. We explore the new Map Filled Geographic chart type
Learn from an author of Pivot Table and Excel books (the "Get Your Hands Dirty" series)
What You Will Learn?
- Get the advanced skills you need to interpret data for insight .
- Apply custom data formats and validation (With practice tasks) .
- Apply advanced conditional formatting and filtering (with practice tasks) .
- Create and modify custom workbook elements (with practice tasks) .
- Apply functions in formulas (with practice tasks) .
- Lookup data by using functions (with practice tasks) .
- Apply advanced date and time functions (with practice tasks) .
- Perform data analysis and business intelligence (with practice tasks) .
- Troubleshoot formulas (with practice tasks) .
- Define named ranges and objects (with practice tasks) .
- Create advanced charts (with practice tasks) .
- Create and manage pivot tables (with practice tasks) .
- Fill cells based on existing data (with practice tasks) .
- Perform logical operations in formulas (with practice tasks) Show moreShow less.