MO-210 vs MO-211: which Excel exam should you take?
MO-210 is the Associate exam and MO-211 is the Expert one. Both run 50 minutes and are scored out of 1000, so the difference is not the format — it is where the marks sit. MO-210 puts most of its weight on managing workbooks and ranges; MO-211 shifts it to data management, advanced formulas and macros. Most people take MO-210 first, but it is not a prerequisite.
Checked against Microsoft’s own published pages on August 27, 2026.
The numbers
Same format, different centre of gravity
Both exams are 50 minutes of performance-based tasks in a live Excel workbook, scored out of 1000. Nobody taking one after the other would notice a change in how the exam behaves. What changes is the distribution of marks.
MO-210 splits across five domains: Manage Worksheets and Workbooks (25–30%), Manage Data Cells and Ranges (25–30%), Manage Tables and Table Data (10–15%), Perform Operations by using Formulas and Functions (15–20%), and Manage Charts (15–20%).
MO-211 uses four: Manage Workbook Options and Settings (10–15%), Manage and Format Data (30–35%), Create Advanced Formulas and Macros (25–30%), and Manage Advanced Charts and Tables (25–30%).
The shift is visible at a glance. Basic workbook housekeeping drops from the heaviest domain on the Associate exam to the lightest on the Expert one, while formula work roughly doubles in weight and gains macros alongside it.
What MO-211 actually adds
Macros are the addition that surprises people. MO-211 expects you to record, name and edit simple macros. Deep VBA programming is not the focus, but comfort with the macro recorder and basic edits is assumed, and no part of MO-210 prepares you for it.
The lookup and dynamic-array work steps up too: XLOOKUP, VLOOKUP, HLOOKUP, MATCH and INDEX, plus dynamic array functions such as FILTER and SORTBY. PivotTables and advanced chart types round it out.
The through-line is automation and analysis rather than construction. MO-210 asks whether you can build and manage a workbook properly. MO-211 asks whether you can make one do work for you.
Do you need MO-210 before MO-211?
No. There is no prerequisite, and you can take the Expert exam without holding the Associate certification. What the Expert exam does assume is Associate-level fundamentals, which is a different claim: nothing checks that you have them, and nothing rescues you if you do not.
Going straight to Expert makes sense if you already work in the advanced material daily — macros, lookups, PivotTables — and are confident about the workbook-management basics. It is a poor idea if your Excel is strong but narrow, because the Expert exam still expects the Associate foundation underneath.
In practice most candidates take MO-210 first, and there is a second reason beyond difficulty: it is usually the one that is actually being asked for.
Which one does your situation call for?
If a university or employer told you to get certified, find out which exam they mean before you book anything. When a business school requires “Excel certification” it almost always means the Associate level. Some schools name the Expert exam separately, and at least one accepts Expert as a way to waive a required course — the point is that the requirement is specific and guessing is expensive.
If you are certifying for the job market and have no strong Excel signal on your CV, MO-210 is the sensible first credential. If you already demonstrably work at an advanced level and want the certification to say something your experience does not already say, MO-211 is the one worth the fee.
If you intend to hold both, the ordering that wastes least time is Associate then Expert, because the Associate material is assumed by the Expert exam and the two share a format you only have to learn once.
Is MO-211 harder? Yes, but not in the way people expect
MO-211 is meaningfully harder, but the format is identical, which means the preparation method transfers directly. The same 50-minute clock, the same performance-based tasks, the same instructions describing outcomes rather than commands, and the same per-check partial credit.
So the honest advice for the Expert exam is the advice for the Associate one, with a thinner margin: cover the whole objective domain rather than the parts you enjoy, rehearse against the clock, and find your gaps on a practice run instead of on exam day.
What costs people points
Create Advanced Formulas and Macros is 25–30% of MO-211, and the macro half of it is genuinely new territory — recording, naming and editing macros appears nowhere in MO-210. Candidates who prepare only by pushing their formula work deeper meet the macro tasks cold.
The most expensive version of this mistake. Universities and employers usually mean the Associate exam when they say Excel certification, and an Expert pass earned instead may satisfy the requirement while costing considerably more effort than needed. Confirm the exam code before paying.
MO-211 assumes Associate-level fundamentals without testing them heavily, so a candidate who is excellent at lookups but has never set a print area or managed workbook views can be blindsided by the parts of the Expert exam that take that foundation for granted.
Related questions
Do I need to pass MO-210 before taking MO-211?
No, it is not a prerequisite. Associate-level fundamentals are assumed by the Expert exam, but nothing stops you taking MO-211 first. Most candidates take MO-210 first, both because it is easier and because it is usually the one being asked for.
What is the main difference between the two exams?
Where the marks sit. MO-210 puts 25–30% each on managing worksheets and workbooks and on managing data cells and ranges. MO-211 drops workbook settings to 10–15% and moves the weight into managing and formatting data (30–35%), advanced formulas and macros (25–30%) and advanced charts and tables (25–30%).
Does MO-211 require VBA programming?
Not deep programming. You need to record, name and edit simple macros, so comfort with the macro recorder and basic edits is expected. Writing substantial VBA from scratch is not the focus of the exam.
Which one do universities require?
Usually the Associate exam. Some name it explicitly, others use wording like “basic” or “core” that maps to it, and at least one treats the Expert certification as grounds to waive a required course. Always confirm the exam code with your school rather than inferring it from an adjective.
Is the pass mark the same for both?
Both are scored out of 1000 with 700 to pass, and both are 50 minutes. The scoring mechanics are identical; only the content and its weighting differ.
Can I take both?
Yes, and holding both is a common goal. Associate first is the ordering that wastes least effort, since the Expert exam assumes the Associate material and the two share a format you only learn once.
Sources
Read on August 27, 2026. Where this page says something is not published, that means we looked and did not find it — check for yourself.
Keep reading
Find out what you would actually score
Take a full, timed MO-210 practice exam, upload the workbook you built, and get a score out of 1000 with a per-task breakdown of where the points went. Your first one is free.
No credit card needed.