Data Analysis Full Course Part-2 | Data Analysis Using Microsoft Excel | 2021

Data analysis is growing rapidly, with companies seeking to generate information and boost their business with data, which is why data analysis and data analyst have become increasingly important in recent times.

In this video (Data Analysis Full Course part-2), you will learn below topics in detail with easy-to-understand approach with real life examples:

Data Analysis Full Course Part-2 || Data Analysis Using Microsoft Excel || 2021 Key Points:

Table of contents:

0. Welcome Note 00:00
1. What we have learned in Data Analysis part-1 00:04
2. What we will learn in this video 00:42
3. Data Analysis Process 01:05
4. Common use-cases of excel 01:31
5. Data collection & clubbing in excel 01:52
6. Filtering and sorting and techniques 03:36
7. Important formulas for day-to-day Excel working and analysis 04:37
8. Pivot table with example 05:51
9. How to visualize the data using charts 07:08
10. Multi-level pivot table for detailed analysis 13:55
11. Conditional formatting 15:13
12. Profitability Analysis to take business decision 15:49
13. Excel Dashboard preparation 17:08
14. Excel Slicer preparation 18:51
15. Summarisation of what we learned in this video 20:13
16. Thank you note 20:47

In this video you will get answer of below points:

What data analysis can you do in excel?
How can we do data analysis with Excel?
How data analysis is done?
How can we use data analysis to improve the sales?
How can we do data analysis by using visualization?
How can I use data analysis to identify the trends?
Data analysis techniques can be used in excel?
How data analysis supports decision making?
How can data analysis benefit a company?
Why data analysis is important?
How you can increase the sales by doing data analysis?
What are the important formula of Excel for Data Analysis?
How to add slicer in excel?
How to prepare dynamic and interactive Excel Dashboard?
How to prepare pivot table in excel?
How to prepare chart and graphs in excel?

Subscribe to my channel and take advantage of the upcoming video in this set of data analytics.
Fundamental video for Data Analysis :

Data Analysis Part1 : https://youtu.be/mlqf4Weq1yA

Data Analysis Part3 (Microsoft Power BI Tutorial | 2021) : https://youtu.be/i_cFJv9owiY

Please check out my other career development videos like resume writing video and most asked interview questions and answers video:

How to write an Impressive Resume (English + Hindi)
https://youtu.be/YSM3vFKrrA8

Top 10 Most Asked Interview Questions and Answers | Job Interview Tips | 2021
https://youtu.be/0YPcjxqEHG8
-----------------------------------------
#DataAnalytics
#DataAnalysisInExcel
#DataAnalysis
----------------------------------------------------------------------
#AnalysisOfData
#DataAnalysisProcess
#DataAnalysisFullCourse
#DataAnalysisForBeginners
#LearnDataAnalysis
#DataVisualization
#WhatIsDataAnalysis