MO-211 prep: Microsoft Excel Expert (Microsoft 365 Apps)
Learn the skills for the new MO-211 Excel certification. Create PivotTables, simple macros, advanced charts and formulas
4.40 (421 reviews)
2,408
students
8 hours
content
Mar 2025
last update
$84.99
regular price
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
Related Topics
5190998
udemy ID
3/3/2023
course created date
5/28/2023
course indexed date
Bot
course submited by