Certification training
92Lectures
8h 22mDuration
MicrosoftVendor
MO-201MO-201: Microsoft Excel Expert (Excel and Excel 2019) Certification Video Training Course
Prepare for your Microsoft exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.
Best seller
Microsoft certification training
MO-201
92 lessons arranged in a guided course path
Course overview
Study with a clear path.
Move through focused sections, review lecture timing, and return directly to the objectives that need more work.
Sequenced lessons
Follow the course in order or jump directly to the section you need to revisit.
Video-first prep
Use concise lecture blocks for technical review before moving into exam practice.
Fast access
Your purchased course becomes available in the member area after confirmed payment.
Curriculum
Course sections.
7 sections, 92 lessons, and lecture-level duration details.
01
Exam Structure
1m
02
Objective Domains & Skills Measured
2m
03
Exam Interface & Scheduling
2m
04
Helpful Resources
2m
01
Course Project Intro
1m
02
The Airbnb Dataset
8m
01
Objective Domain Intro
2m
02
Fixed vs
9m
03
Explicit vs
9m
04
Logical Operations
3m
05
The IF Function
6m
06
Nested IF Functions vs
8m
07
The NOT & “<>” Operators
5m
08
The AND/OR Operators
8m
09
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
01
Objective Domain Intro
1m
02
Custom Number Formats
7m
03
Data Validation
8m
04
Group & Ungroup Data
5m
05
Subtotals & Totals
5m
06
Removing Duplicates
9m
07
Auto Fill & Flash Fill
9m
08
Advanced Fill Series Options
5m
09
Conditional Formatting
8m
10
Formula-based Conditional Formatting
13m
11
Managing Conditional Formatting Rules
5m
12
PRO TIP: Hiding Values to Create Heatmaps
3m
01
Objective Domain Intro
2m
02
Box & Whisker Chart
8m
03
Histogram
6m
04
Filled Map
6m
05
Combo Chart
8m
06
Tree Map & Sunburst Chart
8m
07
Waterfall Chart
4m
08
Funnel Chart
4m
09
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
01
Objective Domain Intro
1m
02
Enabling Macros
3m
03
Copying Macros to Other Files
4m
04
Linking Data Across Workbooks
7m
05
Protecting Worksheets & Cell Ranges
6m
06
Protecting & Encrypting Workbooks
4m
07
Recovering Workbooks
3m
08
Managing Comments
6m
09
Formula Calculation Modes
4m
10
Language Options
4m
01
Practice Test Intro
2m
02
Practice Test Structure
3m
03
SOLUTION: Project 1
7m
04
SOLUTION: Project 2
5m
05
SOLUTION: Project 3
4m
06
SOLUTION: Project 4
6m
07
SOLUTION: Project 5
7m
08
SOLUTION: Project 6
3m