About course
This course is built to make you confident and productive in Excel. Starting from efficient data handling to advanced analytical techniques, The course centers on real business workflows and includes step-by-step projects, downloadable templates, and exercise files so you can practice while you learn.
Course format: Self-paced recorded sessions
Language: English & Hindi
Projects included: 3 real-world projects — Sales Reporting, Financial Summary, KPI Dashboard
Duration: ~25 hours of video + project practice
Level: Beginner to Advanced (focus on practical application)
Key Skills You Will Master:
- Advanced formulas: XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and nested logic
- Dynamic arrays and array formulas (FILTER, UNIQUE, SEQUENCE, spill behavior)
- Pivot Tables & Pivot Charts: grouping, calculated fields, slicers, timelines
- Data preparation & transformation using Power Query (merge, append, pivot/unpivot)
- Data cleaning techniques: text parsing, date normalization, error handling
- What‑If Analysis: Goal Seek, Data Tables, Scenario Manager
- Dashboard design: layout, visuals, KPI cards, interactivity and storytelling with data
- Automation basics with VBA/Macros: recording, editing, and writing simple macros
- Best practices: structured data, performance tips, version control
