MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course

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

2m 1. Objective Domain Intro 9m 2. Fixed vs 9m 3. Explicit vs 3m 4. Logical Operations 6m 5. The IF Function 8m 6. Nested IF Functions vs 5m 7. The NOT & “<>” Operators 8m 8. The AND/OR Operators 9m 9. The SWITCH Function 8m 10. The COUNTIF/SUMIF/AVERAGEIF Functions 9m 11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria 4m 12. The MINIFS & MAXIFS Functions 7m 13. Excel Date Values & Formatting 6m 14. PRO TIP: Converting Text to Dates 5m 15. The TODAY & NOW Functions 3m 16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND 6m 17. WEEKDAY, WORKDAY & NETWORKDAYS 7m 18. Recording a Macro 3m 19. Modifying & Deleting Macros 4m 20. PRO TIP: Adding Form Controls 1m 21. Lookup Functions 14m 22. The VLOOKUP & HLOOKUP Functions 3m 23. The INDEX Function 4m 24. The MATCH Function 10m 25. Combining INDEX & MATCH 5m 26. Approximate Match Lookups 10m 27. The PMT & NPER Functions 6m 28. Scenario Manager 7m 29. Consolidate Data 5m 30. Goal Seek 12m 31. Formula Auditing

1m 1. Objective Domain Intro 7m 2. Custom Number Formats 8m 3. Data Validation 5m 4. Group & Ungroup Data 5m 5. Subtotals & Totals 9m 6. Removing Duplicates 9m 7. Auto Fill & Flash Fill 5m 8. Advanced Fill Series Options 8m 9. Conditional Formatting 13m 10. Formula-based Conditional Formatting 5m 11. Managing Conditional Formatting Rules 3m 12. PRO TIP: Hiding Values to Create Heatmaps

2m 1. Objective Domain Intro 8m 2. Box & Whisker Chart 6m 3. Histogram 6m 4. Filled Map 8m 5. Combo Chart 8m 6. Tree Map & Sunburst Chart 4m 7. Waterfall Chart 4m 8. Funnel Chart 8m 9. Creating a Pivot Table 5m 10. Modifying Pivot Table Views 6m 11. "Summarize Values By" Options 9m 12. "Show Values As" Calculations 1m 13. Analyze & Design Tabs 4m 14. Report Layouts & Options 4m 15. Number Formatting 7m 16. Sorting & Filtering 5m 17. Slicers & Timelines 3m 18. Grouping Text Fields 6m 19. Grouping Numerical Fields 5m 20. Grouping Date Fields 7m 21. Calculated Fields 5m 22. Calculated Items 5m 23. Pivot Charts 2m 24. Pivot Chart Formatting 3m 25. Expanding & Collapsing Pivot Charts

1m 1. Objective Domain Intro 3m 2. Enabling Macros 4m 3. Copying Macros to Other Files 7m 4. Linking Data Across Workbooks 6m 5. Protecting Worksheets & Cell Ranges 4m 6. Protecting & Encrypting Workbooks 3m 7. Recovering Workbooks 6m 8. Managing Comments 4m 9. Formula Calculation Modes 4m 10. Language Options

2m 1. Practice Test Intro 3m 2. Practice Test Structure 7m 3. SOLUTION: Project 1 5m 4. SOLUTION: Project 2 4m 5. SOLUTION: Project 3 6m 6. SOLUTION: Project 4 7m 7. SOLUTION: Project 5 3m 8. SOLUTION: Project 6