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

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

Suggested Citation

Zhang, Chengping, Using Excel's Data Table and Chart Tools Effectively in Finance Courses (August 17, 2015). Journal of Accounting and Finance, 15 (7), 2015, Available at SSRN: https://ssrn.com/abstract=2645580

Chengping Zhang (Contact Author)

George Fox University ( email )

414 N. Meridian Street
Newberg, OR 97132
United States

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
238
Abstract Views
798
rank
177,878
PlumX Metrics