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.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

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.

This course includes:

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

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.

This course includes:

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

Course Outline

MO-200 - What you need to get started

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

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

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 hours of training
Access on mobile and browser
Certificate of Completion

Instructor

This course includes:

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

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 hours of training
Access on mobile and browser
Certificate of Completion

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 hours of training
Access on mobile and browser
Certificate of Completion