Advanced Excel
Master Excel from Basics to Dashboards
Transform your Excel skills from basic spreadsheets to advanced dashboards, Pivot Tables, Power Query, and professional financial models used in real corporate environments.
Special Launch Price
₹25,000
₹999
Course Overview
Advanced Excel remains one of the highest-ROI skills a finance or business professional can possess. This course moves far beyond basic spreadsheet work — covering powerful functions like XLOOKUP and INDEX-MATCH, dynamic Pivot Tables with slicers and timelines, professional dashboard design, and Power Query automation. You'll finish with the confidence to handle any corporate Excel reporting challenge.
Who Should Enroll
- Finance and accounting professionals
- Business analysts and MIS executives
- Students preparing for corporate placements
- Anyone who uses Excel regularly and wants to unlock its full potential
Complete Syllabus
6 modules · 45 Hours | 45 Days
- Excel interface, ribbons, and keyboard shortcuts
- Named ranges and absolute vs relative references
- Data entry best practices and Flash Fill
- Data validation and drop-down lists
- Protecting sheets and workbooks
- XLOOKUP and VLOOKUP / HLOOKUP
- INDEX-MATCH and INDEX-MATCH-MATCH
- SUMIFS, COUNTIFS, and AVERAGEIFS
- IFERROR, IF nesting, and logical chains
- TEXT functions: LEFT, MID, RIGHT, TEXTJOIN
- Date and time functions for reporting
- Creating and refreshing Pivot Tables
- Grouping dates: by month, quarter, year
- Calculated fields and calculated items
- Slicers and timelines for dynamic filtering
- Pivot Charts and chart formatting
- Multiple Pivot Tables from one data source
- Dashboard planning and layout principles
- Dynamic charts linked to Pivot Tables
- Conditional formatting: color scales, data bars, icon sets
- Camera tool and linked pictures
- Interactive elements: scroll bars and option buttons
- Executive-ready dashboard formatting and styling
- Introduction to Power Query in Excel
- Importing data from multiple files and folders
- Transforming and reshaping data
- Appending and merging tables
- Refreshing queries automatically
- Replacing manual monthly reporting processes
- Goal Seek for reverse calculations
- Scenario Manager for sensitivity analysis
- Data Tables: one-variable and two-variable
- Building a 3-statement financial model structure
- Loan amortization and EMI schedule
- Capstone: corporate reporting dashboard project
Skills You Will Learn
Learning Outcomes
Students will develop skills in advanced spreadsheet calculations, data preparation, Pivot Tables, reporting, Excel dashboards, and Power Query-based workflows.
Start Your Advanced Excel Journey
Fill in your details and our counsellor will get in touch within 24 hours to confirm your enrollment.
Book Your Counselling Session
Speak with senior CA, ACCA & CMA mentors at Godrej Eternia, Chandigarh or via phone.
Frequently Asked Questions
Basic Excel familiarity (entering data, simple formulas, saving files) is sufficient. The course starts with efficiency fundamentals and progressively moves to advanced techniques.
Both are covered. XLOOKUP is taught as the modern replacement for VLOOKUP, while VLOOKUP is also explained for compatibility with older Excel versions still used in many corporate environments.
Yes. Module 5 is fully dedicated to Power Query — covering data import, transformation, appending, merging, and automating monthly reporting workflows that would otherwise require hours of manual work.
Yes. Module 4 is entirely focused on professional dashboard design, and the course ends with a capstone project where you build a corporate-grade reporting dashboard from scratch using a real dataset.


