Microsoft Excel Expert (Microsoft 365 Apps) Exam MO-211 Prep Class
This class is designed to prepare you to pass the MO-211 Microsoft Certification exam in Excel 365. Once you pass this exam, you will earn the Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification. In the class we will go through multiple practice exams where after each question we go over the answer. This class is just a prep class. You will need to sign up with Microsoft to take the Microsoft Excel Expert (Microsoft 365 Apps) MO-211 certification exam.
$425 per Student
8 CPE Credits
For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, Excel Intermediate Part 2, and Excel Intermediate Part 3 classes.
1 Day
- Copy macros between workbooks
- Reference data in other workbooks
- Enable macros in a workbook
- Manage workbook versions
- Restrict editing
- Protect worksheets and cell ranges
- Protect workbook structure
- Configure formula calculation options
- Fill cells by using Flash Fill
- Fill cells by using advanced Fill Series options
- Generate numeric data by using RANDARRAY()
- Create custom number formats
- Configure data validation
- Group and ungroup data
- Calculate data by inserting subtotals and totals
- Remove duplicate records
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
- Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), NOT(), and LET() functions
- Look up data by using the XLOOKUP(), VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions
- Reference date and time by using the NOW() and TODAY() functions
- Calculate dates by using the WEEKDAY() and WORKDAY() functions
- Summarize data from multiple ranges by using the Consolidate feature
- Perform what-if analysis by using Goal Seek and Scenario Manager
- Forecast data by using the AND(), IF(), and NPER() functions
- Calculate financial data by using the PMT() function
- Filter data by using FILTER()
- Sort data by using SORTBY()
- Trace precedence and dependence
- Monitor cells and formulas by using the Watch Window
- Validate formulas by using error checking rules
- Evaluate formulas
- Record simple macros
- Name simple macros
- Edit simple macros
- Create and modify dual-axis charts
- Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts
- Create PivotTables
- Modify field selections and options
- Create slicers
- Group PivotTable data
- Add calculated fields
- Configure value field settings
- Create PivotCharts
- Manipulate options in existing PivotCharts
- Apply styles to PivotCharts
- Drill down into PivotChart details
Microsoft Excel (Microsoft 365 Apps) Exam MO-211 Prep Class Schedule
In-Person Classes Schedule
| Date | Location | Price | Registration |
Live Online Classes Schedule
| Date | Location | Price | Registration |
Don't see a Class Date that works for you?
Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.
Classes
Contact Us
Phone
817-841-9560
Office Address
227 NE Loop 820
Suite 161
Hurst, TX 76053
Mailing Address
Aledo, TX 76008
For common questions, the chatbot located in bottom right of screen can answer most common questions about pricing, classes, and many other topics.