Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps)
Exam overview and skills-measured summary
Source ledger
References and rights boundary
Instruction is independently written from Microsoft’s own published exam skills outline and original workbook scenarios. No real MO-211 exam question is reproduced or approximated.
Exam MO-211 Microsoft Excel Expert (Microsoft 365 Apps) -- Skills Measured
Full skills outline PDF, all four graded domains
Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)
Certification overview: prerequisites, renewal, registration guidance
Exam and Applied Skills assessment lab retake policies; Microsoft Certification Renewal
48-hour wait after a second failed attempt, applying to every subsequent retake; renewal assessment mechanics (six-month eligibility window, one-year extension from original expiration date)
MAP function; BYROW function; BYCOL function; REDUCE function; SCAN function; LAMBDA function
MAP/BYROW/BYCOL result shapes; REDUCE vs. SCAN return values and differing default initial_value; LAMBDA syntax and immediate invocation; naming a LAMBDA through Name Manager; recursive LAMBDA and the practical recursion-depth limit
Power Query documentation
Get & Transform, the Power Query Editor, Applied Steps, transformations, load destinations, merging/appending queries, pivot/unpivot, custom columns, refresh behavior, and the M formula language
Power Pivot: Powerful data analysis and data modeling in Excel; Calculated Columns in Power Pivot; CALCULATE function (DAX)
Enabling the Power Pivot add-in; the three routes into the Data Model; relationship cardinality and active/inactive relationships; calculated column vs. measure storage and evaluation timing; CALCULATE and ALL for filter-context overrides
Declaring variables (VBA); Dim statement; Worksheet.Change event; Application.EnableEvents property
Data type ranges (Integer vs. Long) and Variant defaults; Option Explicit's variable-declaration requirement; Select Case syntax; For Each iteration; the Worksheet_Change/EnableEvents infinite-loop pattern and its standard fix; UserForm controls and the Initialize event
Define and solve a problem by using Solver; Data table in Excel: one-variable and two-variable tables
Enabling the Solver add-in; objective/variable/constraint cell roles; Simplex LP vs. GRG Nonlinear vs. Evolutionary solving methods and GRG's local-optimum dependency on starting values; two-variable Data Table Row Input Cell/Column Input Cell mechanics