Microsoft Excel 2019

(MO-200.AI3) / ISBN : 978-1-64459-225-0
This course includes
Interactive Lessons
Gamified TestPrep
Hands-On Labs
Instructor Led (Add-on)
AI Tutor (Add-on)
111 Reviews
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.

1

Introduction

2

Fundamentals

  • Module A: Getting around
  • Module B: Workbook basics
  • Summary
3

Creating worksheets

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

Formatting

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

Manipulating data

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

Charts

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

Output

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

Settings and templates

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

Introduction

10

Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customizing Excel
  • Summary
11

Named ranges

  • Module A: Using names in formulas
  • Summary
12

Tables

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

Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals
  • Summary
14

PivotTables

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

Presentation features

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

Advanced charts

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

Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks
  • Summary
18

Introduction

19

Logical and Lookup Functions

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

Advanced Formulas

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

Special functions

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

Importing and Exporting

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

Analysis

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

Macros and Forms

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

Appendix: Exam Objective MO-201

  • Exam Objective

1

Fundamentals

  • Saving a Workbook
2

Creating worksheets

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

Formatting

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

Manipulating data

  • Deleting and Editing the Cell Content
5

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
6

Output

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

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template
8

Managing workbooks

  • Inserting Hyperlink to an Image
9

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names
10

Tables

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

PivotTables

  • Creating a PivotTable Automatically
12

Presentation features

  • Inserting WordArt
  • Inserting SmartArt
13

Advanced charts

  • Customizing Sparklines
14

Collaboration

  • Adding Comments
  • Merging Shared Workbooks
15

Logical and Lookup Functions

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

Advanced Formulas

  • Using an Array Formula
  • Using an Array Function
17

Special functions

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

Importing and Exporting

  • Importing Data from a File
  • Exporting to a Text File
19

Macros and Forms

  • Creating a Blank Form

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

There are no technical prerequisites for the certification exam.

USD 100

The exam consists of performance based questions and is conducted in a live or simulated environment. 

The exam contains 40-60 questions.

90 minutes

The passing score varies from exam to exam and is provided on the score report.

Microsoft Office Specialist (MOS) exam retake policy

  1. If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.

For life

Microsoft Excel 2019

$ 279.99

Buy Now

Related Courses

All Course
scroll to top