VBA for Finance in a Chat GPT World
- 4+ hours of instruction
- 28 Demonstrations
- 8 Participant exercises
- Templates for scenario generation and manipulating large data sets
- 9 months of access
-
$399$249 USD (Introductory Price)USD - $199 USD Student Version (Contact Us)
VBA for Finance in a Chat GPT World
A powerful introduction to VBA, tailored for financial professionals, that combines core coding techniques with using, correcting, and implementing AI generated code for automating scenarios, streamlining models, and working with large data sets. This course is designed for bankers, investors, consultants, auditors, and any investment professional that works extensively in Excel and wants to save significant time through powerful scenario analysis frameworks and the ability to quickly manipulate large data sets. Focus is kept on a minimal number of techniques and leveraging AI resources to ensure quick mastery, usability and integration in day-to-day work.
Course Outline
Problems with AI Generated Code
Overcoming Speed, Scale, and Accuracy Problems with VBA
Scenarios and Large Data Sets
Object Oriented Languages
The Macro Recorder
The Visual Basic Editor
Writing Your First Code
Creating Variables
Using Variables
Operators
The Offset Property
The Concept of Looping
For Next Loops
Counter Variables
Offsetting within a Loop
Prepping the Excel Sheet
Creating Scenario Input / Output Areas
Scenario Generation Core Code
Outputs and Clean Up
AI Prompts
Troubleshooting AI Generated Code
Converting and Adapting AI Generated Code
ReDim and Cells Properties
Aggregation Methods Available
Three Methods of VBA Aggregation
Which Method is Best?
Common VBA Errors
Methods to Address Common Errors
Combining Auditing Techniques
Reorganizing Code