Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
The Data Analyst Skills Training (DAST) with Excel
Introduction to the DAST with Excel course
Your instructor (1:38)
Lecture 1: Course overview (3:51)
Module 1: Overview of data analytics and MS Excel
Live Interaction with Instructor
Lecture 2: Introduction to data analytics (3:07)
Lecture 3: What are the key data analyst skills you need to learn? (2:54)
Lecture 4: Data analyst vs data scientist? What is the difference? (3:26)
Lecture 5: Overview of Microsoft Excel (5:06)
Lecture 6: Getting familiar with MS Excel interface (4:31)
Lecture 7: Warm up with very basic excel functionalities (7:01)
Lecture 8: Understanding formatting in excel (4:13)
Lecture 9: Using the $ sign in Excel (5:35)
Lecture 10: Keyboard short cuts in Excel
Lecture 11: Recap: what did we learn Module 1? (1:16)
Lecture 12: Practice Assignment #1: DIFFICULTY LEVEL - EASY
Lecture 13: Solution to Practice Assignment #1
Lecture 14: Please provide us your valuable feedback on the course thus far
Surprise!
Module 2: Data cleaning and analysis using TEXT functions
Live Interaction with Instructor
Lecture 15: What will we learn in this module? (4:39)
Lecture 16: Download the excel template for this module (0:34)
Lecture 17: Illustration 1: Introduction (1:44)
Lecture 18: Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions (15:04)
Lecture 19: Illustration 2: Understanding the TRIM and FIND function (8:35)
Lecture 20: Illustration 2: Understanding the LEFT and MID function (12:28)
Lecture 21: Illustration 3: Introduction (1:44)
Lecture 22: Illustration 3: Understanding the SEARCH function (6:26)
Lecture 23: Illustration 3: Understanding the IFERROR function (3:33)
Lecture 24: Illustration 3: Understanding the IF function (3:32)
Lecture 25: Recap: what did we learn in Module 2 (0:52)
Lecture 26: Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
Lecture 27: Solution to Practice Assignment #2
Lecture 28: Please provide us your valuable feedback on the course thus far
Another surprise
Module 3: Data analysis and visualization using basic excel functions
Live Interaction with Instructor
Lecture 29: What will we learn in this module? (3:44)
Lecture 30: Download the Excel spreadsheet for this module (0:34)
Lecture 31: Let us look at the data for this illustration (2:55)
Lecture 32: Data Analysis: Understanding the SUMIF function (8:14)
Lecture 33: Data Analysis: Calculating growth rates (3:58)
Lecture 34: Data Analysis: Understanding the VLOOKUP function (11:40)
Lecture 35: Data Analysis: Understanding the HLOOKUP function (9:31)
Lecture 36: Data Analysis: Understanding the INDEX and MATCH function (13:56)
Lecture 37: Data Analysis: Understanding the IF, COUNTIF and COUNTIFS function (9:09)
Lecture 38: Data Visualization: Understanding the LINE chart (12:33)
Lecture 39: Data Visualization: Understanding the PIE chart (11:45)
Lecture 40: Data Visualization: Understanding the COLUMN chart (13:03)
Lecture 41: Data Visualization: Understanding the STACKED COLUMN chart (10:56)
Lecture 42: Data Visualization: Understanding the CONDITIONAL FORMATTING function (6:58)
Lecture 43: Recap: what did we learn in Module 3 (1:03)
Lecture 44: Practice Assignment #3 - Difficulty level: MEDIUM
Lecture 45: Solution to Practice Assignment #3
Lecture 46: Please provide us with your valuable feedback
One more surprise for you
Module 4: Data analysis using advanced excel functions
Live Interaction with Instructor
Lecture 47: What will we learn in this module? (2:52)
Lecture 48: Download the excel template for this module (0:34)
Lecture 49: Understanding the LIST function (5:45)
Lecture 50: Understanding the OFFSET function (8:30)
Lecture 51: Understanding the SUMPRODUCT function (8:24)
Lecture 52: Understanding the GOAL SEEK function (8:29)
Lecture 53: Understanding the INDEX-MATCH function (18:54)
Lecture 54: Understanding the PIVOT function (11:14)
Lecture 55: Understanding the INDIRECT function (11:31)
Lecture 56: Recap: what did we learn in Module 4? (0:51)
Lecture 57: Practice Assignment #4: DIFFICULTY LEVEL - MEDIUM
Lecture 58: Solution to Practice Assignment #4
Lecture 59: Please provide us your valuable feedback on the course thus far
The fourth surprise for you
Module 5: Advanced data visualization in excel
Live Interaction with Instructor
Lecture 60: What will be learn in this module? (1:41)
Lecture 61: Download the excel template for this module (0:34)
Lecture 62: Understanding the COMBINATION chart in excel (10:34)
Lecture 63: Understanding the WATERFALL chart in excel (14:16)
Lecture 64: Understanding the DYNAMIC LINE chart in excel (13:17)
Lecture 65: Understanding the AREA chart in excel (4:46)
Lecture 66: Understanding the INDEX chart in excel (10:01)
Lecture 67: Understanding the RADAR chart in excel (4:24)
Lecture 68: Understanding the SCATTER chart in excel (9:42)
Lecture 69: Understanding the BUBBLE chart in excel (6:24)
Lecture 70: Understanding the GANTT chart (11:46)
Lecture 71: Recap: what did we learn in Module 5? (0:55)
Lecture 72: Practice Assignment #5: DIFFICULTY LEVEL - MEDIUM
Lecture 73: Solution to Practice Assignment #5
Lecture 74: Please provide us your valuable feedback on the course thus far
Ready for one more surprise
Extra Videos - Miscellaneous Learnings
Live Interaction with Instructor
Lecture 77: Creating dynamic bar chart in Excel (8:38)
Lecture 76: 100 useful Excel shortcuts
End of course - what did we learn?
Lecture 77: Quick Recap (2:24)
Course Challenge
Solution to Course Challenge
Claim your certificate of completion
Lecture 74: Please provide us your valuable feedback on the course thus far
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock