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
Using Text Functions - Part 1
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock