About Course
Course Objectives:
-
Understand and implement VBA for financial modeling.
-
Design and run VBA sub procedures and customized functions.
-
Write branching, looping, and error-handling code.
-
Extract, transform, and combine data using Power Query.
-
Analyze data and create advanced PivotTables and PivotCharts using Power Pivot and DAX functions.
Course Outline:
Excel VBA for Financial Modeling
-
Introduction to VBA – Navigate VBE, record macros, and learn the benefits of VBA in financial models.
-
Design, Build, and Run Sub Procedures – Work with objects, properties, methods, and variables.
-
Create Customized Excel Functions – Integrate Excel functions into VBA and build custom functions.
-
Branching, Looping, and Procedure Code – Event handling, “On Error” statements, conditional branching, and loops.
Excel Power Query & Power Pivot
-
Power Query: Load, combine, shape, filter, unpivot, merge, and create custom columns from multiple data sources.
-
Power Pivot: Build data models, create relationships, PivotTables, PivotCharts, measures, KPIs, and connect slicers and timelines.
-
DAX Functions: Implement calculated columns, measures, and interactive dashboards.
