Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel® Training Advanced - 9 Hours Online MS Excel Advanced Course
Chapter 1: Introduction
Welcome to Master of Project Academy (1:19)
How to Utilize Advanced Microsoft Excel Training?
Prerequisites of the Course and Version of Excel (6:39)
Course Structure (4:19)
Download Course Files
Chapter 2: Functions
Functions - Part 1 (13:38)
Functions - Part 2 (10:08)
Autosum (6:01)
Quiz
Tip #1 - Join LinkedIn Community
Join LinkedIn Community & Follow Latest Updates
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)
Quiz
Chapter 4: Text Functions
Using Text Functions - Part 1 (10:12)
Using Text Functions - Part 2 (12:12)
Quiz
Chapter 5: Logical Functions
Using Logical Functions (9:44)
Exercise 01 (1:58)
Quiz
Chapter 6: Lookup Functions
HLOOKUP Function (14:02)
VLOOKUP Function (7:56)
Exercise 02 (5:37)
Quiz
Chapter 7: Financial Functions
Financial Functions and Terminology (8:51)
Personal Financial Functions (9:18)
Professional Financial Functions (7:23)
Depreciation (5:04)
Exercise 03 (1:37)
Quiz
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)
Quiz
Chapter 9: Connecting to External Data
Connecting to Other Workbooks (13:12)
Connecting to Access Databases (12:50)
Connecting to Web Data Sources (7:52)
Get and Transform (14:37)
Exercise 05 (5:06)
Quiz
Chapter 10: Tables
Introduction to Tables (12:13)
Working with Tables (10:40)
Table References (8:31)
Table Styles (5:33)
Exercise 06 (1:21)
Quiz
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 07 (2:28)
Quiz
Chapter 12: Data Analysis
What If Analysis (10:15)
Scenario Manager (11:21)
Goal Seek (7:25)
Solver (12:00)
Exercise 08 (1:43)
Quiz
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)
Quiz
Chapter 14: Excel Web App
Introduction to Excel Web App (10:07)
Using the Excel Web App (9:52)
Quiz
Chapter 15: Course Conclusion
Closing Message (0:49)
How to Submit a PDU Claim (For Retaining PMP Certificate)
How to Submit PDUs
Bonus Lecture - Discount for our paid courses
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
Important Notice About Certificate of Completion
Teach online with
VLOOKUP Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock