MO-201: Microsoft Excel Expert (Excel and Excel 2019)

Your Microsoft MO-201 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the MO-201 certification test. Ace your Microsoft MO-201 at the first attempt and obtain the Microsoft Excel Expert (Excel and Excel 2019) credential with ease.

145
92
8 h
5.0
Price \$27.49
Today \$24.99

Curriculum for MO-201 Video Course

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

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
5.0
Overall Rating: Good.

Similar Courses

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo