MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course
Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.
$14.99 / $24.99
About the MO-201 Exam
-
1. Exam Structure1m
-
2. Objective Domains & Skills Measured2m
-
3. Exam Interface & Scheduling2m
-
4. Helpful Resources2m
The Course Project
-
1. Course Project Intro1m
-
2. The Airbnb Dataset8m
Advanced Formulas & Macros
-
1. Objective Domain Intro2m
-
2. Fixed vs9m
-
3. Explicit vs9m
-
4. Logical Operations3m
-
5. The IF Function6m
-
6. Nested IF Functions vs8m
-
7. The NOT & “<>” Operators5m
-
8. The AND/OR Operators8m
-
9. The SWITCH Function9m
-
10. The COUNTIF/SUMIF/AVERAGEIF Functions8m
-
11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria9m
-
12. The MINIFS & MAXIFS Functions4m
-
13. Excel Date Values & Formatting7m
-
14. PRO TIP: Converting Text to Dates6m
-
15. The TODAY & NOW Functions5m
-
16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND3m
-
17. WEEKDAY, WORKDAY & NETWORKDAYS6m
-
18. Recording a Macro7m
-
19. Modifying & Deleting Macros3m
-
20. PRO TIP: Adding Form Controls4m
-
21. Lookup Functions1m
-
22. The VLOOKUP & HLOOKUP Functions14m
-
23. The INDEX Function3m
-
24. The MATCH Function4m
-
25. Combining INDEX & MATCH10m
-
26. Approximate Match Lookups5m
-
27. The PMT & NPER Functions10m
-
28. Scenario Manager6m
-
29. Consolidate Data7m
-
30. Goal Seek5m
-
31. Formula Auditing12m
Managing & Formatting Data
-
1. Objective Domain Intro1m
-
2. Custom Number Formats7m
-
3. Data Validation8m
-
4. Group & Ungroup Data5m
-
5. Subtotals & Totals5m
-
6. Removing Duplicates9m
-
7. Auto Fill & Flash Fill9m
-
8. Advanced Fill Series Options5m
-
9. Conditional Formatting8m
-
10. Formula-based Conditional Formatting13m
-
11. Managing Conditional Formatting Rules5m
-
12. PRO TIP: Hiding Values to Create Heatmaps3m
Advanced Charts & Pivot Tables
-
1. Objective Domain Intro2m
-
2. Box & Whisker Chart8m
-
3. Histogram6m
-
4. Filled Map6m
-
5. Combo Chart8m
-
6. Tree Map & Sunburst Chart8m
-
7. Waterfall Chart4m
-
8. Funnel Chart4m
-
9. Creating a Pivot Table8m
-
10. Modifying Pivot Table Views5m
-
11. "Summarize Values By" Options6m
-
12. "Show Values As" Calculations9m
-
13. Analyze & Design Tabs1m
-
14. Report Layouts & Options4m
-
15. Number Formatting4m
-
16. Sorting & Filtering7m
-
17. Slicers & Timelines5m
-
18. Grouping Text Fields3m
-
19. Grouping Numerical Fields6m
-
20. Grouping Date Fields5m
-
21. Calculated Fields7m
-
22. Calculated Items5m
-
23. Pivot Charts5m
-
24. Pivot Chart Formatting2m
-
25. Expanding & Collapsing Pivot Charts3m
Workbook Options & Settings
-
1. Objective Domain Intro1m
-
2. Enabling Macros3m
-
3. Copying Macros to Other Files4m
-
4. Linking Data Across Workbooks7m
-
5. Protecting Worksheets & Cell Ranges6m
-
6. Protecting & Encrypting Workbooks4m
-
7. Recovering Workbooks3m
-
8. Managing Comments6m
-
9. Formula Calculation Modes4m
-
10. Language Options4m
Practice Test
-
1. Practice Test Intro2m
-
2. Practice Test Structure3m
-
3. SOLUTION: Project 17m
-
4. SOLUTION: Project 25m
-
5. SOLUTION: Project 34m
-
6. SOLUTION: Project 46m
-
7. SOLUTION: Project 57m
-
8. SOLUTION: Project 63m
