Microsoft Excel Expert (Microsoft 365 Apps)
Show you can build, analyze, and automate professional spreadsheets. MO-211 is the advanced Excel certification employers look for.
Add the free MO-211 practice exam to your cart. No purchase needed.
Exam at a glance
About the exam
Exam MO-211 leads to the Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification. It demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations.
Expert work means customizing the Excel environment to fit a project, protecting your work, and building things like custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.
Like the Associate exam, MO-211 is performance-based and describes tasks by outcome rather than by command name, so you need genuine conceptual command of advanced formulas, data analysis, macros, PivotTables, and advanced charts.
Who it is for
- Analysts, accountants, and finance professionals who build models and reports
- Power users who automate work with macros, lookups, and dynamic arrays
- Anyone who already has Associate-level Excel skills and wants to prove expert competency
- Candidates pursuing the Microsoft Office Specialist: Expert (Microsoft 365 Apps) credential
Skills measured
The exam is organized into these objective domains. Percentages show the approximate share of the exam each area represents.
- Copy macros between workbooks
- Reference data in other workbooks
- Enable macros in a workbook
- Manage workbook versions
- Restrict editing
- Protect worksheets and cell ranges
- Protect workbook structure
- Configure formula calculation options
- Fill cells by using Flash Fill
- Fill cells by using advanced Fill Series options
- Generate numeric data by using RANDARRAY()
- Create custom number formats
- Configure data validation
- Group and ungroup data
- Calculate data by inserting subtotals and totals
- Remove duplicate records
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
- Perform logical operations by using nested functions including IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), NOT(), and LET()
- Look up data by using XLOOKUP(), VLOOKUP(), HLOOKUP(), MATCH(), and INDEX()
- Reference date and time by using NOW() and TODAY()
- Calculate dates by using WEEKDAY() and WORKDAY()
- Summarize data from multiple ranges by using the Consolidate feature
- Perform what-if analysis by using Goal Seek and Scenario Manager
- Forecast data by using AND(), IF(), and NPER()
- Calculate financial data by using PMT()
- Filter data by using FILTER()
- Sort data by using SORTBY()
- Trace precedence and dependence
- Monitor cells and formulas by using the Watch Window
- Validate formulas by using error checking rules
- Evaluate formulas
- Record simple macros
- Name simple macros
- Edit simple macros
- Create and modify dual-axis charts
- Create and modify Box and Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts
- Create PivotTables
- Modify field selections and options
- Create slicers
- Group PivotTable data
- Add calculated fields
- Configure value field settings
- Create PivotCharts
- Manipulate options in existing PivotCharts
- Apply styles to PivotCharts
- Drill down into PivotChart details
How to prepare
- 1Build things end to end. Expert tasks combine features, so practice by creating full models, dashboards, and templates rather than isolated formulas.
- 2Master the function families. Know when to reach for XLOOKUP versus INDEX and MATCH, and how the IFS, SUMIFS, and MAXIFS style functions differ.
- 3Practice data analysis tools by hand: PivotTables, slicers, Goal Seek, Scenario Manager, Consolidate, and what-if forecasting.
- 4Get comfortable recording, naming, and editing simple macros, and protecting workbooks and ranges.
- 5Rehearse the advanced chart types (Box and Whisker, Funnel, Histogram, Sunburst, Waterfall, and dual-axis) so they are muscle memory under time pressure.
Frequently asked questions
How hard is MO-211 compared with MO-210?
MO-211 is the Expert exam. It assumes you already have Associate-level skills and adds advanced formulas, macros, data analysis, PivotTables, and advanced charts.
How long is the exam and how is it scored?
50 minutes of performance-based projects, scored out of 1000 points with 700 as the typical passing mark.
Do I need to know VBA?
You need to record, name, and edit simple macros. Deep VBA programming is not the focus, but comfort with the macro recorder and basic edits is expected.
Which lookup functions are covered?
XLOOKUP, VLOOKUP, HLOOKUP, MATCH, and INDEX, plus dynamic array functions such as FILTER and SORTBY.
Do I need MO-210 first?
It is not required, but Associate-level fundamentals are assumed. Many candidates earn MO-210 first, then MO-211.
What is the best way to prepare?
Around 150 hours of hands-on practice plus full, timed practice exams that follow the real Expert objective domains.
Ready to practice for MO-211?
Take a full, timed Microsoft Excel Expert practice exam and get detailed, per-task feedback. Your first exam is on us.
No purchase needed. Add the free exam to your cart on the practice exams page.