FE 514 Financial Lab: VBA in Finance

This course is an introduction to programming with VBA - the Visual Basic for Applications language. In particular, we will be using VBA within MS Excel, and time permitting, MS Access as well. Excel is used everywhere in finance, and VBA allows practitioners to go beyond standard spreadsheet calculation and modeling. Programming with VBA (and using macros) enhances the versatility and power of Excel. The goal of this course is to teach our students Excel usage at a high level using VBA, for front office applications in financial institutions. Financial and mathematical applications will be presented and studied throughout the course.

Credits

1

Prerequisite

Graduate Student or At Least Junior

Distribution

School of Business

Offered

Fall Semester Spring Semester