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.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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.

1

  • Introduction

  • 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

  • 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

  • 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
25

  • Appendix:

  • Exam Objective MO-201

Audience

This course is for those looking to improve their Excel skills.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...