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.

Credits

1

Prerequisite

Graduate Student or At Least Junior

Distribution

School of Business

Typically Offered Periods

Fall Semester Spring Semester