Preparing for the MO-211 Excel exam

MO-211 is the Microsoft exam for Excel Expert (Microsoft 365 Apps). It goes further than MO-210: protection, what-if analysis, macros, advanced charts and PivotTables. Here you practise every part and test yourself with a practice exam of 35 questions. LearnExcel is not official training and does not award a Microsoft certification.

🔒 The MO-211 practice exam is part of the Expert module. With that module you practise every part and take the practice exam as often as you like.

See the modules

Take the practice exam See the lessons

Every part, and how you practise it

With Worksheet you really do it and it gets checked. With Menu you find the right button on a practice ribbon that works like the Excel menu. With Insight you answer a question about something you can't do in a worksheet in your browser, such as recording a macro. Afterwards, try those actions in your own Excel too.

Try it yourself

Clipboard

Font

Alignment

Number

Styles

Cells

Editing

Manage workbook options and settings (10–15 %)

Manage and format data (30–35 %)

Create advanced formulas and macros (25–30 %)

IF, IFS, SWITCH, AND, OR, NOT and LETWorksheet
SUMIFS, COUNTIFS, MAXIFS and MINIFSWorksheet
XLOOKUP, VLOOKUP, HLOOKUP, INDEX and MATCHWorksheet
NOW, TODAY, WEEKDAY and WORKDAYWorksheet
NPER, PMT, FILTER and SORTBYWorksheet
Goal Seek, Scenario Manager and ConsolidateMenu
Auditing formulasMenu
Recording, naming and editing simple macrosMenu

Manage advanced charts and tables (25–30 %)

Based on Microsoft's list of exam objectives. Check the current objectives with Microsoft or Certiport before you book an exam.

Frequently asked questions

Will this get me ready for the exam?

We can't promise that. You practise every part here, but the real exam takes place in real Excel and against the clock. So try the menu exercises and the macros in your own Excel too.

How is it different from MO-210?

MO-210 is the Excel Associate exam, MO-211 the Excel Expert exam. MO-211 also asks about protection, what-if analysis, macros, advanced charts and PivotTables. The MO-210 practice exam is in the Advanced module, MO-211 in the Expert module.

Can I take the official exam with LearnExcel?

No. The official exam runs through Certiport and a test centre. Microsoft gives the current conditions and prices on its own site.

Which language is the exam in?

Microsoft currently lists English as the language for MO-211. Check with your test centre before you book.