Orientation: Exam Format and Study Strategy
What the Microsoft Office Specialist: Excel Expert exam (MO-211) actually measures, how this course is organized around it, and how to work through the curriculum before test day.
—no quiz
Complete curriculum
Excel Master Class study guide
Built to the Microsoft Office Specialist: Excel Expert (MO-211) exam blueprint, plus a Power Query extension track the exam doesn’t cover but a working analyst needs. Every lesson is open, free, to any signed-in account.
Workbook Options, Protection, and Collaboration
Move macros and data between workbooks safely, manage workbook versions, and configure the protection and calculation settings that make a workbook safe to share with other people.
15questions
Filling and Formatting Data
Fill cells intelligently with Flash Fill, advanced Fill Series options, and RANDARRAY(), then format and validate that data with custom number formats and data validation rules.
14questions
Advanced Conditional Formatting and Filtering
Build conditional formatting rules beyond the basic presets, including formula-driven rules that check one column while formatting a whole row, and manage rule order and scope so the right formatting wins.
11questions
Logical Functions and Lookups
Handle multiple conditions with nested logical functions, aggregate data by criteria, name intermediate values with LET, and choose the right lookup function for a table's actual shape.
17questions
Date/Time Functions and Data Analysis Tools
Work with dynamic date and time functions, use Goal Seek and Scenario Manager for what-if analysis, consolidate data from multiple ranges, and apply financial and dynamic array functions with the correct argument conventions.
19questions
Troubleshooting Formulas and Recording Macros
Trace formula relationships, monitor distant cells with the Watch Window, configure error checking rules, step through a formula's calculation with Evaluate Formula, and record, name, and edit simple macros.
15questions
Advanced Charts
Build combo charts with a secondary axis, visualize distributions with Box & Whisker and Histogram charts, show sequential change with Funnel and Waterfall charts, and represent hierarchy with Sunburst charts.
15questions
PivotTables
Create and reshape PivotTables, filter them interactively with slicers, group row and column data into meaningful buckets, and extend them with calculated fields and value field settings.
14questions
PivotCharts
Create PivotCharts and understand their permanent link to an underlying PivotTable, filter and reshape them using their on-chart field buttons, apply chart styles, and drill into hierarchy levels or the raw records behind a summarized value.
11questions
Final Review: MO-211 Exam Readiness
A domain-by-domain consolidation of the highest-value exam traps from Lessons 1 through 9, organized to match MO-211's own four graded domains, as final preparation before the cumulative practice exam.
—no quiz
Power Query Fundamentals (Beyond the Exam)
Connect to data sources with Get & Transform, navigate the Power Query Editor and its Applied Steps, perform basic column and row transformations, and load a query's results into a worksheet or the Data Model.
—no quiz
Power Query: Combining and Automating Data (Beyond the Exam)
Combine queries with Merge and Append, reshape data with Pivot and Unpivot Column, add custom columns using Power Query's own formula language, configure refresh behavior, and get a first, non-exhaustive orientation to the M language underneath every query.
—no quiz
Power Pivot and DAX Fundamentals (Beyond the Exam)
Add tables to Excel's Data Model, relate them to each other without a single VLOOKUP, and write DAX calculated columns and measures -- including CALCULATE, the one function that makes DAX genuinely different from an ordinary worksheet formula.
—no quiz
VBA Beyond the Recorder (Beyond the Exam)
Write real VBA code by hand: declare variables with the right data type, branch and loop, work with Excel's object model directly instead of recording clicks, and handle an event without triggering an infinite loop.
—no quiz
Modern Dynamic Arrays and LAMBDA (Beyond the Exam)
Extend FILTER() and SORTBY() into the rest of the modern array-function family -- MAP, BYROW, BYCOL, REDUCE, and SCAN -- then write and save custom, reusable functions with LAMBDA, including a function that calls itself.
—no quiz
Financial Modeling and Solver (Beyond the Exam)
Link a simple three-statement model, build real sensitivity tables around PMT/NPER-style calculations already covered earlier in this course, and use Solver to find the input values that hit a target under real constraints -- extending Goal Seek and Scenario Manager into genuine optimization.
—no quiz