Bootcamp Training - Data Analysis in Excel

Age Group | : | All | |
Course Duration | : | 1 Year | |
Course Medium | : | Hybrid | |
Subject | : | Excel | |
No of Classes | : | 100 |
Go from beginner to an Expert in Data Analytics skills in Excel?
Join this program to create Data Automation reports quickly through hands-on projects.
Go from beginner to an Expert in Data Analytics skills in Excel?
Join this program to create Data Automation reports quickly through hands-on projects.
Bootcam Training
Go from beginner to an Expert in Data Analytics skills in Excel?
Join this program to create Data Automation reports quickly through hands-on projects.
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
For Class / Standard | All |
---|---|
For Subject | Excel |
Topics /Chapters Included/Course Content | 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 |
What you will learn | Data analytics functionalities in Excel Create Data Automation reports on your own Data visualization through charts and graphs Logical analysis driven decision-making Data cleaning and improvisation methods Pivot Table analysis Professionally format datasheets Excel tips and tricks using shortcuts Excel skills for business purposes Apply data analysis on real life datasets |
Is there any special requirements (Hardware/Software) to be fullfillerd by the purchaser to use this product? | Yes |
If yes, provide the details of the special requirements? | Microsoft Excel v2010 and above |
Instructor Information | Ashish is a Business and Finance Expert with around 10 years of experience in this domain. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements. Ashish is also the founder of an education firm SKILLFIN LEARNING which curates content in Business, Finance and Data Analysis topics. He conducts corporate trainings in a leading global consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all. |
Return Policy | Yes |
Terms of return policy | 14 days from Purchase |
Delivery Time required | 24 hrs |