Pass IT Certication
Exams Guaranteed!

100% Real Questions from Actual Test
Accurate Answers Verified by Experts
Free New Questions Updates
99.8% Pass Rate Guaranteed
Exam Simulator Included!

MO-201: Microsoft Excel Expert (Excel and Excel 2019)

PDFs and exam guides are not so efficient, right? 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.

91 Students Enrolled 92 Lectures 08:22:00 Hours

Curriculum For This Course

About the MO-201 Exam

4Lectures

Time 00:07:00

The Course Project

2Lectures

Time 00:09:00

Advanced Formulas & Macros

31Lectures

Time 03:18:00

Managing & Formatting Data

12Lectures

Time 01:18:00

Advanced Charts & Pivot Tables

25Lectures

Time 02:11:00

Workbook Options & Settings

10Lectures

Time 00:42:00

Practice Test

8Lectures

Time 00:37:00

About the MO-201 Exam
	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
	1. Course Project Intro	1:00
	2. The Airbnb Dataset	8:00

Advanced Formulas & Macros
	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
	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
	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
	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
	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