Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2019 - Advanced Course
Chapter 1: Introduction to Excel 2019 Advanced Course
Introduction to the Course (6:39)
Course Structure (4:19)
Course Exercise Files
Course Demo Files
Chapter 2: Functions
Functions - Part 1 (13:38)
Functions - Part 2 (8:04)
Autosum (6:01)
Chapter 3: Date and Time Functions
How Date and Time Works (9:59)
Basic Date and Time Functions (9:43)
Complex Date and Time Functions (10:38)
Chapter 4: Text Functions
Using Text Functions - Part 1 (12:21)
Using Text Functions - Part 2 (12:12)
Chapter 5: Logical Functions
Logical Functions (9:44)
Exercise 01 (1:58)
Chapter 6: Lookup Functions
Lookup Functions - Part 1 (14:02)
Lookup Functions - Part 2 (7:56)
Exercise 02 (5:37)
Chapter 7: Financial Functions
Financial Functions and Terminology (8:51)
Personal Financial Functions (9:18)
Principal and Interest Payments (7:23)
Depreciation (5:04)
Exercise 03 (1:37)
Chapter 8: Statistical Functions
Statistical Functions for Description - Part 1 (13:31)
Statistical Functions for Description - Part 2 (13:43)
Statistical Functions for Forecasting - Part 1 (11:54)
Statistical Functions for Forecasting - Part 2 (11:45)
Exercise 04 (1:45)
One Click Forecasting (8:56)
Statistical Functions for Inference (11:09)
Chapter 9: Connecting to External Data
Connecting to Other workbooks (13:09)
Connecting to Access Databases (12:50)
Connecting Web Data Sources (7:52)
Get and Transform (14:25)
Exercise 5 (5:06)
Chapter 10: Tables
Introduction to Tables (12:13)
Working with Tables (10:40)
Table References (8:31)
Table Styles (5:33)
Exercise 6 (1:21)
Chapter 11: Pivot Tables
Introduction to Pivot Tables (9:50)
Working with Pivot Tables (12:43)
Filters and Slicers (12:25)
Pivot Charts (8:30)
Exercise 7 (2:28)
Chapter 12: Data Analysis
What If Analysis (10:15)
Scenario Manager (11:21)
Goal Seek (7:25)
Solver (12:00)
Exercise 8 (1:43)
Chapter 13: Graphs and Charts
Area Charts (6:40)
Surface Charts (4:40)
Radar Charts (5:21)
Bubble Charts (7:19)
Sparklines (9:33)
Stock Charts (9:06)
Exercise 09 (3:33)
Chapter 14: Excel Web App
Web App - Part 1 (10:07)
Web App - Part 2 (9:52)
Chapter 15: Course Conclusion
Close (0:49)
Course Quiz and Certificate of Completion
Exercise 04
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock