
MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course
The complete solution to prepare for for your exam with MO-201: Microsoft Excel Expert (Excel and Excel 2019) certification video training course. The MO-201: Microsoft Excel Expert (Excel and Excel 2019) certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft Excel Expert MO-201 exam dumps, study guide & practice test questions and answers.
MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course Exam Curriculum
About the MO-201 Exam
-
1. Exam Structure
-
2. Objective Domains & Skills Measured
-
3. Exam Interface & Scheduling
-
4. Helpful Resources
The Course Project
-
1. Course Project Intro
-
2. The Airbnb Dataset
Advanced Formulas & Macros
-
1. Objective Domain Intro
-
2. Fixed vs. Relative References
-
3. Explicit vs. Structured References
-
4. Logical Operations
-
5. The IF Function
-
6. Nested IF Functions vs. The IFS Function
-
7. The NOT & “<>” Operators
-
8. The AND/OR Operators
-
9. The SWITCH Function
-
10. The COUNTIF/SUMIF/AVERAGEIF Functions
-
11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria
-
12. The MINIFS & MAXIFS Functions
-
13. Excel Date Values & Formatting
-
14. PRO TIP: Converting Text to Dates
-
15. The TODAY & NOW Functions
-
16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
-
17. WEEKDAY, WORKDAY & NETWORKDAYS
-
18. Recording a Macro
-
19. Modifying & Deleting Macros
-
20. PRO TIP: Adding Form Controls
-
21. Lookup Functions
-
22. The VLOOKUP & HLOOKUP Functions
-
23. The INDEX Function
-
24. The MATCH Function
-
25. Combining INDEX & MATCH
-
26. Approximate Match Lookups
-
27. The PMT & NPER Functions
-
28. Scenario Manager
-
29. Consolidate Data
-
30. Goal Seek
-
31. Formula Auditing
Managing & Formatting Data
-
1. Objective Domain Intro
-
2. Custom Number Formats
-
3. Data Validation
-
4. Group & Ungroup Data
-
5. Subtotals & Totals
-
6. Removing Duplicates
-
7. Auto Fill & Flash Fill
-
8. Advanced Fill Series Options
-
9. Conditional Formatting
-
10. Formula-based Conditional Formatting
-
11. Managing Conditional Formatting Rules
-
12. PRO TIP: Hiding Values to Create Heatmaps
Advanced Charts & Pivot Tables
-
1. Objective Domain Intro
-
2. Box & Whisker Chart
-
3. Histogram
-
4. Filled Map
-
5. Combo Chart
-
6. Tree Map & Sunburst Chart
-
7. Waterfall Chart
-
8. Funnel Chart
-
9. Creating a Pivot Table
-
10. Modifying Pivot Table Views
-
11. "Summarize Values By" Options
-
12. "Show Values As" Calculations
-
13. Analyze & Design Tabs
-
14. Report Layouts & Options
-
15. Number Formatting
-
16. Sorting & Filtering
-
17. Slicers & Timelines
-
18. Grouping Text Fields
-
19. Grouping Numerical Fields
-
20. Grouping Date Fields
-
21. Calculated Fields
-
22. Calculated Items
-
23. Pivot Charts
-
24. Pivot Chart Formatting
-
25. Expanding & Collapsing Pivot Charts
Workbook Options & Settings
-
1. Objective Domain Intro
-
2. Enabling Macros
-
3. Copying Macros to Other Files
-
4. Linking Data Across Workbooks
-
5. Protecting Worksheets & Cell Ranges
-
6. Protecting & Encrypting Workbooks
-
7. Recovering Workbooks
-
8. Managing Comments
-
9. Formula Calculation Modes
-
10. Language Options
Practice Test
-
1. Practice Test Intro
-
2. Practice Test Structure
-
3. SOLUTION: Project 1
-
4. SOLUTION: Project 2
-
5. SOLUTION: Project 3
-
6. SOLUTION: Project 4
-
7. SOLUTION: Project 5
-
8. SOLUTION: Project 6
About MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course
MO-201: Microsoft Excel Expert (Excel and Excel 2019) certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's MO-201: Microsoft Excel Expert (Excel and Excel 2019) video training course for passing certification exams is the only solution which you need.
Pass Microsoft Excel Expert MO-201 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!

MO-201 Premium Bundle
- Premium File 24 Questions & Answers. Last update: May 29, 2025
- Training Course 92 Video Lectures
- Study Guide 204 Pages
Free MO-201 Exam Questions & Microsoft MO-201 Dumps | ||
---|---|---|
Microsoft.selftestengine.mo-201.v2025-03-23.by.sienna.22q.ete |
Views: 631
Downloads: 621
|
Size: 4.09 MB
|
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register