Welcome to the Session: Data Analysis
In the previous session, you learnt the necessary steps for cleaning the data and preparing the final clean dataset. The next step is to analyse this data and extract meaningful insights.
In industries, datasets are often large and distributed across multiple sheets. Manually inspecting the data or analysing its distribution using descriptive statistics and conditional formatting is not practical. To summarise and analyse such data efficiently, you need to combine data from multiple sheets.
Advanced Excel functions and formulas make this possible. You can achieve this using LOOKUP formulas and Pivot Tables, which you explored in your preparatory Excel module.
The upcoming video will elaborate on the topics you will learn in this session.
Welcome to the Session: Advanced Data Analysis in Excel
In this session, you will go one step further and learn about the WHAT-IF Analysis tool in Excel, which is used to solve complex problem statements. Once insights are generated, it becomes equally crucial to present them effectively to your audience. In this session, you will also learn how to create a dashboard to present your insights visually.
The session will cover the following topics:
- LOOKUP Functions
- INDEX and MATCH
- Pivot Tables
- What-If Analysis I
- What-If Analysis II
- Dashboards
Let’s begin!