Microsoft Excel 2019

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

This course includes
Lessons
TestPrep
Hand-on Lab
Instructor Led (Add-on)
AI Tutor (Add-on)

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.

Here's what you will 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.

Lessons

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

TestPrep

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

Hand on lab

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

Video Lessons

58+ Videos | 05:41+ Hours

Here's what you will learn

Download Course Outline

Lessons 1: Introduction

Lessons 2: Fundamentals

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

Lessons 3: Creating worksheets

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

Lessons 4: Formatting

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

Lessons 5: Manipulating data

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

Lessons 6: Charts

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

Lessons 7: Output

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

Lessons 8: Settings and templates

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

Lessons 9: Introduction

Lessons 10: Managing workbooks

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

Lessons 11: Named ranges

  • Module A: Using names in formulas
  • Summary

Lessons 12: Tables

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

Lessons 13: Summarizing data

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

Lessons 14: PivotTables

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

Lessons 15: Presentation features

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

Lessons 16: Advanced charts

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

Lessons 17: Collaboration

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

Lessons 18: Introduction

Lessons 19: Logical and Lookup Functions

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

Lessons 20: Advanced Formulas

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

Lessons 21: Special functions

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

Lessons 22: Importing and Exporting

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

Lessons 23: Analysis

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

Lessons 24: 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

Exam FAQs

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