Excel VBA Programming
⏱ 6 weeks · advanced | 2pm to 4pm
Overview
Automate complex spreadsheets, build custom financial models, and create powerful Excel add-ins using Visual Basic for Applications (VBA).
Core modules
- VBA editor, debugging, error handling & best practices
- Procedures: Subs, Functions, and event-driven programming
- Working with ranges, arrays, and advanced cell operations
- UserForms and custom Ribbon interfaces for interactive tools
- Automating charts, PivotTables, and data cleaning workflows
- File system object: batch processing multiple workbooks
- Connecting Excel to APIs, databases (SQL / ADODB)
- Creating professional add-ins and protected code libraries
Real‑world use cases
- Financial reporting automation (profit & loss, dashboards)
- Data transformation for audit & compliance teams
- Monte Carlo simulations in finance & engineering
Starting Date: 11th July 2026
Course Fee: £1990