← All projects
Open sourceCourses

Excel Expert (MO-211) course

A free, hands-on prep course for the Microsoft Excel Expert (MO-211) certification — every exam objective, taught by doing, with practice files and worked solutions.

ExcelMicrosoft 365Free course

My role: Created the full course — curriculum, lessons, and practice files.

Executive summary

Excel Expert (MO-211) is a free, hands-on bootcamp for anyone aiming to earn the Microsoft Office Specialist: Excel Expert credential. It mirrors Microsoft's official 'Skills Measured' outline, so studying the course is studying the exam.

It's built for professionals who want to prove advanced Excel proficiency with a recognised certification — and genuinely learn the skills, not just memorise them.

What you'll learn

Four modules map one-to-one to the exam's competency areas and their weightings.

  • Manage workbook options & settings (10–15%)Workbook configuration, references, and preparation settings.
  • Manage & format data (30–35%)Advanced data management and formatting — the largest exam area.
  • Advanced formulas & macros (25–30%)Complex formula construction and macro basics.
  • Advanced charts & tables (25–30%)Sophisticated visualisation with advanced charts and tables.

How it's delivered

A text-based, learn-by-doing format — no fluff, lots of practice.

  • Modular lessonsFour folders aligned to the exam, each with step-by-step README lessons.
  • Practice & solution filesScenario-based starter .xlsx files with worked solutions.
  • Exam-day prepCompanion guides on the test environment, keyboard shortcuts, and exam tips.
  • Free & openEntirely free and open on GitHub.

Skills & tools

Excel (Microsoft 365)Advanced formulasMacrosAdvanced chartsData managementMO-211

Outcome

Work through the four modules and you'll have practised every skill the MO-211 exam measures, with the reference material to walk in confident on test day.

Pass, and you hold the Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) credential.