Ace the MO-200 Exam: Your 3-Week Excel (Office 2019) Associate Prep Plan

The Microsoft Office Specialist (MOS) Excel Associate (MO-200) certification is a fantastic way to validate your core skills in Microsoft Excel. Passing this exam proves you can confidently manage worksheets, workbooks, data cells, ranges, tables, and perform essential calculations and data visualisations.

Ready to conquer the exam? We've structured a focused 3-week preparation plan that systematically tackles every objective, ensuring you hit that 700-point threshold!

The MO-200 Exam: Skills Measured Overview

The exam objectives are divided into five main domains, which form the backbone of your study plan:

1. Manage worksheets and workbooks

• Weight: 10-15%
• Key focus: Data import, navigation, formatting, and configuration for collaboration/printing.

2. Manage data cells and ranges

• Weight: 20-25%
• Key focus: Manipulating data (paste options, AutoFill), cell/range formatting, named ranges, and visual summaries (Sparklines, Conditional Formatting).

3. Manage tables and table data

• Weight: 15-20%
• Key focus: Creating, formatting, modifying, filtering, and sorting Excel tables.

4. Perform operations by using formulas and functions

• Weight: 20-25%
• Key focus: Using relative, absolute, and mixed references; performing calculations (AVERAGE, SUM, IF); and text manipulation (RIGHT, CONCAT).

5. Manage charts

• Weight: 20-25%
• Key focus: Creating, modifying, and formatting various chart types.

Your 3-Week MO-200 Study Roadmap

Focus on establishing a solid foundation in workbook management, cell manipulation, and mastering Excel Tables.

• Day 1: Workbook Navigation & Setup
  MO-200 Objectives Covered: Manage worksheets and workbooks (Navigation, Custom Options/Views).
• Day 2: Import & Formatting
  MO-200 Objectives Covered: Manage worksheets and workbooks (Import Data, Format).
• Day 3: Collaboration & Printing
  MO-200 Objectives Covered: Manage worksheets and workbooks (Configure content for collaboration).
• Day 4: Data Manipulation & Formatting
  MO-200 Objectives Covered: Manage data cells and ranges (Manipulate data, Format cells and ranges).
• Day 5: Advanced Cell Formatting
  MO-200 Objectives Covered: Manage data cells and ranges (Format cells and ranges).
• Day 6: Named Ranges & Visual Summary
  MO-200 Objectives Covered: Manage data cells and ranges (Define and reference named ranges, Summarise data visually).
• Day 7: Review & Practice
  All objectives covered in week 1

Week 2: Formulas, Functions, and Advanced Data Skills

This week is crucial for mastering the calculation and logic skills that make up a significant portion of the exam.

• Day 8: Table Creation & Modification
  MO-200 Objectives Covered: Manage tables and table data (Create and format tables, Modify tables).
• Day 9: Table Filtering & Sorting
  MO-200 Objectives Covered: Manage tables and table data (Filter and sort table data).
• Day 10: References
  MO-200 Objectives Covered: Perform operations by using formulas and functions (Insert references).
• Day 11: Core Calculation Functions
  MO-200 Objectives Covered: Perform operations by using formulas and functions (Calculate and transform data).
• Day 12: Counting and Logic
  MO-200 Objectives Covered: Perform operations by using formulas and functions (Calculate and transform data).
• Day 13: Text Functions
  MO-200 Objectives Covered: Perform operations by using formulas and functions (Format and modify text).
• Day 14: Review & Practice
  All objectives covered in week 2

Week 3: Chart Mastery and Final Polish

The final week is dedicated to data visualisation and comprehensive review before the exam.

• Day 15: Chart Creation
  MO-200 Objectives Covered: Manage charts (Create charts).
• Day 16: Chart Modification
  MO-200 Objectives Covered: Manage charts (Modify charts).
• Day 17: Chart Formatting
  MO-200 Objectives Covered: Manage charts (Format charts).
• Day 18: Full Review
  Focus: weak areas
• Day 19: Full Practice Exam
  All objectives
• Day 20: Analyse and Refine
  All objectives
• Day 21: Full Practice Exam
  All objectives

Good luck with your preparation! By following this systematic 3-week plan and dedicating time to hands-on practice within Excel, you will be well-equipped to achieve your MO-200 certification.

Want more Excel practice?

Spuddle is building a Duolingo-style app that teaches Excel the fun way. If you want to be the first to try it (and grab our free Excel shortcut cheat sheet), join the waitlist here: spuddleapp.com