MO-201 vs MO-211: what's the difference?

Checking Microsoft's own exam pages directly: MO-201 (Office 2019) shows no retirement date, and neither does MO-211. In that narrow technical sense, both can still be scheduled. But MO-201's page is marked hidden and excluded from search indexing in Microsoft's own site metadata — it has been pulled from Microsoft's certification browsing and search surfaces even though it hasn't been formally retired.

The practical read: MO-201 is a legacy exam for Office 2019, offered because Microsoft hasn't shut the door on it, not because it's the current path. MO-211, tied to Microsoft 365 Apps, is the exam Microsoft actively promotes today. If a requirement — a school, an employer, a job posting — says "Excel Expert certification" without naming an exam code, assume MO-211 unless told otherwise, and confirm before you book anything, since a stray MO-201 result could satisfy an outdated requirement while not being what's currently expected.

MO-201's four domains: Manage Workbook Options and Settings (15-20%), Manage and Format Data (20-25%), Create Advanced Formulas and Macros (30-35%), Manage Advanced Charts and Tables (25-30%).

MO-211's four domains: Manage Workbook Options and Settings (10-15%), Manage and Format Data (30-35%), Create Advanced Formulas and Macros (25-30%), Manage Advanced Charts and Tables (25-30%).

The chart/table domain held steady, but the other three all shifted. Data management and formatting gained real weight — MO-211 puts nearly a third of the whole exam there, versus roughly a fifth on MO-201. Advanced formulas and macros dropped slightly, and workbook options dropped too. None of this is dramatic on its own, but together it means MO-211 leans a little more toward data cleanup and validation and a little less toward pure formula construction than its predecessor did.

LET(), FILTER(), and SORTBY() are dynamic-array and lambda-family functions introduced after Office 2019 shipped, so they simply don't exist as tested skills on MO-201 — there's no equivalent to relearn, only new material to learn from scratch. If your Excel background is on an older version, these three functions specifically deserve dedicated practice rather than assuming your existing formula knowledge covers them.

The rest of the advanced-formula skill set — nested IF/IFS/SWITCH, the SUMIFS family, XLOOKUP/VLOOKUP/INDEX/MATCH, Goal Seek, Scenario Manager, macros — carries across both exams conceptually, even though the exact skills-measured wording differs between the two.