Section 1: Introduction
Section 2: Using Excel Spreadsheets for Data Analy
Section 3: Cleaning and Managing Data
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
How to Submit a PDU Claim (For Retaining PMP Certificate)
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
