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
How to Open Test Engine .dumpsqueen Files
Use FREE DumpsQueen Test Engine player to open .dumpsqueen files
Your purchase with DumpsQueen.com is safe and fast.
The DumpsQueen.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.