How to Go from Zero IT Background to MO-200 Microsoft Excel Associate

19/05/2026

The world runs on data, and the software that organises and analyses that data is often Microsoft Excel. Whether you're aiming for a career change, looking to boost your current job performance, or simply wanting to add a valuable, verifiable skill to your resume, achieving the Microsoft Office Specialist (MOS): Excel Associate (MO-200) certification is a fantastic goal.

If you're starting with a "zero IT background", meaning you might not have used spreadsheets much before, or perhaps only for basic lists, this guide is for you. Becoming MO-200 proficient is completely achievable with the right roadmap, dedication, and practice.

What is the Microsoft Office Specialist (MOS): Excel Associate (MO-200) exam?

The MO-200 exam validates your competency in the core features of Microsoft Excel. It proves you can create and maintain professional-grade workbooks for various business purposes.

Skills

  • Manage Worksheets and Workbooks: Importing data, navigating, formatting, and setting up printing.

  • Manage Data Cells and Ranges: Formatting data, using find/replace, and naming ranges.

  • Manage Tables and Table Data: Creating, formatting, and filtering/sorting Excel Tables.

  • Perform Operations by using Formulas and Functions: Using basic arithmetic, cell references, and fundamental functions like SUM, AVERAGE, MIN, MAX, and COUNT.

  • Manage Charts: Creating, modifying, and formatting various chart types.

Phase 1: Building the Foundation (The Basics)

Before tackling the MO-200 specific objectives, you need to be comfortable just being in Excel.

Step 1: Get Access and Get Familiar

If you don't already have it, install Microsoft 365 (which includes Excel).

  • Explore the Interface: Spend time opening Excel and simply clicking around. Identify the Ribbon, tabs (Home, Insert, Data, etc.), the Formula Bar, and the Name Box.

  • Understand Cells, Rows, and Columns: The fundamental structure of a spreadsheet. Practice selecting cells, ranges, and entire rows/columns.

  • Basic Data Entry: Practice entering different types of data: text, numbers, and dates. Understand the difference between values and formulas.

Step 2: Essential File Management

These skills are crucial for the "Manage Worksheets and Workbooks" domain.

  • Saving and Opening: Know the different file formats (e.g., .xlsx vs. .csv).

  • Navigation: Practice moving between sheets, zooming in/out, and freezing panes.

  • Formatting Basics: Change font, size, apply borders, fill colors, and use Wrap Text and Merge & Center.

Phase 2: Core Skills for MO-200 (The Content)

Now you'll dive into the heart of the exam content.

Step 3: Mastering Formulas and Functions

This is often the biggest hurdle for beginners, but it's simpler than you think!

  • The Equal Sign (=): Everything starts with an equals sign.

  • Basic Math: Practice adding (+), subtracting (-), multiplying (*), and dividing (/).

  • Key Functions: Dedicate time to understanding and using: SUM(), AVERAGE(), COUNT(), MIN(), and MAX().

  • Relative vs. Absolute References: Understand why and when to use the dollar sign ($) to lock a cell reference (e.g., $A$1). This is a critical exam topic!

Step 4: Data Organisation with Tables

Excel Tables (different from just typing data) are a powerhouse feature.

  • Create a Table: Learn how to select a range and convert it into a properly formatted Excel Table (Insert > Table).
  • Sorting and Filtering: Practice using the built-in drop-down arrows to sort data (A-Z, Z-A) and filter based on criteria.
  • Table Styles: Apply professional formatting quickly.

Step 5: Visualising Data with Charts

Effective data visualisation is a key skill.

  • Selection is Key: Learn to select the right data range before inserting a chart.

  • Chart Types: Know when to use a Bar Chart (for comparisons), a Line Chart (for trends over time), and a Pie Chart (for parts of a whole).

  • Modification: Practice adding/removing chart elements (titles, data labels, legend) and switching the Row/Column data.

Phase 3: Certification Preparation (The Test)

You've built the skills; now it's time to conquer the exam format.

Step 6: Utilise Study Resources

A structured approach is non-negotiable for success.

  • Official MOS Practice Tests: Resources like GMetrix or MeasureUp simulate the exam environment and are invaluable for timing and format familiarity.

  • Video Tutorials: Use platforms like LinkedIn Learning, Coursera, or YouTube channels that specifically cover the MO-200 objectives.

  • Create Your Own Projects: The best way to learn is by doing. Build a personal budget, a recipe inventory, or a simple task tracker using the skills you've learned.

Step 7: The "Test" Environment

The MOS exam is performance-based, meaning you are given a set of tasks and must perform them within the live Excel application.

  • Practice Speed and Accuracy: Time yourself on tasks. The exam is often less about complicated calculations and more about knowing exactly where to click to execute a function quickly.

  • Review All Objectives: Go through the official MO-200 exam objectives list and check off every single item. If you can perform the task blindfolded, you're ready.

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

Share