Bootcamp Training - Data Analysis in Excel

Rating:
91% of 100
₹1,999.00
In stock
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.

Write Your Own Review
You're reviewing:Bootcamp Training - Data Analysis in Excel
Your Rating

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

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
More Information
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
WA button WA button