MOS Excel Expert (Office 2019) study guide
MOS Excel Expert (Office 2019) · Work through your exam, one topic at a time.
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 MOS Excel Expert (Office 2019) study guide has 4 sections and about 1,527 words.
01Manage workbook options and settings
This domain covers workbook-level controls rather than cell content: calculation behavior, macro security, protection, versioning, document properties, and language/proofing settings. Questions often describe a symptom, such as slow recalculation, blocked macros, or a protected sheet, and ask which setting fixes it.
354 words, about 2 min02Manage and format data
This domain tests whether you can shape and constrain data: custom number formats, validation rules, formula-driven conditional formatting, advanced filters, multi-level sorts, grouping, and subtotals. Custom number formats have up to four sections: positive;negative;zero;text.
378 words, about 2 min03Create advanced formulas and macros
This domain covers function-based problem solving and automation: modern worksheet functions, lookup patterns, date arithmetic, and recorded or edited macros. Excel 2019 includes IFS, SWITCH, TEXTJOIN, MAXIFS, and MINIFS, but not XLOOKUP, FILTER, LET, or dynamic arrays, which belong to Microsoft 365.
381 words, about 2 min04Manage advanced charts and tables
This domain tests charts that compare mismatched scales and PivotTables/PivotCharts that summarize large data sets. Expect questions on combo charts, secondary axes, trendlines, calculated fields and items, grouping, slicers, timelines, and GETPIVOTDATA.
414 words, about 2 min