Training Video Course

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.

Rating
4.55rating
Students
109
Duration
08:22:00 h
$16.49
$14.99

Curriculum for MO-201 Video Course

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

Download Microsoft Excel Expert MO-201 Exam Questions & Answers

Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!

Microsoft MO-201 Premium Bundle
$69.97
$49.99

MO-201 Premium Bundle

  • Premium File: 24 Questions & Answers. Last update: Oct 21, 2021
  • Training Course: 92 Video Lectures
  • Study Guide: 204 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
Get Unlimited Access to ALL Premium Files

MO-201 Premium Bundle

Microsoft MO-201 Premium Bundle
  • Premium File: 24 Questions & Answers. Last update: Oct 21, 2021
  • Training Course: 92 Video Lectures
  • Study Guide: 204 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$69.97
$49.99
Get Unlimited Access to ALL Premium Files

Free MO-201 Exam Questions & MO-201 Dumps

File Name Size Votes
File Name
microsoft.test4prep.mo-201.v2021-05-05.by.caleb.8q.vce
Size
30.46 MB
Votes
2

Comments (0)

Add Comment

Please post your comments about MO-201 Exams. Don't share your email address asking for MO-201 braindumps or MO-201 exam pdf files.

Add Comment

Purchase Individually

MO-201  Premium File
MO-201
Premium File
24 Q&A
$43.99 $39.99
MO-201  Training Course
MO-201
Training Course
92 Lectures
$16.49 $14.99
MO-201  Study Guide
MO-201
Study Guide
204 Pages
$16.49 $14.99

Microsoft Training Courses

Technology Literacy for Educators Training Course
62-193
Technology Literacy for Educators
$14.99
Excel 2013 Training Course
77-420
Excel 2013
$14.99
Excel 2016: Core Data Analysis, Manipulation, and Presentation Training Course
77-727
Excel 2016: Core Data Analysis, Manipulation, and Presentation
$14.99
SharePoint 2010 Training Course
77-886
SharePoint 2010
$14.99
Windows Operating System Fundamentals Training Course
98-349
Windows Operating System Fundamentals
$14.99
Software Development Fundamentals Training Course
98-361
Software Development Fundamentals
$14.99
Database Fundamentals Training Course
98-364
Database Fundamentals
$14.99
Windows Server Administration Fundamentals Training Course
98-365
Windows Server Administration Fundamentals
$14.99
Networking Fundamentals Training Course
98-366
Networking Fundamentals
$14.99
Security Fundamentals Training Course
98-367
Security Fundamentals
$14.99
Introduction to Programming Using Python Training Course
98-381
Introduction to Programming Using Python
$14.99
Microsoft Azure AI Fundamentals Training Course
AI-900
Microsoft Azure AI Fundamentals
$14.99
Microsoft Azure Administrator Training Course
AZ-104
Microsoft Azure Administrator
$14.99
Configuring and Operating Windows Virtual Desktop on Microsoft Azure Training Course
AZ-140
Configuring and Operating Windows Virtual Desktop on Microsoft Azure
$14.99
Developing Solutions for Microsoft Azure Training Course
AZ-204
Developing Solutions for Microsoft Azure
$14.99
Microsoft Azure Architect Technologies Training Course
AZ-303
Microsoft Azure Architect Technologies
$14.99
Microsoft Azure Architect Design Training Course
AZ-304
Microsoft Azure Architect Design
$14.99
Microsoft Azure DevOps Solutions Training Course
AZ-400
Microsoft Azure DevOps Solutions
$14.99
Microsoft Azure Security Technologies Training Course
AZ-500
Microsoft Azure Security Technologies
$14.99
Microsoft Azure Fundamentals Training Course
AZ-900
Microsoft Azure Fundamentals
$14.99
Analyzing Data with Microsoft Power BI Training Course
DA-100
Analyzing Data with Microsoft Power BI
$14.99
Designing and Implementing a Data Science Solution on Azure Training Course
DP-100
Designing and Implementing a Data Science Solution on Azure
$14.99
Data Engineering on Microsoft Azure Training Course
DP-203
Data Engineering on Microsoft Azure
$14.99
Microsoft Azure Data Fundamentals Training Course
DP-900
Microsoft Azure Data Fundamentals
$14.99
Microsoft Dynamics 365 for Sales Training Course
MB-210
Microsoft Dynamics 365 for Sales
$14.99
Microsoft Dynamics 365 for Customer Service Training Course
MB-230
Microsoft Dynamics 365 for Customer Service
$14.99
Microsoft Dynamics 365 for Field Service Training Course
MB-240
Microsoft Dynamics 365 for Field Service
$14.99
Microsoft Dynamics 365: Core Finance and Operations Training Course
MB-300
Microsoft Dynamics 365: Core Finance and Operations
$14.99
Microsoft Dynamics 365 Finance Training Course
MB-310
Microsoft Dynamics 365 Finance
$14.99
Microsoft Dynamics 365 Business Central Functional Consultant Training Course
MB-800
Microsoft Dynamics 365 Business Central Functional Consultant
$14.99
Microsoft Dynamics CRM 2016 Customization and Configuration Training Course
MB2-712
Microsoft Dynamics CRM 2016 Customization and Configuration
$14.99
Windows 10 Training Course
MD-100
Windows 10
$14.99
Managing Modern Desktops Training Course
MD-101
Managing Modern Desktops
$14.99
Microsoft Excel (Excel and Excel 2019) Training Course
MO-200
Microsoft Excel (Excel and Excel 2019)
$14.99
Microsoft Excel Expert (Excel and Excel 2019) Training Course
MO-201
Microsoft Excel Expert (Excel and Excel 2019)
$14.99
Microsoft 365 Identity and Services Training Course
MS-100
Microsoft 365 Identity and Services
$14.99
Microsoft 365 Mobility and Security Training Course
MS-101
Microsoft 365 Mobility and Security
$14.99
Microsoft 365 Messaging Training Course
MS-203
Microsoft 365 Messaging
$14.99
Microsoft 365 Security Administration Training Course
MS-500
Microsoft 365 Security Administration
$14.99
Managing Microsoft Teams Training Course
MS-700
Managing Microsoft Teams
$14.99
Microsoft 365 Fundamentals Training Course
MS-900
Microsoft 365 Fundamentals
$14.99
Microsoft Power Platform App Maker Training Course
PL-100
Microsoft Power Platform App Maker
$14.99
Microsoft Power Platform Functional Consultant Training Course
PL-200
Microsoft Power Platform Functional Consultant
$14.99
Microsoft Power Platform Fundamentals Training Course
PL-900
Microsoft Power Platform Fundamentals
$14.99
Microsoft Identity and Access Administrator Training Course
SC-300
Microsoft Identity and Access Administrator
$14.99
Microsoft Security, Compliance, and Identity Fundamentals Training Course
SC-900
Microsoft Security, Compliance, and Identity Fundamentals
$14.99

Microsoft Certifications

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

UP

LIMITED OFFER: GET 30% Discount

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 30% Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.