Curriculum For This Course
-
About the MO-201 Exam
4 Lectures Time 00:07:00 -
The Course Project
2 Lectures Time 00:09:00 -
Advanced Formulas & Macros
31 Lectures Time 03:18:00 -
Managing & Formatting Data
12 Lectures Time 01:18:00 -
Advanced Charts & Pivot Tables
25 Lectures Time 02:11:00 -
Workbook Options & Settings
10 Lectures Time 00:42:00 -
Practice Test
8 Lectures Time 00:37:00
Video tutorials list
-
About the MO-201 Exam
Video Name Time 1. Exam Structure 1:00 2. Objective Domains & Skills Measured 2:00 3. Exam Interface & Scheduling 2:00 4. Helpful Resources 2:00 -
The Course Project
Video Name Time 1. Course Project Intro 1:00 2. The Airbnb Dataset 8:00 -
Advanced Formulas & Macros
Video Name Time 1. Objective Domain Intro 2:00 2. Fixed vs. Relative References 9:00 3. Explicit vs. Structured References 9:00 4. Logical Operations 3:00 5. The IF Function 6:00 6. Nested IF Functions vs. The IFS Function 8:00 7. The NOT & “<>” Operators 5:00 8. The AND/OR Operators 8:00 9. The SWITCH Function 9:00 10. The COUNTIF/SUMIF/AVERAGEIF Functions 8:00 11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria 9:00 12. The MINIFS & MAXIFS Functions 4:00 13. Excel Date Values & Formatting 7:00 14. PRO TIP: Converting Text to Dates 6:00 15. The TODAY & NOW Functions 5:00 16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND 3:00 17. WEEKDAY, WORKDAY & NETWORKDAYS 6:00 18. Recording a Macro 7:00 19. Modifying & Deleting Macros 3:00 20. PRO TIP: Adding Form Controls 4:00 21. Lookup Functions 1:00 22. The VLOOKUP & HLOOKUP Functions 14:00 23. The INDEX Function 3:00 24. The MATCH Function 4:00 25. Combining INDEX & MATCH 10:00 26. Approximate Match Lookups 5:00 27. The PMT & NPER Functions 10:00 28. Scenario Manager 6:00 29. Consolidate Data 7:00 30. Goal Seek 5:00 31. Formula Auditing 12:00 -
Managing & Formatting Data
Video Name Time 1. Objective Domain Intro 1:00 2. Custom Number Formats 7:00 3. Data Validation 8:00 4. Group & Ungroup Data 5:00 5. Subtotals & Totals 5:00 6. Removing Duplicates 9:00 7. Auto Fill & Flash Fill 9:00 8. Advanced Fill Series Options 5:00 9. Conditional Formatting 8:00 10. Formula-based Conditional Formatting 13:00 11. Managing Conditional Formatting Rules 5:00 12. PRO TIP: Hiding Values to Create Heatmaps 3:00 -
Advanced Charts & Pivot Tables
Video Name Time 1. Objective Domain Intro 2:00 2. Box & Whisker Chart 8:00 3. Histogram 6:00 4. Filled Map 6:00 5. Combo Chart 8:00 6. Tree Map & Sunburst Chart 8:00 7. Waterfall Chart 4:00 8. Funnel Chart 4:00 9. Creating a Pivot Table 8:00 10. Modifying Pivot Table Views 5:00 11. "Summarize Values By" Options 6:00 12. "Show Values As" Calculations 9:00 13. Analyze & Design Tabs 1:00 14. Report Layouts & Options 4:00 15. Number Formatting 4:00 16. Sorting & Filtering 7:00 17. Slicers & Timelines 5:00 18. Grouping Text Fields 3:00 19. Grouping Numerical Fields 6:00 20. Grouping Date Fields 5:00 21. Calculated Fields 7:00 22. Calculated Items 5:00 23. Pivot Charts 5:00 24. Pivot Chart Formatting 2:00 25. Expanding & Collapsing Pivot Charts 3:00 -
Workbook Options & Settings
Video Name Time 1. Objective Domain Intro 1:00 2. Enabling Macros 3:00 3. Copying Macros to Other Files 4:00 4. Linking Data Across Workbooks 7:00 5. Protecting Worksheets & Cell Ranges 6:00 6. Protecting & Encrypting Workbooks 4:00 7. Recovering Workbooks 3:00 8. Managing Comments 6:00 9. Formula Calculation Modes 4:00 10. Language Options 4:00 -
Practice Test
Video Name Time 1. Practice Test Intro 2:00 2. Practice Test Structure 3:00 3. SOLUTION: Project 1 7:00 4. SOLUTION: Project 2 5:00 5. SOLUTION: Project 3 4:00 6. SOLUTION: Project 4 6:00 7. SOLUTION: Project 5 7:00 8. SOLUTION: Project 6 3:00
Add Comment