Using Excel's Data Table and Chart Tools Effectively in Finance Courses

Abstract

Data Table and Chart tools in Microsoft Excel provide data visualization. Incorporating Data Table and Chart into finance teaching not only helps students understand finance concepts intuitively and more efficiently, but also sharpens students’ Excel skills and thus makes them more marketable in a competitive job market. This paper demonstrates how to use Data Table and Chart effectively in various finance courses to help professors teach and students learn some key finance concepts and theories. Professors in other business disciplines are encouraged to integrate Data Table and Chart tools into other business courses.

Keywords: Excel, Data Table, Chart, Financial Models, Finance Teaching

JEL Classification: A22, A23, G00