MOS Excel Expert (Office 2019) study plan

Build a personal formula reference sheet covering lookup, logical, and text functions, writing each function's syntax from memory before verifying it

Construct nested IF, IFS, and SWITCH formulas that classify a column of raw records into at least four categories

Write INDEX plus MATCH formulas that retrieve values both vertically and horizontally from a two-dimensional range

Diagnose and repair five deliberately broken formulas covering absolute versus relative references and circular references

Compose SUMIFS, COUNTIFS, and AVERAGEIFS formulas that aggregate a dataset using at least three simultaneous criteria

Build dynamic array formulas using FILTER, SORT, and UNIQUE to produce a live summary from a raw table

Create defined names and use them inside formulas so that a formula reads without cell addresses

Trace dependency errors with the Evaluate Formula and Trace Precedents tools and document each fix

Record, edit, and run macros that format a report and save the workbook as a macro-enabled file type

Assign macros to buttons and keyboard shortcuts and set the correct macro security level for a trusted location

Edit recorded VBA in the editor to add a loop and a conditional statement that the recorder could not produce

Use the Personal Macro Workbook to store a utility macro available across all workbooks

Apply data validation rules with input messages and error alerts to constrain entries in three columns

Use Flash Fill and Text to Columns to split and recombine inconsistent name and address data

Remove duplicates and apply advanced filters with criteria ranges to extract targeted record sets

Import and transform a messy text file with Power Query, then load the cleaned result to a table

Apply conditional formatting rules, including formula-based rules and data bars, to highlight outliers automatically

Convert a range to an Excel table and use structured references inside formulas and calculated columns

Build a PivotTable that groups data by two dimensions and add a calculated field and a slicer

Configure PivotTable options for refresh behavior and value field settings such as percent of total

Create and format a combo chart that plots two different value series on primary and secondary axes

Insert trendlines and sparklines, and format axis bounds, units, and number formats for readability

Build a chart template and apply it to a second dataset to confirm reuse works

Create a PivotChart linked to a PivotTable and filter it with a timeline control

Configure workbook properties, calculation options, and compatibility settings for a shared file

Protect worksheets and workbook structure with passwords and restrict editable ranges

Track changes and merge or compare two versions of the same workbook

Create custom number formats and apply them to a financial summary table

Complete a full timed practice project that touches all four domains within 90 minutes

Audit every formula and macro in the project for errors and correct at least three deliberate faults

Review weak objectives from earlier weeks and rewrite the reference sheet to cover them

Take two timed domain-weighted quizzes and score each objective area