- Vendors
- ACAMS
- APICS
- Checkpoint
- Cisco
- Citrix
- CNCF
- CompTIA
- CSA
- CyberArk
- Fortinet
- Genesys
- GIAC
- HashiCorp
- HP
- Huawei
- IAPP
- IIA
- IIBA
- ISC
- ISTQB
- ITIL
- Juniper
- Linux Foundation
- LPI
- Microsoft
- NetSuite
- Network Appliance
- Nutanix
- Palo Alto Networks
- PMI
- PRINCE2
- Python Institute
- RedHat
- Salesforce
- SAP
- Scrum
- ServiceNow
- Snowflake
- Splunk
- Test Prep
- The Open Group
- UiPath
- Veeam
- VMware
- Certifications
- Video Courses
- What we offer
- FAQs
- My Account
- Shopping Cart
- Home
- Video Courses
- MO-201 (Microsoft Excel Expert (Excel and Excel 2019))
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
1. About the MO-201 Exam
4 Lectures
00:07:00
2. The Course Project
2 Lectures
00:09:00
3. Advanced Formulas...
31 Lectures
03:18:00
4. Managing &...
12 Lectures
01:18:00
5. Advanced Charts...
25 Lectures
02:11:00
6. Workbook Options...
10 Lectures
00:42:00
7. Practice Test
8 Lectures
00:37:00
About the MO-201 Exam
| Video Name | Time | |
|---|---|---|
| 1. Exam Structure | 1:00 | |
| 2. Objective Domains & Skills Measured | 2:00 | |
| 3. Exam Interface & Scheduling | 2:00 | |
| 4. Helpful Resources | 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 | |
| 8. Managing Comments | 6: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
Similar Courses
45 Lectures
1 h
34 Lectures
3 h
48 Lectures
5 h
10 Lectures
3 h
12 Lectures
6 h
10 Lectures
4 h
66 Lectures
6 h
10 Lectures
7 h
Only Registered Members can View Training Courses
Please fill out your email address below in order to view Training 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
1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo
