Exclusive SALE Offer Today

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.
$13.99$19.99
Curriculum For This Course

  • 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

How to Open Test Engine .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

DumpsArena Test Engine

Windows

Refund Policy
Refund Policy

DumpsArena.com has a remarkable success record. We're confident of our products and provide a no hassle refund policy.

How our refund policy works?

safe checkout

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.

Need Help Assistance?