The Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) exam, MO-211, validates advanced skills in Microsoft Excel. It shows that you can customize Excel to meet project needs and build expert-level workbooks, such as custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. It suits accountants, financial analysts, data analysts, and other business professionals.
The exam covers four areas: managing workbook options and settings; managing and formatting data; creating advanced formulas and macros; and managing advanced charts and tables. You complete performance-based tasks inside Excel, so the exam reflects the work you do on the job.
To prepare, you'll need a strong command of Excel's core tools and plenty of hands-on practice with its advanced features. Focus on tasks such as nesting functions with conditional logic, looking up data, recording and editing macros, and building PivotTables and PivotCharts. Review the full MO-211 exam objectives on Microsoft Learn.