Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Excel for Data Analysis
Module One: Think like a Data Analyst
Course Introduction
What is Data Analysis?
Data Analysis Workflow
Weekly Supplementary Reading
The Business Problem
Module 1 Lab
Module 1 Quiz
Module Two: Cleansing your Data
Data Cleansing Importance
Getting started with Data Cleansing
Week 2 Live Lecture (Recording) (61:51)
Weekly Reading Review
Practice Exercise
Data Cleansing Continued
Weekly Reading Review
Weekly Supplementary Video
Module 2 Lab - 2
Module 2 Quiz - 2
Module 2 Discussion
Module Three: Begin your analysis
Week 3 Introduction
Congrats on your new role!
Week 3 p1 Live Lecture (Recording) (85:22)
SUBTOTAL and Logical Functions
Nested IF AND Statements and VLOOKUPS
Week 3 p2 Live Lecture (Recording) (46:15)
Weekly Supplementary Material Part 1
Weekly Supplementary Material Part 2
Midweek Lab (Questions for our upcoming radio show)
Weekly Supplementary Material Part 3
INDEX, MATCH AND Pivot Tables
Module Three Lab 2 - Radio Show follow up questions.
Module Four: Introduction to PowerQuery
Week 4 Introduction
What is PowerQuery
Weekly Supplementary Material
Week 4 Live Lecture (Recording) (45:01)
Module Five: Interactive Dashboards in Excel
Week 5 Introduction
Weekly Supplementary Material
Week 5 Live Lecture (Recording) (20:23)
Final Excel Project
Congrats on your new role!
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock