MO-211 (and MO-201) exam preparation: Microsoft Excel Expert

Our take

The MO-211 (Excel Microsoft 365 Apps) and MO-201 (Excel 2019) certifications are the ultimate industry credentials validating your advanced spreadsheet capabilities. This course is a laser-focused, project-based prep environment designed to help you ace the official performance-based exam format on your very first try. Rather than just memorizing functions, you will build true corporate-level mastery. You will learn to manage complex data environments, build advanced financial and statistical models, automate repetitive tasks, and audit formulas for flawless reporting.

Best for: all level learners who want one guided path through Microsoft Excel. Skip it if: You already work professionally in Microsoft Excel and need advanced architecture patterns.

📘 What you will learn

• Manage workbook options and settings, including preparing workbooks for collaboration
• Manage and format data
• Fill cells based on existing data, format and validate data and apply advanced conditional formatting
• Create advanced formulas and macros
• Logical functions include IFS, SWITCH, SUMIF, SUMIFS, AND, OR, NOT and LET
• Lookup functions are XLOOKUP, VLOOKUP, HLOOKUP, MATCH and INDEX
• Other functions include WEEKDAY, WORKDAY, NPER, PMT, FILTER and SORTBY
• Manage PivotTables, PivotCharts and advanced charts, including g Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts

📑 Course content

12 sections · 95 lectures · 8 hours of video · updated 11/2026

1. Getting started — 15 lectures · 1.3h
2. Core foundations — 17 lectures · 1.4h
3. Building real projects — 14 lectures · 1.2h
4. Intermediate techniques — 10 lectures · 0.9h
5. Deep dive & best practices — 11 lectures · 1h
6. Capstone project — 10 lectures · 0.9h
7. Next steps — 18 lectures · 1.3h

🎯 Who it is for

Suits: Complete beginners, career switchers, and self-taught devs who want structure.

Needs: Before beginning, you will need to know how to use a Windows computer, including a mouse. You also need to have all of the skills covered by the MO-210 Excel exam. You should have MS Excel (or Office) from 2022 or later installed on your PC computer. This program is also known as a Microsoft 365 App.

👤 Instructor

Phillip Burton - over one million students so far — Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 70 video courses, including over a dozen Bestseller courses. My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, AI and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume. I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

❓ FAQ

These are the provider's aggregate ratings. The analysis above is written by CourseDepth — we do not publish invented student quotes.