FE 514 Advanced Excel for Finance and Accounting
The goal of this course is to teach our students Excel usage at a high level, including the built-in data tools and formulas, as well as an introduction to programming with VBA – the Visual Basic for Applications language – within Excel. Excel is used everywhere in finance, and VBA allows practitioners to go beyond standard spreadsheet calculation and modeling. The course focuses on advanced topics such as interacting with databases as well as addons and creating macros to perform complex tasks.
Prerequisite
Graduate Student or At Least Junior
Distribution
School of Business