MOS Excel Associate Certification MO-200: Master Concepts

About MOS Excel Associate Certification MO-200: Master Concepts

This course provides an overview of the MOS Excel Associate exam and covers the fundamentals of creating and managing worksheets as listed in the exam requirements. The course includes tips on how to do well on the test. Finally, the test includes exercises for each topic + test exercises that follow the pattern of questions asked in the MOS Excel  Associate exam.

Microsoft provides everyone who scores 70% on the exam with the MOS Associate Excel, or Microsoft Office Specialist Associate Excel certification. This certification demonstrates your proficiency in Excel to your employer or potential employer and is a great asset in your work, career, and salary potential. All the best.

Become a Microsoft Office Specialist and Enhance Your Career

Use your knowledge to obtain certified status

Understand the MO-200 Exam

Learn how to correctly prepare for the test

Get advice from a seasoned professional who knows how to pass the exam

You will learn how to:

Manage worksheets and workbooks (10-15%)

Import data into workbooks

Navigate within workbooks

Format worksheets and workbooks

Customize options and views

Configure content for collaboration

Manage data cells and ranges (20-25%)

Manipulate data in worksheets

Format cells and ranges

Define and reference named ranges

Summarize data visually

Manage tables and table data (15-20%)

Create and format tables

Modify tables

Filter and sort table data

Perform operations by using formulas and functions (20-25%)

Insert references

Calculate and transform data

Format and modify text

Manage charts (20-25%)

Create charts

Modify charts

Format charts