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.
