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

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 $24.99

Curriculum For This Course

4 lectures 7m
  • 1. Exam Structure
    1m
  • 2. Objective Domains & Skills Measured
    2m
  • 3. Exam Interface & Scheduling
    2m
  • 4. Helpful Resources
    2m

2 lectures 9m
  • 1. Course Project Intro
    1m
  • 2. The Airbnb Dataset
    8m

31 lectures 3h 18m
  • 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

12 lectures 1h 18m
  • 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

25 lectures 2h 11m
  • 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

10 lectures 42m
  • 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

8 lectures 37m
  • 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
VTSimu
VTSimu Exam Simulator
How to open .dumpsarena files

Use Free VTSimu Exam Simulator to open .dumpsarena files

VTSimu Exam Simulator

Windows Mac Learn More
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support