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
Live Instructor Led Sessions
Your Instructor (1:38)
Lecture 1: Course overview (3:51)
Module 1: Overview of data analytics and MS Excel
Pre-Assessment Quiz by Rakesh Sud
Live Instructor Led Sessions
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
Pre-Assessment Quiz by Rakesh Sud
Live Instructor Led Sessions
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
Pre-Assessment Quiz by Rakesh Sud
Live Instructor Led Sessions
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
Pre-Assessment Quiz by Rakesh Sud
Live Instructor Led Sessions
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:12)
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
Pre-Assessment Quiz by Rakesh Sud
Live Instructor Led Sessions
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 75: Creating dynamic bar chart in Excel (8:38)
Lecture 76: 100 useful Excel shortcuts
Lecture 77 - Assignment : Dynamic Bar Charts
Lecture 78 - Assignment : Waterfall Chart
Lecture 79 - Assignment : Gantt Chart
End of course - what did we learn?
Lecture 80: 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