Module 1: Excel Basics & Data Handling (2 Hours)
Learners will get familiar with the Excel interface, worksheets, and basic navigation. They will learn how to sort and filter data efficiently and use fundamental formulas like SUM, AVERAGE, MIN, and MAX to perform quick calculations.
Module 2: Logical & Lookup Functions (2 Hours)
This module introduces essential logical functions like IF, AND, OR, and Nested IF for decision-making in Excel. Additionally, learners will master VLOOKUP, HLOOKUP, and INDEX-MATCH to fetch and organize data across large datasets.
Module 3: Pivot Tables & Data Visualization (2 Hours)
Participants will create and format Pivot Tables, apply Slicers, and use Pivot Charts to summarize and visualize data effectively.
Module 4: Data Cleaning & Error Handling (2 Hours)
This session covers removing duplicates, advanced sorting & filtering, and handling errors using IFERROR to improve data accuracy.
Module 5: Dashboard Creation (2 Hours)
In the final module, learners will design interactive dashboards, apply formatting best practices, and present data in a visually appealing manner.
View this Course
Certified
You have 
