MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course
What’s included
$14.99 / $24.99
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.
Pay once, own it forever
Video Courses
About the MO-201 Exam
| Lectures | Duration |
|---|---|
| 1. Exam Structure | 1m |
| 2. Objective Domains & Skills Measured | 2m |
| 3. Exam Interface & Scheduling | 2m |
| 4. Helpful Resources | 2m |
1. Exam Structure
1m
2. Objective Domains & Skills Measured
2m
3. Exam Interface & Scheduling
2m
4. Helpful Resources
2m
The Course Project
| Lectures | Duration |
|---|---|
| 1. Course Project Intro | 1m |
| 2. The Airbnb Dataset | 8m |
1. Course Project Intro
1m
2. The Airbnb Dataset
8m
Advanced Formulas & Macros
| Lectures | Duration |
|---|---|
| 1. Objective Domain Intro | 2m |
| 2. Fixed vs | 9m |
| 3. Explicit vs | 9m |
| 4. Logical Operations | 3m |
| 5. The IF Function | 6m |
| 6. Nested IF Functions vs | 8m |
| 7. The NOT & “<>” Operators | 5m |
| 8. The AND/OR Operators | 8m |
| 9. The SWITCH Function | 9m |
| 10. The COUNTIF/SUMIF/AVERAGEIF Functions | 8m |
| 11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria | 9m |
| 12. The MINIFS & MAXIFS Functions | 4m |
| 13. Excel Date Values & Formatting | 7m |
| 14. PRO TIP: Converting Text to Dates | 6m |
| 15. The TODAY & NOW Functions | 5m |
| 16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND | 3m |
| 17. WEEKDAY, WORKDAY & NETWORKDAYS | 6m |
| 18. Recording a Macro | 7m |
| 19. Modifying & Deleting Macros | 3m |
| 20. PRO TIP: Adding Form Controls | 4m |
| 21. Lookup Functions | 1m |
| 22. The VLOOKUP & HLOOKUP Functions | 14m |
| 23. The INDEX Function | 3m |
| 24. The MATCH Function | 4m |
| 25. Combining INDEX & MATCH | 10m |
| 26. Approximate Match Lookups | 5m |
| 27. The PMT & NPER Functions | 10m |
| 28. Scenario Manager | 6m |
| 29. Consolidate Data | 7m |
| 30. Goal Seek | 5m |
| 31. Formula Auditing | 12m |
1. Objective Domain Intro
2m
2. Fixed vs
9m
3. Explicit vs
9m
4. Logical Operations
3m
5. The IF Function
6m
6. Nested IF Functions vs
8m
7. The NOT & “<>” Operators
5m
8. The AND/OR Operators
8m
9. The SWITCH Function
9m
10. The COUNTIF/SUMIF/AVERAGEIF Functions
8m
11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria
9m
12. The MINIFS & MAXIFS Functions
4m
13. Excel Date Values & Formatting
7m
14. PRO TIP: Converting Text to Dates
6m
15. The TODAY & NOW Functions
5m
16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
3m
17. WEEKDAY, WORKDAY & NETWORKDAYS
6m
18. Recording a Macro
7m
19. Modifying & Deleting Macros
3m
20. PRO TIP: Adding Form Controls
4m
21. Lookup Functions
1m
22. The VLOOKUP & HLOOKUP Functions
14m
23. The INDEX Function
3m
24. The MATCH Function
4m
25. Combining INDEX & MATCH
10m
26. Approximate Match Lookups
5m
27. The PMT & NPER Functions
10m
28. Scenario Manager
6m
29. Consolidate Data
7m
30. Goal Seek
5m
31. Formula Auditing
12m
Managing & Formatting Data
| Lectures | Duration |
|---|---|
| 1. Objective Domain Intro | 1m |
| 2. Custom Number Formats | 7m |
| 3. Data Validation | 8m |
| 4. Group & Ungroup Data | 5m |
| 5. Subtotals & Totals | 5m |
| 6. Removing Duplicates | 9m |
| 7. Auto Fill & Flash Fill | 9m |
| 8. Advanced Fill Series Options | 5m |
| 9. Conditional Formatting | 8m |
| 10. Formula-based Conditional Formatting | 13m |
| 11. Managing Conditional Formatting Rules | 5m |
| 12. PRO TIP: Hiding Values to Create Heatmaps | 3m |
1. Objective Domain Intro
1m
2. Custom Number Formats
7m
3. Data Validation
8m
4. Group & Ungroup Data
5m
5. Subtotals & Totals
5m
6. Removing Duplicates
9m
7. Auto Fill & Flash Fill
9m
8. Advanced Fill Series Options
5m
9. Conditional Formatting
8m
10. Formula-based Conditional Formatting
13m
11. Managing Conditional Formatting Rules
5m
12. PRO TIP: Hiding Values to Create Heatmaps
3m
Advanced Charts & Pivot Tables
| Lectures | Duration |
|---|---|
| 1. Objective Domain Intro | 2m |
| 2. Box & Whisker Chart | 8m |
| 3. Histogram | 6m |
| 4. Filled Map | 6m |
| 5. Combo Chart | 8m |
| 6. Tree Map & Sunburst Chart | 8m |
| 7. Waterfall Chart | 4m |
| 8. Funnel Chart | 4m |
| 9. Creating a Pivot Table | 8m |
| 10. Modifying Pivot Table Views | 5m |
| 11. "Summarize Values By" Options | 6m |
| 12. "Show Values As" Calculations | 9m |
| 13. Analyze & Design Tabs | 1m |
| 14. Report Layouts & Options | 4m |
| 15. Number Formatting | 4m |
| 16. Sorting & Filtering | 7m |
| 17. Slicers & Timelines | 5m |
| 18. Grouping Text Fields | 3m |
| 19. Grouping Numerical Fields | 6m |
| 20. Grouping Date Fields | 5m |
| 21. Calculated Fields | 7m |
| 22. Calculated Items | 5m |
| 23. Pivot Charts | 5m |
| 24. Pivot Chart Formatting | 2m |
| 25. Expanding & Collapsing Pivot Charts | 3m |
1. Objective Domain Intro
2m
2. Box & Whisker Chart
8m
3. Histogram
6m
4. Filled Map
6m
5. Combo Chart
8m
6. Tree Map & Sunburst Chart
8m
7. Waterfall Chart
4m
8. Funnel Chart
4m
9. Creating a Pivot Table
8m
10. Modifying Pivot Table Views
5m
11. "Summarize Values By" Options
6m
12. "Show Values As" Calculations
9m
13. Analyze & Design Tabs
1m
14. Report Layouts & Options
4m
15. Number Formatting
4m
16. Sorting & Filtering
7m
17. Slicers & Timelines
5m
18. Grouping Text Fields
3m
19. Grouping Numerical Fields
6m
20. Grouping Date Fields
5m
21. Calculated Fields
7m
22. Calculated Items
5m
23. Pivot Charts
5m
24. Pivot Chart Formatting
2m
25. Expanding & Collapsing Pivot Charts
3m
Workbook Options & Settings
| Lectures | Duration |
|---|---|
| 1. Objective Domain Intro | 1m |
| 2. Enabling Macros | 3m |
| 3. Copying Macros to Other Files | 4m |
| 4. Linking Data Across Workbooks | 7m |
| 5. Protecting Worksheets & Cell Ranges | 6m |
| 6. Protecting & Encrypting Workbooks | 4m |
| 7. Recovering Workbooks | 3m |
| 8. Managing Comments | 6m |
| 9. Formula Calculation Modes | 4m |
| 10. Language Options | 4m |
1. Objective Domain Intro
1m
2. Enabling Macros
3m
3. Copying Macros to Other Files
4m
4. Linking Data Across Workbooks
7m
5. Protecting Worksheets & Cell Ranges
6m
6. Protecting & Encrypting Workbooks
4m
7. Recovering Workbooks
3m
8. Managing Comments
6m
9. Formula Calculation Modes
4m
10. Language Options
4m
Practice Test
| Lectures | Duration |
|---|---|
| 1. Practice Test Intro | 2m |
| 2. Practice Test Structure | 3m |
| 3. SOLUTION: Project 1 | 7m |
| 4. SOLUTION: Project 2 | 5m |
| 5. SOLUTION: Project 3 | 4m |
| 6. SOLUTION: Project 4 | 6m |
| 7. SOLUTION: Project 5 | 7m |
| 8. SOLUTION: Project 6 | 3m |
1. Practice Test Intro
2m
2. Practice Test Structure
3m
3. SOLUTION: Project 1
7m
4. SOLUTION: Project 2
5m
5. SOLUTION: Project 3
4m
6. SOLUTION: Project 4
6m
7. SOLUTION: Project 5
7m
8. SOLUTION: Project 6
3m