This course is designed to equip students with essential data-handling and analysis skills using Microsoft Excel. The program focuses on advanced formulas, automation, dashboards, and data visualization techniques required in modern workplaces. This course is ideal for students who wish to enhance their analytical capabilities and build strong employability skills.
Duration
1 Week
Skill Level
Beginner
Starts From:
26/03/2026
Category
Skill Developement
Overview
After completing this Winter School program, participants will be able to:
By the end of the program, students will be able to:
Apply advanced formulas like LOOKUP functions, IF conditions, text & date functions.
Use PivotTables and Pivot Charts for dynamic data summarization.
Clean, merge, and transform data using Power Query.
Create interactive dashboards using slicers, charts, and formatting tools.
Automate repetitive tasks using macros and basic VBA.
Handle large datasets efficiently for decision-making purposes
Our Trainers
Mr. Abhishek Singh Rajput
Expert Name: Abhishek Singh Rajput Qualification: B.Tech ( Mechanical) Industry Certified Data Analyst Specialist Experience: 4 years in Data Analysis / MIS / Business Analytics Expertise: Advanced Excel, Power BI Data Analytics, MIS Reporting, Dashboards
Modules
syllabus of the Course (Module Wise )
Module 1: Excel Essentials Refresher
Excel interface, shortcuts, formatting
Data types, data validation, conditional formatting
Module 2: Advanced Formulas & Functions
Logical functions: IF, AND, OR
Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
Text functions, date & time functions
Nested formulas and error handling
Module 3: Data Cleaning & Transformation
Remove duplicates, text-to-columns
Power Query introduction
Data merging, appending, transformation
Module 4: PivotTables & Pivot Charts
Creating PivotTables
Grouping, filtering, sorting data
Pivot Charts
Slicers and dynamic filtering
Module 5: Dashboard Designing
KPI creation
Chart selection
Interactive dashboard development
Formatting & layout techniques
Module 6: Hands-on Project & Assessment
Real-world dataset
Dashboard + automated report
Evaluation & feedback
Outcomes
To develop proficiency in advanced Excel functions and formulas.
To build skills in data cleaning, transformation, and analysis.
To introduce automation using Excel tools such as PivotTables, Power Query, and macros.
To train students to create professional dashboards and reports.
To enable students to solve real-world business and academic data problems effectively.
