Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to Data Analysis with Excel
Section 1: Course Introduction
Introduction to the Course (5:00)
Navigating Excel (9:52)
Data Types in Excel (5:57)
DOWNLOAD ME: Course Instructor and Exercise Files
Section 2: Using Excel Spreadsheets for Data Analysis
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)
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)
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)
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 Smoothing (8:01)
Additional Analytical and Statistical Applications (8:43)
Exercise 4 (3:54)
Closing (4:55)
Course Quiz and Certificate of Completion
Viewing and Entering Data
Complete and Continue