MO-211 Expert Prep
Full curriculum · 40 lessons + 4 quizzes · 100% free

The complete MO-211 Excel Expert course.

Four modules, sequenced like the exam. Pick up where you left off, jump to a specific topic, or work straight through.

Last updated May 03, 2026 · Aligned with Excel for Microsoft 365 · MIT licensed

New here? Start with Module 1 · Lesson 1.1 — about 10 minutes — and let the sidebar progress bar track your way through.

Begin Lesson 1.1 Skip to mock exam
Module 1 · 10–15%

Manage Workbook Options & Settings

Lock down your workbooks. Wire up automation. Set the stage for everything that follows.

  • 1.1 Manage Workbooks: Copying Macros between Workbooks
  • 1.2 Manage Workbooks: Reference Data in Other Workbooks
  • 1.3 Manage Workbooks: Enable Macros in a Workbook
  • 1.4 Manage Workbooks: Manage Workbook Versions
  • 1.6 Protect Workbooks: Soft Restrictions, Worksheet Protection, and Cell Ranges
  • 1.7 Prepare for Collaboration: Protect Workbook Structure
  • + 3 more lessons
Open module
Module 2 · 30–35%

Manage & Format Data

Turn raw spreadsheets into clean, validated, beautifully formatted data ready for analysis.

  • 2.0 Named Ranges and the Name Manager
  • 2.1 Flash Fill and Linked Data Types
  • 2.2 Advanced Fill Series Options
  • 2.3 Generate Numeric Data Using RANDARRAY()
  • 2.4 Custom Number Formats
  • 2.5 Data Validation
  • + 9 more lessons
Open module
Module 3 · 25–30%

Advanced Formulas & Macros

Replace nested IFs with modern Excel — XLOOKUP, LET, dynamic arrays, and your first macros.

  • 3.1 Perform Logical Operations Using Advanced Functions
  • 3.2 Look Up Data by Using Advanced Functions
  • 3.3 Use Advanced Date and Time Functions
  • 3.4 What-If Analysis: Goal Seek, Scenario Manager, and Data Tables
  • 3.5 Dynamic Array Functions: The New Era of Excel
  • 3.6 Financial Analysis & Forecasting
  • + 5 more lessons
Open module
Module 4 · 25–30%

Advanced Charts & PivotTables

PivotTables, slicers, calculated fields, and the chart types only Excel Experts know how to build.

  • 4.2 Advanced Charts: Dual-Axis, Combo, Histogram, Box & Whisker, Funnel, Sunburst, Waterfall
  • 4.3 Create and Modify PivotTables
  • 4.5 Create Slicers and Timelines
  • 4.6 Group PivotTable Data
  • 4.7 Add Calculated Fields
  • 4.8 Create and Modify PivotCharts
  • + 3 more lessons
Open module

4 practice .xlsx workbooks

One per module. Each has an instructions sheet plus a hidden Solutions sheet for self-checking. Open in Excel.

Browse practice/ on GitHub

Keyboard Shortcuts

Every shortcut that saves seconds on the timed exam, organised by what you'll be doing.

Open the cheatsheet

Exam Day Tips

What the test environment looks like, common pitfalls, and how to navigate the 50-minute clock.

Read the playbook

Capstone: 50-minute Mock Exam

35 mixed-topic tasks across all four modules. Set a stopwatch, run it like the real thing, then self-grade.

Start the mock