MO-211 deep review — September 28, 2026

The entire Excel Expert guide was reviewed against 48 detailed tasks, grouped 8/11/17/12 in the official skills PDF. Wrapped function/chart bullets were kept intact. The receipt preserves the PDF hash and individual task mappings; the four-domain automatic page baseline remains unchanged. No retirement notice was found. Current logistics are 50 minutes, seven languages, a 150-hour preparation recommendation, no dedicated Learn collection and a 60-month renewal label, qualified by the MOS expiration policy.

The update names the complete function set and specialized chart types, adds six original examples, ten proposed desktop labs and 32 answered checks, and distinguishes supplementary sensitivity Data Tables and WORKDAY.INTL. It explains pasted invalid data, formula-versus-static output, first/last/aggregate lookup answers, financial units/signs, calendar exclusions and classic calculated-field aggregation. A row-level revenue of 140 versus a classic aggregate product of 300 makes the latter error concrete.

Sources and article intake

Current Microsoft Support references were read for XLOOKUP, PMT, NPER, WORKDAY, FILTER, SORTBY, RANDARRAY, Pivot calculations, invalid-data circles, macro copying and stale values. Main desktop Pivot behavior was reviewed; complete platform tabs were not audited. The help directory was inspected, without a claim that its linked lessons or paid courses were evaluated.

Joe McDaid's stale-value announcement, originally August 8, 2023, was read in full from its public embedded article body. Its Beta availability paragraph is historical. The guide uses current Support guidance for warning behavior and limitations: hiding formatting does not recalculate; not every external or dependent value is covered. The embedded demonstration was not watched. This article is supporting context, not expanded exam scope.

Verification boundaries

23 independent local Python assertions check example arithmetic, record selection, ordering, dates, gating and aggregation. They do not execute Excel formulas. No workbook engine, desktop application, macro, paid assessment or live exam environment was run. Proposed lab completion evidence is explicitly prospective; study budgets are author estimates. Independent human review remains pending. Repository, learning catalog, unit, strict build and generated-site results are recorded in the receipt after they pass.