Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Premium : Data Analysis Skills with Excel Bootcamp
Itinerary of this Learning Journey: An Introduction to the DAST with Excel course
Your Captain of this Journey: Your Instructor (1:38)
1: Welcome On Board: Course overview (3:51)
Module 1: Overview of data analytics and MS Excel
Pre-Assessment Quiz by Rakesh Sud
2: Introduction to data analytics (3:07)
3: What are the key data analyst skills you need to learn? (2:54)
4: Data analyst vs data scientist? What is the difference? (3:26)
5: Overview of Microsoft Excel (5:06)
6: Getting familiar with MS Excel interface (4:31)
7: Warm up with very basic excel functionalities (7:01)
8: Understanding formatting in excel (4:13)
9: Using the $ sign in Excel (5:35)
10: Keyboard short cuts in Excel
11: Recap: what did we learn Module 1? (1:16)
12: Practice Assignment #1: DIFFICULTY LEVEL - EASY
13: Solution to Practice Assignment #1
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
15: What will we learn in this module? (4:39)
16: Download the excel template for this module (0:34)
17: Illustration 1: Introduction (1:44)
18: Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions (15:04)
19: Illustration 2: Understanding the TRIM and FIND function (8:35)
20: Illustration 2: Understanding the LEFT and MID function (12:28)
21: Illustration 3: Introduction (1:44)
22: Illustration 3: Understanding the SEARCH function (6:26)
23: Illustration 3: Understanding the IFERROR function (3:33)
24: Illustration 3: Understanding the IF function (3:32)
25: Recap: what did we learn in Module 2 (0:52)
26: Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
27: Solution to Practice Assignment #2
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
29: What will we learn in this module? (3:44)
30: Download the Excel spreadsheet for this module (0:34)
31: Let us look at the data for this illustration (2:55)
32: Data Analysis: Understanding the SUMIF function (8:14)
33: Data Analysis: Calculating growth rates (3:58)
34: Data Analysis: Understanding the VLOOKUP function (11:40)
35: Data Analysis: Understanding the HLOOKUP function (9:31)
36: Data Analysis: Understanding the INDEX and MATCH function (13:56)
37: Data Analysis: Understanding the IF, COUNTIF and COUNTIFS function (9:09)
38: Data Visualization: Understanding the LINE chart (12:33)
39: Data Visualization: Understanding the PIE chart (11:45)
40: Data Visualization: Understanding the COLUMN chart (13:03)
41: Data Visualization: Understanding the STACKED COLUMN chart (10:56)
42: Data Visualization: Understanding the CONDITIONAL FORMATTING function (6:58)
43: PAUSE & BREATHE: Recap: what did we learn in Module 3 (1:03)
44: Practice Assignment #3 - Difficulty level: MEDIUM
45: Solution to Practice Assignment #3
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
47: What will we learn in this module? (2:52)
48: Download the excel template for this module (0:34)
49: Understanding the LIST function (5:45)
50: Understanding the OFFSET function (8:30)
51: Understanding the SUMPRODUCT function (8:24)
52: Understanding the GOAL SEEK function (8:29)
53: Understanding the INDEX-MATCH function (18:54)
54: Understanding the PIVOT function (11:12)
55: Understanding the INDIRECT function (11:31)
56: Recap: what did we learn in Module 4? (0:51)
57: Practice Assignment #4: DIFFICULTY LEVEL - MEDIUM
58: Solution to Practice Assignment #4
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
60: What will be learn in this module? (1:41)
61: Download the excel template for this module (0:34)
62: Understanding the COMBINATION chart in excel (10:34)
63: Understanding the WATERFALL chart in excel (14:16)
64: Understanding the DYNAMIC LINE chart in excel (13:17)
65: Understanding the AREA chart in excel (4:46)
66: Understanding the INDEX chart in excel (10:01)
67: Understanding the RADAR chart in excel (4:24)
68: Understanding the SCATTER chart in excel (9:42)
69: Understanding the BUBBLE chart in excel (6:24)
70: Understanding the GANTT chart (11:46)
71: Recap: what did we learn in Module 5? (0:55)
72: Practice Assignment #5: DIFFICULTY LEVEL - MEDIUM
73: Solution to Practice Assignment #5
74: Please provide us your valuable feedback on the course thus far
Ready for one more surprise
Extra Videos - Miscellaneous Learnings
75: Creating dynamic bar chart in Excel (8:38)
76: 100 useful Excel shortcuts
77 - Assignment : Dynamic Bar Charts
78 - Assignment : Waterfall Chart
79 - Assignment : Gantt Chart
Your destination is reached: End of journey - what did we learn?
80: Let's relive our journey: A Quick Recap (2:24)
Course Challenge
Solution to Course Challenge
Claim your certificate of completion
40: Data Visualization: Understanding the COLUMN chart
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock