The two Excel exams
MO-210 earns Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps). Microsoft gives you 50 minutes, a proctor, and possibly interactive tasks to do in the exam itself. It lists five areas: worksheets and workbooks, cells and ranges, tables, formulas and functions, and charts. It doesn’t give weights for them on the exam page. Microsoft suggests about 150 hours of instruction and hands-on use before you sit it. The price depends on the country or region where you take the exam, and students and educators schedule through Certiport.
MO-211 earns Excel Expert (Microsoft 365 Apps). Microsoft does weight its four areas:
| Area | Share of the exam |
|---|---|
| Manage workbook options and settings | 10 to 15% |
| Manage and format data | 30 to 35% |
| Create advanced formulas and macros | 25 to 30% |
| Manage advanced charts and tables | 25 to 30% |
For the Expert areas, the lessons to practice are conditional totals with SUMIFS, XLOOKUP, dynamic arrays such as FILTER, LET, data validation, Goal Seek, PivotTables, recording a macro and combo charts.
Study plan
Our Excel course runs in a working spreadsheet in your browser, and every exercise is checked by what ends up in the cells. For MO-210, the beginner units cover most of the five areas; add tables, conditional formatting and charts from the intermediate units. Then do the task sets below on a clock.
About our task sets
The course ends with four timed task sets in the style of MO-200 and MO-201, the Office 2019 Excel exams. Microsoft lists the same five areas for MO-200 as for MO-210, with weights: 10 to 15% for worksheets and workbooks, 20 to 25% for cells and ranges, 15 to 20% for tables, 20 to 25% for formulas and functions and 20 to 25% for charts. Our sets are shorter than the real exam, from 22 to 30 minutes each, and the tasks are ours, not Microsoft’s.
What this isn’t
Our spreadsheet isn’t Microsoft Excel, and passing a task set isn’t a Microsoft certification. The Work Gym isn’t affiliated with Microsoft. Book the real exam through Microsoft Learn when you’re ready.