Udemy MOOC / Non-credit 0

Advanced Microsoft Excel for Excel 2016, 2019, and O365

Name: Advanced Microsoft Excel for Excel 2016, 2019, and O365
Price: 169.99 USD
Availability: InStock

About this course

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 TablesAdvanced chartsMaster conditional formatting with formulas and manage conditional formatting rulesUnderstand the management of workbook options and settingsTroubleshoot 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 lockingEnhance your skills in using various functions, including the new MAXIFS() and MINIFS() functionsConquer VLOOKUP/HLOOKUP functions, and see how the MATCH() and the INDEX() functions are made easy to understandMaster nested logical functions. Learn a simple technique to break down nested logical function with letter substitutions for complex, wordy conditions/criteriaWe 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 typeLearn from an author of Pivot Table and Excel books (the "Get Your Hands Dirty" series)

62/100

CourseAsk score

What the provider tells you: 38/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

mastering Pivot Tables
creating advanced charts
applying conditional formatting with formulas
managing workbook options
troubleshooting formulas
using new Excel functions like MAXIFS and MINIFS
navigating VLOOKUP and HLOOKUP
creating Combo charts

Data Analysis #vlookup #pivot tables #microsoft excel #conditional formatting #data protection #hlookup #nested functions #maxifs #minifs #combo charts

$169.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.