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

MO-211: Microsoft Excel Expert (Microsoft 365 Apps) | Udemy
English | Size: 5.35 GB
Genre: eLearning

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

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

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.

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.