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

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

$14.99 / $24.99

About the MO-201 Exam

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

The Course Project

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

Advanced Formulas & Macros

  • 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

Managing & Formatting Data

  • 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

Advanced Charts & Pivot Tables

  • 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

Workbook Options & Settings

  • 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

Practice Test

  • 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