MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course
Best Seller
92 Lectures
8h 22m
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.
$14.99$24.99
Curriculum For This Course
- 1. Exam Structure 1m
- 2. Objective Domains & Skills Measured 2m
- 3. Exam Interface & Scheduling 2m
- 4. Helpful Resources 2m
- 1. Course Project Intro 1m
- 2. The Airbnb Dataset 8m
- 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 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 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 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. 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
Hot Exams
IAPP CIPM Exam Dumps
CompTIA CS0-003 Exam Dumps
Amazon AWS SAA-C03 Exam Dumps
Microsoft AZ-800 Exam Dumps
Microsoft AZ-801 Exam Dumps
Microsoft AZ-305 Exam Dumps
CompTIA N10-008 Exam Dumps
Fortinet NSE6_FWF-6.4 Exam Dumps
SAP C_TS410_2020 Exam Dumps
CompTIA PT0-002 Exam Dumps
MSP MSP-Foundation Exam Dumps
ECCouncil 312-39 Exam Dumps
Microsoft MB-700 Exam Dumps
Cisco 350-901 Exam Dumps
Cisco 350-501 Exam Dumps
Amazon AWS AWS-Certified-Machine-Learning-Specialty-MLS-C01 Exam Dumps
Cisco 300-435 Exam Dumps
Microsoft AZ-900 Exam Dumps
Microsoft AZ-400 Exam Dumps
C++ Institute CPA Exam Dumps
Amazon AWS SAA-C03 Exam Dumps
CompTIA 220-1102 Exam Dumps
CompTIA CS0-003 Exam Dumps
Isaca CISM Exam Dumps
PMI PMP Exam Dumps
Amazon AWS AWS-Certified-Machine-Learning-Specialty-MLS-C01 Exam Dumps
CompTIA 220-1101 Exam Dumps
Microsoft SC-100 Exam Dumps
Fortinet NSE4_FGT-7.2 Exam Dumps
CompTIA SY0-701 Exam Dumps
ISC2 CISSP Exam Dumps
Microsoft AZ-900 Exam Dumps
Cisco 200-301 Exam Dumps
IAPP CIPM Exam Dumps
Microsoft SC-200 Exam Dumps
SAP C_TS410_2020 Exam Dumps
Isaca CRISC Exam Dumps
Huawei H19-301 Exam Dumps
ISC2 CCSP Exam Dumps
Exin SIAMF Exam Dumps
How to Open Test Engine .dumpsarena Files
Use FREE DumpsArena Test Engine player to open .dumpsarena files
Refund Policy
DumpsArena.com has a remarkable success record. We're confident of our products and provide a no hassle refund policy.
Your purchase with DumpsArena.com is safe and fast.
The DumpsArena.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.