MOS Excel Expert (Office 2019) case studies
MOS Excel Expert (Office 2019) · Put your knowledge to work in context.
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 MOS Excel Expert (Office 2019) case studies are 5 cases and about 4,106 words.
1Recalculation drift and macro prompts in a distributed capital-planning model
Priya maintains a 38 MB capital-planning model for a mid-size lender: 24 worksheets and roughly 40,000 formulas, of which about 6,000 are volatile OFFSET and INDIRECT calls, so a full recalculation takes nearly 90 seconds. While building it she set calculation to Manual and saved the file that way.
829 words, about 4 min2Monthly CSV re-import that keeps corrupting IDs, dates and duplicate logic
The people-operations team exports an 8,400-row training register from its HR system as CSV and re-imports the whole file every month, when it grows by roughly 300 rows. The export mangles data in three predictable ways: employee IDs such as 00417 arrive as 417; completion dates arrive as eight-character text such as 20210315; and Department values carry trailing spaces and inconsistent casing ("ops ", "Ops", "OPS").
800 words, about 4 min3Commission tiers, blank-tolerant aggregation and a recording that breaks monthly
Marco has inherited the sales-compensation workbook for a 12-person inside-sales team: 3,200 closed deals, four regions, one row per deal, plus a summary block that reports commission by rep and by quarter. Column F contains a nine-level nested IF that assigns a commission tier from deal value.
796 words, about 4 min4A flat margin line, a chart that stops growing and a board that wants 12 months
Elena maintains the monthly board pack for a subscription business. Sheet Data holds 36 months of history in columns A:C - Month, Revenue (values between 1.8 M and 4.2 M) and Gross Margin % (values between 22% and 31%).
851 words, about 4 min5Broken refresh, a misleading calculated field and slicers that only move one table
A distribution company keeps 250,000 invoice lines on a sheet named Raw, in the plain range A1:M250001. Four PivotTables and one dashboard sheet read from it.
830 words, about 4 min