Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Data Analytics in Microsoft Excel Online Training
Section 1: Introduction
Welcome to Master of Project Academy (1:19)
How to Utilize Microsoft Excel for Business Analysts Training?
Introduction to the Course (5:00)
Navigating Excel (9:52)
Data Types in Excel (5:57)
Quiz
Course and Exercise Files
Section 2: Using Excel Spreadsheets for Data Analy
Viewing and Entering Data (8:55)
Formatting and Data Types in Excel (8:44)
Excel Formula Basics (9:44)
Exploring Excel Functions (9:38)
Referencing Data in Formulas (8:51)
Exercise 1 (3:57)
Quiz
Section 3: Cleaning and Managing Data
Introduction to Data Quality (10:00)
Importing File Data (5:37)
Removing Duplicate Data (7:49)
Identifying Data Attributes (8:25)
Cleaning Data (7:34)
Exercise 2 (2:21)
Quiz
Section 4: Analyzing Data
Sort and Filter Data (6:59)
Concatenation and SUMIF (6:53)
Tackling Complicated "OR" Criteria (6:52)
Summarizing Data Using Pivot Tables (7:29)
Creating a Pivot Chart (6:34)
Working with Excel Charts (5:14)
Analysing Financial Data (9:18)
Waterfall Charts (7:26)
Conditional Formatting (7:07)
Using Database Functions (7:13)
Evading Formula Errors (8:05)
Exercise 3 (2:01)
Quiz
Section 5: What-If Analysis and Analysis ToolPak
Scenario Manager in What-If Analysis (9:54)
Data Tables in What-If Analysis (8:41)
Goal Seek in What-If Analysis (7:04)
Loading the Analysis ToolPak (3:10)
Correlation and Covariance in Analysis ToolPak (7:31)
Descriptive Statistics, Moving Average and Exponential Smoot (8:01)
Additional Analytical and Statistical Applications (8:43)
Exercise 4 (3:54)
Interactive: Vantage Auto Parts: From Raw Data to Executive Insights in Excel Case Study
Closing (4:55)
Quiz
Tip #1 - Join LinkedIn Community
Join LinkedIn Community & Follow Latest Updates
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
Interactive: Vantage Auto Parts: From Raw Data to Executive Insights in Excel Case Study
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock