MO-200: Microsoft Office Specialist Excel Review

The MO-200 Microsoft Office Specialist Excel course teaches essential skills for using Excel. Learn to create and format worksheets, manage data, create charts and graphs, and analyze data.

Free Community Plan View Pricing Plans

Course Info
Instructor
System Requirements
What to know beforehand

Course Description

The MO-200 Microsoft Office Specialist Excel 2019 course is designed to equip participants with the essential skills and knowledge needed to succeed in using Microsoft Excel 2019. Through comprehensive instruction and hands-on exercises, participants will learn key concepts such as creating and formatting worksheets, managing data using formulas and functions, creating charts and graphs for data visualization, and analyzing data to make informed decisions. Gain the confidence and knowledge you need to conquer the Microsoft Office Specialist Excel 2019 Associate certification and unlock countless opportunities in the competitive world of business and beyond.

Course Outline ( Free Preview)

MO-200 - What you need to get started

Module 00 - How to prep for the MO-200 certification test

Module 01 - What to expect on test day, Table formatting and Auto-Fill (Tasks 01 - 02)

Module 02 - Import .txt file and Freeze top rows (Tasks 03 - 08) 17 min.

Module 03 - Multi-sort, RIGHT, LEFT, and MID functions (Tasks 09 - 11) 10 min.

Module 04 - Formatting cells and tables + Format painter (Tasks 12 - 17) 10 min.

Module 05 - Formulas and Conditional Formatting (Tasks 18 - 29) 28 min.

Module 06 - Charts and Sparklines (Tasks 30 - 34 + Bonus Task) 19 min.

This course includes:

1+ hours of training
8 Modules
* Access on mobile and browser
Certificate of Completion

Free Community Plan View Pricing

Instructor

This course includes:

1+ hours of training
8 Modules
* Access on mobile and browser
Certificate of Completion

Free Community Plan View Pricing

System Requirements

To take the MO-200 Microsoft Office Specialist Excel 2019 course, you need access to a computer with internet connectivity and Microsoft Excel 2019 installed.

This course includes:

1+ hours of training
8 Modules
* Access on mobile and browser
Certificate of Completion

Free Community Plan View Pricing

What to know before class

**Video Exam Tutorial from test provider:** [How to take your Microsoft Office Exam](https://vimeo.com/504832659) **Study Guide and Skills Measured:** [Skills Measured](https://pragmaticworksonline.sharepoint.com/:b:/s/FileShare/EQfXyIqNJAhCn-qKyR4bBD4B9JVECi1UO7b9cJ3OrkVEOw?e=M0o6zr&download=1) **Additional Information:** You may be eligible for ACE college credit if you pass this certification exam. [Click here](https://learn.microsoft.com/en-us/credentials/certifications/college-credit) for details. To schedule your exam please visit [Microsoft Learn](https://learn.microsoft.com/en-us/credentials/certifications/exams/mo-200/).

This course includes:

1+ hours of training
8 Modules
* Access on mobile and browser
Certificate of Completion

Free Community Plan View Pricing