Microsoft Excel 2019

(MO-200.AI3) / ISBN : 978-1-64459-225-0

This course includes

Lessons

TestPrep

Hands-On Labs

Instructor Led (Add-on)

AI Tutor (Add-on)

111 Review

Get A Free Trial

About This Course

Start your prep for the MO-200 exam with the Microsoft Excel 2019 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. The study guide provides hands-on learning on the basic and advanced concepts covered in the Microsoft Excel certification exam.

Skills You’ll Get

The Microsoft Excel 2019 certification validates a candidate's skills in managing worksheets and workbooks; data cells and ranges; and tables, table data, and charts; and performing operations using formulas and functions. The MO-200 exam provides the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.

Get the support you need. Enroll in our Instructor-Led Course.

Get Started

Lessons

25+ Lessons | 288+ Quizzes | 210+ Flashcards | 210+ Glossary of terms

TestPrep

28+ Pre Assessment Questions | 28+ Post Assessment Questions |

Hands-On Labs

50+ LiveLab | 106+ Video tutorials | 01:47+ Hours

Video Lessons

58+ Videos | 05:41+ Hours

Lesson Plan

Introduction

Fundamentals

Module A: Getting around
Module B: Workbook basics
Summary

Creating worksheets

Module A: Entering data
Module B: Formulas
Module C: Functions
Module D: Moving and copying data
Module E: Reference types
Summary

Formatting

Module A: Text formatting
Module B: Number formatting
Module C: Alignment
Module D: Borders and highlighting
Module E: Styles and themes
Summary

Manipulating data

Module A: Data entry shortcuts
Module B: Paste options
Module C: Inserting, deleting, and hiding
Summary

Charts

Module A: Creating charts
Module B: Chart types and elements
Summary

Output

Module A: Managing worksheet windows
Module B: Printing worksheets
Module C: Sharing workbooks
Summary

Settings and templates

Module A: Workbook options and properties
Module B: Templates
Summary

Introduction

Managing workbooks

Module A: Managing worksheets
Module B: Customizing Excel
Summary

Named ranges

Module A: Using names in formulas
Summary

Tables

Module A: Sorting
Module B: Filtering tables
Module C: Structured references
Module D: Validation
Module E: Transposing data
Summary

Summarizing data

Module A: Consolidation
Module B: Subtotals
Summary

PivotTables

Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts
Summary

Presentation features

Module A: Conditional formats
Module B: Custom Formats
Module C: Graphics
Summary

Advanced charts

Module A: Special chart types
Module B: Sparklines
Module C: Quick Analysis
Summary

Collaboration

Module A: Permissions
Module B: Shared workbooks
Summary

Introduction

Logical and Lookup Functions

Module A: Decision-making functions
Module B: Lookup and reference functions
Summary

Advanced Formulas

Module A: Auditing and error-trapping
Module B: Formula options
Module C: Arrays
Summary

Special functions

Module A: Date and time functions
Module B: Text functions
Module C: Other functions
Summary

Importing and Exporting

Module A: The Power Pivot Data Model
Module B: Exporting data
Summary

Analysis

Module A: What-if analysis
Module B: The Analysis Toolpak
Summary

Macros and Forms

Module A: Recording macros
Module B: Running macros
Module C: Forms
Summary

Appendix: Exam Objective MO-201

Exam Objective

Hands-on LAB Activities

Fundamentals

Saving a Workbook

Creating worksheets

Creating a New Workbook
Performing Calculations with Formulas
Entering a Function
Using Relative, Absolute, and Mixed References

Formatting

Changing the Date Format
Formatting Numbers
Merging a Heading
Applying a Theme

Manipulating data

Deleting and Editing the Cell Content

Charts

Creating a Simple Chart
Changing the Chart Color
Changing the Chart Style
Editing a Legend in the Chart
Creating a Column Chart and Switching its Rows and Columns

Output

Splitting a Large Worksheet
Setting Page Margin
Setting and Saving the Print Area
Adding a Header
Saving a Workbook as a PDF File

Settings and templates

Checking Compatibility
Creating a Workbook from a Template

Managing workbooks

Inserting Hyperlink to an Image

Named ranges

Creating Names for Cell Ranges
Editing Names

Tables

Sorting Data
Sorting by Multiple Columns
Filtering Data
Formatting Data as a Table
Creating Formulas Using Structured References

PivotTables

Creating a PivotTable Automatically

Presentation features

Inserting WordArt
Inserting SmartArt

Advanced charts

Customizing Sparklines

Collaboration

Adding Comments
Merging Shared Workbooks

Logical and Lookup Functions

Using the IF Function
Using the SUMIF Function
Using the SUMIFS Function
Using VLOOKUP
Using the MATCH Function

Advanced Formulas

Using an Array Formula
Using an Array Function

Special functions

Performing Calculations Using Date Functions
Performing Simple Time Calculations
Using the Concatenate Function
Calculating the Minimum and Maximum Sales Value

Importing and Exporting

Importing Data from a File
Exporting to a Text File

Macros and Forms

Creating a Blank Form

Microsoft Excel 2019

ISBN: 978-1-64459-225-0
Microsoft MO-200.AI3

Try

Microsoft Excel 2021 Expert

ISBN: 978-1-64459-432-2
uCertify MSEXCEL-EXP.AD1

Try

Microsoft Excel 2021 Intermediate

ISBN: 978-1-64459-409-4
uCertify MSEXCEL-INT.AD1

Try

Microsoft Excel 2021

ISBN: 978-1-64459-382-0
uCertify MSEXCEL.AD1

Try

Microsoft Excel Data Analysis and Business Modeling

ISBN: 978-1-64459-368-4
uCertify XLS-DA-BM.AB1

Try

Microsoft Excel 2019