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).
Download the detailed 2026 week-by-week curriculum and speak with an academic advisor.
XLOOKUP, FILTER, UNIQUE, SORT, XMATCH, nested IF/SWITCH, LET and LAMBDA formulas for modular spreadsheet modeling.
Automating data extraction from CSV/SQL/Web sources, unpivoting columns, conditional transforms, and scheduled refreshes.
Building relational star schemas in Excel, writing calculated measures with CALCULATE, DIVIDE, and Time Intelligence.
Writing custom VBA procedures, UserForms, automating workbook reports, error trapping, and batch emailing via Outlook.
Integrating Income Statement, Balance Sheet, and Cash Flow statement, DCF valuation, sensitivity analysis, and KPI dashboards.
Contractually guaranteed 6-month corporate internship (₹15,000–₹40,000/mo stipend) working in corporate finance or analytics teams.