Description
This course is all about learning two necessary processes, data visualisation and data analysis, both in Hindi. This course talks about understanding what data analysis is through Excel with the help of Slicers and Pivot Tables. It starts by explaining the importance of Data Analysis with Pivot Table and then talks about the same process using Slicer. You will come across topics like creating slicers, using slicers and designing slicers as a dashboard. This course aims to teach improved ways of using Excel, especially for the process of data analysis.
Topics Covered:
- Data Analysis: Understand the concept of data analysis with the use of Excel and see how you can visualise and analyse the raw data.
- Creating Pivot Table: Learn in detail how to create a Pivot Table and later start organising and summarising your data in the table.
- Designing Pivot Table: While designing your table, you come across multiple options which help you customise the table as per your data.
- Creating Slicer: Understand what Slicers are and come across different ways to insert a Slicer and later configure it.
- Using Slicer: Learn how using Slicer can make your data look neat and simply help to improve the data navigation process in Excel/
- Slicer As A Dashboard: See how the Slicers and Pivot Tables make a great combination and learn to build multiple dashboards.
- Excel: Come across a few Excel skills which help you in your daily routine and improve your accuracy.
- And Many More Topics..
Who Will Benefit?
- Students: Students who want to learn the process of data visualisation and data analysis through Excel, especially in Hindi for a better understanding.
- Office Executives: Individuals working for office administration who want to improve their Excel skills for raw data analysis and data reports.
- Business Owners: All those who want to manage their entire business data with the tools of Slicer and Pivot Table in Excel.
Why Choose This Course?
As you choose this course, you come across the entire process of data visualisation and data analysis in the Hindi language. It benefits you by introducing you to the concept of Slicers and Pivot Tables in Excel. You will gain skills related to data analysis using both Slicers and Pivot Tables and learn everything, starting from creating slicers to using them as a dashboard. By the end of this course, you will gain hands-on skills related to the designing aspect of Pivot Tables and come across several improved ways of using Excel in day-to-day life.