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.50 (455 reviews)
2 592
students
8 hours
content
Apr 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
Loading charts...
Related Topics
5190998
udemy ID
03/03/2023
course created date
28/05/2023
course indexed date
Bot
course submited by