Filters and Slicers | Master of Project Academy

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

Filters and Slicers

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll to Unlock