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)
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
Additional Analytical and Statistical Applications
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock