Practice Exams:

View All

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

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The MO-201 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft MO-201 test with flying colors.

Rating

4.55

Students

109

Duration

08:22:00 h

$16.49

$14.99

Curriculum for MO-201 Certification Video Course

About the MO-201 Exam

4 Lectures

Time 00:07:00

The Course Project

2 Lectures

Time 00:09:00

Advanced Formulas & Macros

31 Lectures

Time 03:18:00

Managing & Formatting Data

12 Lectures

Time 01:18:00

Advanced Charts & Pivot Tables

25 Lectures

Time 02:11:00

Workbook Options & Settings

10 Lectures

Time 00:42:00

Practice Test

8 Lectures

Time 00:37:00

Name of Video	Time
1. Exam Structure	1:00
2. Objective Domains & Skills Measured	2:00
3. Exam Interface & Scheduling	2:00
4. Helpful Resources	2:00

Name of Video	Time
1. Course Project Intro	1:00
2. The Airbnb Dataset	8:00

Name of Video	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

Name of Video	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

Name of Video	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

Name of Video	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
8. Managing Comments	6:00
9. Formula Calculation Modes	4:00
10. Language Options	4:00

Name of Video	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

Microsoft Excel Expert MO-201 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft Excel Expert MO-201 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

$69.97

$49.99

MO-201 Premium Bundle

Premium File: 24 Questions & Answers. Last update: Apr 23, 2025
Training Course: 92 Video Lectures
Study Guide: 204 Pages

Latest Questions
100% Accurate Answers
Fast Exam Updates

MO-201 Premium Bundle

Premium File: 24 Questions & Answers. Last update: Apr 23, 2025
Training Course: 92 Video Lectures
Study Guide: 204 Pages

Latest Questions
100% Accurate Answers
Fast Exam Updates

$69.97

$49.99

Microsoft MO-201 Training Course

Want verified and proven knowledge for Microsoft Excel Expert (Excel and Excel 2019)? Believe it's easy when you have ExamSnap's Microsoft Excel Expert (Excel and Excel 2019) certification video training course by your side which along with our Microsoft MO-201 Exam Dumps & Practice Test questions provide a complete solution to pass your exam Read More.

Prepared by Top Experts, the top IT Trainers ensure that when it comes to your IT exam prep and you can count on ExamSnap Microsoft Excel Expert (Excel and Excel 2019) certification video training course that goes in line with the corresponding Microsoft MO-201 exam dumps, study guide, and practice test questions & answers.

Purchase Individually