Login

Data Analysis using advance Excel

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.

4.3★★★✰✰

Duration

1 Week

Skill Level

Beginner

Starts From:

09/02/2026

Category

Skill Developement

After completing this Winter School program, participants will be able to:

  1. By the end of the program, students will be able to:
  2. Apply advanced formulas like LOOKUP functions, IF conditions, text & date functions.
  3. Use PivotTables and Pivot Charts for dynamic data summarization.
  4. Clean, merge, and transform data using Power Query.
  5. Create interactive dashboards using slicers, charts, and formatting tools.
  6. Automate repetitive tasks using macros and basic VBA.
  7. Handle large datasets efficiently for decision-making purposes

 

What you'll learn


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

 
  1. To develop proficiency in advanced Excel functions and formulas.
  2. To build skills in data cleaning, transformation, and analysis.
  3. To introduce automation using Excel tools such as PivotTables, Power Query, and macros.
  4. To train students to create professional dashboards and reports.
  5. To enable students to solve real-world business and academic data problems effectively.

Name: Abhishek Singh Rajput

Mobile No: 6260572031

Email: [email protected]

Course Image

This Premium course is included in plans

₹ 500/-

Enroll Now

Copyright ©2026 SageX