Welcome to the Advanced Excel Module, In the previous Excel module, you learned basic formatting, shortcuts, and some advanced functions. In this module, you will explore additional Excel functionalities that help solve business problems. You will also learn new tools and functions to enhance data analysis and presentation.
While there are many big data tools and programming languages for handling large datasets, MS Excel remains a crucial tool for business data analysis due to its simplicity and ease of use. Excel is often underestimated in its ability to perform complex analyses efficiently. This module will introduce advanced Excel features to make data analysis faster and more effective.
Note: This module will provide a high-level review of concepts like VLOOKUP and Pivot Tables from the Data Analysis in Excel module. For a deeper understanding, please refer to the earlier module. The focus here will be on applying Excel functionalities to solve real business problems.
Let’s now hear from Vivek Dhumal to get an overview of this module.
In the first two sessions, you will explore a case study through demonstrations. The first session will cover data cleaning and the functions used, while the second session will focus on data analysis and associated functions.
During these sessions, there will be in-segment questions. To answer them correctly, you should follow along with the steps demonstrated in the videos. It is recommended that you perform the tasks simultaneously as you go through the content to reinforce your learning. The dataset required for the exercises can be downloaded in the Problem Statement segment of the next session. A complete Excel file with all steps performed will be provided at the end.
Topics Covered in this Module
- Excel functions
- Filter and Sort
- Text functions
- Statistical functions
- Data Analysis functions
- VLOOKUP, HLOOKUP, INDEX, and MATCH functions
- Pivot Tables
- WHAT IF analysis
- Dashboards
- Advanced Data Analysis functions
- Recording Macros
- Advanced Visualisations
- Data Analysis ToolPak
Note: All demonstrations in this module use Excel 2013.
Experts You Will Hear From
- Subject Matter Expert
- Vivek Dhumal
Disclaimer 1
This module may include images, advertisements, trademarks, or other materials from public sources, social media, or print/digital publications. These are used solely for educational purposes, commentary, and demonstration. All rights and credits belong to the original owners. No copyright infringement is intended.
Disclaimer 2
Throughout this course, examples of brands and institutions may be used to illustrate concepts. These examples do not reflect current company performance, and all opinions are provided for educational purposes only.