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

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

Created by: Phillip Burton • 880000+ students so far
Best Selling Instructor - over 880,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I 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

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.

Target audience

• 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.