Data Table, Charts, Scenario Manager, Goal Seek, and Solver are powerful Excel tools in solving financial problems. Incorporating these tools into finance teaching can help students understand finance concepts intuitively, and bridge the gap between financial theories and real-world applications. The learning goals defined for an Excel-integrated finance course have all been achieved. Students who took this course are more confident on their Excel skills and financial knowledge. This paper demonstrates how to effectively use Excel tools to teach key finance concepts, such as financial statement analysis, time value of money, stock and bond valuation, capital budgeting, portfolio theory, and financial derivatives. To prepare business students with Excel skills needed in the job market, business schools should promote to integrate Excel into other business core and major courses when appropriate.
Zhang, Chengping, "Incorporating Powerful Excel Tools into Financial Teaching" (2014). Faculty Publications - College of Business. 51.