Using Excel's Data Table and Chart Tools Effectively in Finance Courses
Journal of Accounting and Finance, 15 (7), 2015
15 Pages Posted: 18 Aug 2015 Last revised: 27 Mar 2016
Date Written: August 17, 2015
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
Suggested Citation: Suggested Citation