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

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

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

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

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

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

End Of Course - What Did We Learn?

Lecture 79: Quick Recap (2:24)

Course Challenge

Solution To Course Challenge

Claim Your Certificate Of Completion