Microsoft Excel 2019

This Course Includes:

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.

What will you 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 1: Introduction

Lessons 2: Fundamentals

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

Lessons 3: Creating worksheets

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

Lessons 4: Formatting

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

Lessons 5: Manipulating data

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

Lessons 6: Charts

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

Lessons 7: Output

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

Lessons 8: Settings and templates

  • Module A: Workbook options and properties

Lessons 9: Introduction

Lessons 10: Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customising Excel

Lessons 11: Named ranges

  • Module A: Using names in formulas

Lessons 12: Tables

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

Lessons 13: Summarising data

  • Module A: Consolidation
  • Module B: Subtotals

Lessons 14: PivotTables

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

Lessons 15: Presentation features

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

Lessons 16: Advanced charts

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

Lessons 17: Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks

Lessons 18: Introduction

Lessons 19: Logical and Lookup Functions

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

Lessons 20: Advanced Formulas

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

Lessons 21: Special functions

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

Lessons 22: Importing and Exporting

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

Lessons 23: Analysis

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

Lessons 24: Macros and Forms

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

Appendix: Exam Objective MO-201

  • Exam Objective

Hands-on LAB Activities


  • Saving a Workbook

Creating worksheets

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


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

Manipulating data

  • Manipulating data Deleting and Editing the Cell Content


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


  • 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

Managing workbooks

  • Inserting Hyperlink to an Image

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names


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


  • Creating a PivotTable Automatically

Presentation features

  • Inserting WordArt
  • Inserting SmartArt

Advanced charts

  • Customising Sparklines


  • 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




25+ Lessons

Delivery Method:




Scroll to Top