Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2016 Advanced Training Master Class
Chapter 1: Introduction to Excel 2016 Advanced Course
Prerequisites of the Course and Version of Excel (8:36)
Course Structure (4:59)
StreamSkill.com Excel 2016 Advanced Course Exercise Files
StreamSkill.com Excel 2016 Advanced Course Demo Files
Chapter 2: Functions
Functions - Part 1 (15:41)
Functions - Part 2 (10:44)
Autosum (6:22)
Chapter 3: Date and Time Functions
How Date and Time Works (11:20)
Basic Date and Time Functions (11:56)
Complex Date and Time Functions (14:45)
Chapter 4: Text Functions
Using Text Functions - Part 1 (14:38)
Using Text Functions - Part 2 (15:07)
Chapter 5: Logical Functions
Using Logical Functions (11:14)
Exercise 01 (2:20)
Chapter 6: Lookup Functions
HLOOKUP Function (15:17)
VLOOKUP Function (8:57)
Exercise 02 (6:05)
Chapter 7: Financial Functions
Financial Functions and Terminology (11:20)
Personal Financial Functions (10:41)
Professional Financial Functions (7:48)
Depreciation (5:15)
Exercise 03 (1:45)
Chapter 8: Statistical Functions
Statistical Functions for Description - Part 1 (14:23)
Statistical Functions for Description - Part 2 (14:27)
Statistical Functions for Forecasting - Part 1 (12:16)
Statistical Functions for Forecasting - Part 2 (12:29)
Exercise 04 (1:44)
One Click Forecasting (9:16)
Statistical Functions for Inference (12:52)
Chapter 9: Connecting to External Data
Connecting to Other Workbooks (15:21)
Connecting to Access Databases (15:20)
Connecting to Web Data Sources (10:11)
Get and Transform (15:07)
Exercise 05 (5:57)
Chapter 10: Tables
Introduction to Tables (12:04)
Working with Tables (10:37)
Table References (8:09)
Table Styles (4:59)
Exercise 06 (1:40)
Chapter 11: Pivot Tables
Introduction to Pivot Tables (11:01)
Working with Pivot Tables (14:58)
Filters and Slicers (14:23)
Pivot Charts (8:42)
Exercise 07 (2:48)
Chapter 12: Data Analysis
What If Analysis (13:38)
Scenario Manager (10:27)
Goal Seek (7:10)
Solver (12:29)
Exercise 08 (1:33)
Chapter 13: Graphs and Charts
Area Charts (6:42)
Surface Charts (4:45)
Radar Charts (5:12)
Bubble Charts (7:06)
Sparklines (9:58)
Stock Charts (10:36)
Exercise 09 (3:57)
Chapter 14: Excel Web App
Introduction to Excel Web App (10:47)
Using the Excel Web App (11:31)
Chapter 15: Course Conclusion
Closing Message (0:49)
Course Quiz and Certificate of Completion
VLOOKUP Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock