In this session, you will be introduced to the problem statement along with its dataset. We will work with various text and statistical functions in Excel to uncover meaningful insights from the data.
Topics Covered :-
- Data cleaning steps
- Using a data dictionary
- Applying advanced filters
- Text functions in Excel
- Statistical functions for detecting outliers
- Conditional formatting
By the end of this session, you will be able to identify and correct errors in datasets imported into Excel and execute aggregation commands like SUM, COUNT, SUBTOTAL, as well as conditional variants such as SUMIFS, COUNTIFS, and AVERAGEIFS to summarise data efficiently.
Let’s get started!