MO-200 study plan

Identify when each of the core function families (logical, lookup, text, date, statistical) is the correct tool, and write one working example of each from scratch

Build nested IF, AND, OR, and IFERROR formulas that handle blank cells and error values without breaking the result

Write INDEX and MATCH separately, then combine them into a two-way lookup that returns a value from a row and column intersection

Explain out loud the difference between relative, absolute, and mixed references and predict what happens to a formula when it is filled across and down

Construct SUMIFS, COUNTIFS, and AVERAGEIFS formulas using both numeric and text criteria, including wildcard criteria

Apply the newer dynamic array functions (FILTER, SORT, UNIQUE, XLOOKUP) to return a spill range and explain how the spill behaves when the source data changes

Diagnose and fix the common formula failures: circular reference, #VALUE!, #N/A, #REF!, and a lookup that silently returns the wrong match

Write date and text formulas that combine or split values, such as extracting a year, joining names, or trimming inconsistent spacing

Paste data using Paste Special options (values, formats, transpose, operation) and choose the right option for a stated scenario

Apply and clear conditional formatting rules, including formula-based rules and rules that use data bars or icon sets

Use Flash Fill and Text to Columns to split and recombine inconsistent text data without formulas

Select, name, and manage named ranges, then reference a named range inside a formula

Apply data validation with list, whole-number, and custom formula rules, and configure an input message and error alert

Convert a range to a table and identify what changes (structured references, banded rows, auto-expansion)

Write structured reference formulas that reference table columns by name and survive new rows being added

Add, rename, and reorder table columns, and remove duplicates within a table

Configure table style options and a totals row, then switch the totals function between sum, count, and average

Import data into a table from a delimited text source and resolve a column that imports with the wrong data type

Manage workbook structure: add, rename, reorder, hide, and group worksheets, and move or copy a sheet between workbooks

Set print and page layout options, including print area, print titles, page breaks, orientation, and scaling to fit

Configure workbook properties, protect a worksheet while leaving specified cells editable, and track changes or comments

Create a column, line, and pie chart from the same data set and justify which chart type fits a stated comparison

Add and format chart elements: axis titles, data labels, legend placement, gridlines, and a chart title linked to a cell

Create a combo chart with a secondary axis and explain when a secondary axis is misleading

Move a chart to its own sheet, resize it, and change the source data range to include a new row

Apply a chart template or save a chart as a template for reuse

Insert and format sparklines and explain how they differ from a full chart object

Apply a consistent chart style and color scheme across multiple charts in one workbook

Use defined names and table references as a chart source so the chart updates automatically when data grows

Review and correct a workbook's calculation options, including manual versus automatic calculation and iterative calculation

Complete a full timed practice project that requires formulas, a table, conditional formatting, and at least two charts

Identify your three weakest objectives from the practice project and rewrite the relevant formulas or settings until correct

Rehearse the exam interface tasks you cannot do from memory, such as inserting a chart element or applying a table style

Verify every deliverable from weeks 1 through 7 still opens and calculates without errors