MOS Excel Expert (Office 2019)

MO-201: Microsoft Excel Expert (Office 2019)

More study resources

About this exam

MO-201, Microsoft Excel Expert (Office 2019), is the exam behind the Microsoft Office Specialist: Excel Expert (Office 2019) certification. It targets people who already work confidently in Excel and want independent proof that they can build and distribute professional spreadsheets for specialized business needs. The published description frames the exam around customizing the Excel environment to meet project needs and boost productivity, and it names typical expert artifacts: custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidates are expected to apply the principal Excel features at expert level and finish tasks independently, so the exam is hands-on rather than recall-based. The published objective areas, with their stated weight ranges, are managing workbook options and settings (15–20%), managing and formatting data (20–25%), creating advanced formulas and macros (30–35%), and managing advanced charts and tables (25–30%). Because formulas and macros carry the largest share, that area deserves the most practice time, with charts and tables close behind. Preparation options listed for the exam are self-paced and instructor-led, and a downloadable skills outline describes the objectives in depth. The exam is offered in English, Spanish, French, German, Japanese, Korean, Chinese (Simplified), and Chinese (Traditional), has no announced retirement date, and is priced by the country or region where it is proctored.

What you'll study

Common questions

About MOS Excel Expert (Office 2019) preparation

What format is the MO-201 exam?

The public exam page does not state a format, question count, or time limit. It does describe the expectation that candidates demonstrate correct application of principal Excel features at expert level and complete tasks independently, which points to performance-based work in the application rather than simple recall. Check the exam details when you schedule for current specifics.

How much does the exam cost?

Pricing is based on the country or region in which the exam is proctored, so there is no single global fee. The page also notes that listed pricing excludes applicable taxes and does not reflect promotional or reduced pricing for Microsoft Certified Trainers and Microsoft Partner Network members. Confirm exact pricing with the exam provider before registering.

What score do I need to pass?

The published exam page does not state a passing score, so treat any specific number you hear as unverified. Focus instead on covering every objective in the skills outline, especially the larger weighted areas. Your score report after the attempt will show your result and the sections where you lost points.

Which objective area should I study first?

Start with creating advanced formulas and macros, published at 30–35%, then manage advanced charts and tables at 25–30%. Together those two areas account for most of the exam. Manage and format data (20–25%) and manage workbook options and settings (15–20%) come after, though all four areas are assessed and none should be skipped.

Can I retake the exam if I fail?

The exam page does not publish a retake policy. Microsoft directs candidates to its general exam policies and FAQ for rules covering scheduling, retakes, and accommodations, so read that page before you book. Plan your first attempt as if a retake costs you another full fee and another waiting period.

In what languages is the exam available?

The exam is offered in English, Spanish, French, German, Japanese, Korean, Chinese (Simplified), and Chinese (Traditional). If you plan to use a non-English version, make sure you know the localized Excel interface terms, because function names and ribbon labels differ between language versions and the tasks are performed in the application.

Is the exam retired or expiring?

The exam page lists the retirement date as none, so no retirement has been announced. The page does caution that if an exam is taken before a retirement date it counts toward the certification, which matters if a retirement is announced later. Recheck the page before scheduling in case that changes.

What are the most common ways candidates lose points?

Weak spots tend to be the areas that need setup rather than a single click: recording and editing macros, building PivotTables and PivotCharts from the right source data, applying advanced filters and data validation, and constructing formulas with lookups, nested logic, and structured references. Practicing complete workbooks end to end, not isolated features, exposes those gaps.

Should I register with a personal or a work account?

Microsoft strongly recommends registering with a personal MSA account. If you register with an organizational work or school AAD account, the page warns that your exam records will be lost and unrecoverable if you leave that organization. Use a personal account you will keep access to long after the exam.

How should I prepare for the exam?

Download the exam skills outline and work through each listed objective in Excel 2019, building the kinds of workbooks the exam describes: custom templates, multiple-axis financial charts, amortization tables, and inventory schedules. The page lists self-paced and instructor-led preparation options. Practice until you can complete each task independently without step-by-step guidance.