AI CAMPUS
Business Analytics Track

Advanced Excel, Power Query & Financial Modeling Course

Master XLOOKUP, dynamic arrays, Power Query M code, VBA automation, and 3-statement financial modeling. Graduate with official certifications and a contractually guaranteed 6-month paid corporate internship (₹15,000–₹40,000/mo stipend).

Enroll for ₹80,000 (0% EMI) → Explore Data Analytics Track →

Request Course Brochure & Syllabus

Download the detailed 2026 week-by-week curriculum and speak with an academic advisor.

Comprehensive 6-Month Technical Curriculum

Module 1: Advanced Excel 365 & Dynamic Arrays

XLOOKUP, FILTER, UNIQUE, SORT, XMATCH, nested IF/SWITCH, LET and LAMBDA formulas for modular spreadsheet modeling.

Module 2: Power Query ETL & M Language

Automating data extraction from CSV/SQL/Web sources, unpivoting columns, conditional transforms, and scheduled refreshes.

Module 3: Power Pivot Data Modeling & DAX

Building relational star schemas in Excel, writing calculated measures with CALCULATE, DIVIDE, and Time Intelligence.

Module 4: VBA Macros & Process Automation

Writing custom VBA procedures, UserForms, automating workbook reports, error trapping, and batch emailing via Outlook.

Module 5: 3-Statement Financial Modeling & Valuation

Integrating Income Statement, Balance Sheet, and Cash Flow statement, DCF valuation, sensitivity analysis, and KPI dashboards.

Module 6: Guaranteed 6-Month Paid Corporate Internship

Contractually guaranteed 6-month corporate internship (₹15,000–₹40,000/mo stipend) working in corporate finance or analytics teams.