MO-211 prep: Microsoft Excel Expert (Microsoft 365 Apps)

Name: MO-211 prep: Microsoft Excel Expert (Microsoft 365 Apps)
Rating: 4.6 (754 reviews)

Learn the skills for the new MO-211 Excel certification. Create PivotTables, simple macros, advanced charts and formulas

Bestseller

Created byPhillip Burton • over one million students so far, I Do Data Limited

Last updated 2/2026

English

What you'll 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 • 8h 3m total length

Introduction2:26
Welcome to Udemy0:38
How to get the best out of your Udemy course3:05
Do you want auto-translated subtitles in more languages?1:20
Curriculum6:47
Resources0:20

12. Create custom number formats - integers7:56
12. Create custom number formats - fractions4:48
12. Create custom number formats - dates, and adding text and symbols8:27
12. Create custom number formats - sections and colors9:06
13. Configure data validation - numbers5:15
13. Configure data validation - dates, text, and circle invalid data6:05
16. Remove duplicate records4:14
Format and validate data
Practice Activity Number 20:27
Practice Activity Number 2 - The Solution6:08

39. Create PivotTables8:35
44. Configure value field settings6:05
40. Modify field selections and options - PivotTable options and Refresh4:53
40. Modify field selections and options - the PivotTable Analyze and Design tabs5:21
42. Group PivotTable data8:10
41. Create slicers8:37
41. Create timelines3:00
43. Add calculated fields5:39
45-48. PivotCharts6:16
Create and modify PivotTables and PivotCharts
Practice Activity Number 30:42
Practice Activity Number 3 - The Solution6:53

21b-c. The VLOOKUP() function6:37
21b. The difference between VLOOKUP() and SUMIF()5:27
21c. HLOOKUP(), and looking for approximate matches5:37
21d. MATCH()9:05
21e. INDEX()5:08
21a. XLOOKUP()9:11
22, 23. NOW(), TODAY() and WEEKDAY()6:23
23. WORKDAY()6:00
Look up data by using functions, and use advanced date and time functions
Practice Activity Number 61:03
Practice Activity Number 6 - The Solution7:52

25. Perform what-if analysis by using Goal Seek8:01
25b. Perform what-if analysis by using Scenario Manager5:43
26. Forecast data by using the AND(), IF(), and NPER() functions8:44
27. Calculate financial data by using the PMT() function4:42
28. Filter data by using FILTER()6:04
29. Sort data by using SORTBY()3:09
Perform data analysis
Practice Activity Number 70:42
Practice Activity Number 7 - The Solution5:21

8. Configure formula calculation options7:54
11. Generate numeric data by using RANDARRAY()3:52
14. Group and ungroup data6:19
15. Calculate data by inserting subtotals and totals8:44
24. Summarize data from multiple ranges by using the Consolidate feature5:41
30. Trace precedence and dependence5:06
31. Monitor cells and formulas by using the Watch Window3:19
32. Validate formulas by using error checking rules5:46
Other formula topics
Practice Activity Number 80:39
Practice Activity Number 8 - The Solution6:13

9. Fill cells by using Flash Fill3:06
10. Fill cells by using advanced Fill Series options5:50
17, 19. Create custom conditional formatting rules and managing rules9:01
18. Create conditional formatting rules that use formulas - number conditions6:12
18. Create conditional formatting rules that use formulas - date/text conditions4:15
Fill cells based on existing data, and apply advanced conditional formatting
Practice Activity Number 90:29
Practice Activity Number 9 - The Solution4:20

Requirements

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.

Description

The MO-211 certification is the new Expert certification for Excel, launched in April 2023. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

This course has been created using Udemy's Accessibility guidelines. It follows on from your preparations for the MO-210 Excel certification. This content is available in "MO-210: Microsoft Excel (from beginner to intermediate)", which is published on Udemy.

In this MO-211 course:

We’ll start with managing workbook options and settings. We’ll reference data in other workbooks, manage workbook versions, and prepare workbooks for collaboration by protecting their content and structure. We'll also format and valid data, including creating custom number formats.
We’ll then manage advanced charts and tables. We’ll create PivotTables, configuring value field settings and adding slicers, with create and modify PivotCharts, and create and modify advanced charts, including Box & Whisker, Funnel, Histogram, Sunburst and Waterfall charts.
We’ll then create advanced formulas and macros. We’ll use functions for performing logical operations, looking up data, use advanced date and time functions, perform data analysis and troubleshoot formulas. This will also include newer Excel functions, such as XLOOKUP, LET, FILTER and SORTBY.
Finally, we’ll look at other Excel Expert topics. We’ll fill cells based on existing data, we'll create custom conditional formatting rules, and create and manage simple VBA macros.

No prior knowledge is required. And there are 10 Practice Activities, 10 quizzes and a Practice Test to help you remember the information, so you can be sure that you are learning.

Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-211 exam, which gives you the "Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)" certificate. This would look good on your CV or resume.

It is also the first stage to you getting the "Microsoft Office Specialist: Expert (Microsoft 365 Apps)" certification.

Who this course is for:

This course is for you if you want to develop your Microsoft Excel Expert skills.
This course will use the latest version of Excel, but is also for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 2019.
This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft Expert, if you wish to do so.
You will cover the content tested in Microsoft Office Specialist Exams MO-211 (for Excel 2022 and later)
This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

MO-211 prep: Microsoft Excel Expert (Microsoft 365 Apps)

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 15min

Manage workbooks and Prepare workbooks for collaboration7 lectures • 40min

Format and validate data9 lectures • 52min

Create and modify PivotTables and PivotCharts11 lectures • 1hr 4min

Create and modify advanced charts9 lectures • 35min

Perform logical operations in formulas9 lectures • 57min

Look up data by using functions, and use advanced date and time functions10 lectures • 1hr 2min

Perform data analysis8 lectures • 42min

Other formula topics10 lectures • 54min

Fill cells based on existing data, and apply advanced conditional formatting7 lectures • 33min

Requirements

Description

Who this course is for: