Towards an understanding of excel functional skills needed for a career in public accounting: Perceptions from public accountants and accounting students

Linda Ragland and Usha Ramachandran

Journal of Accounting Education, 2014, vol. 32, issue 2, 113-129

Abstract: Public accounting firms (e.g., Grant Thornton, 2012) are stressing an interest in recruiting accounting students with a proficiency in Excel. The purpose of this study is to investigate which Excel functions are perceived to be important and useful for new hires to understand prior to starting a job in public accounting. We collect survey data from four large public accounting firms as well as undergraduate and graduate accounting students (i.e., potential new hires) to gauge perceptions of Excel importance, knowledge, and usage in public accounting. We find that employees at the firms believe the most important Excel functions are: basic formula, filter and sort data, vertical (horizontal) lookup, formatting of documents, and If/Then statements. In a comparison of new hires at public accounting firms with accounting students, results suggest that accounting students underestimate the importance and usage of some of these Excel functions. In addition, results suggest that new hires’ perceived knowledge on how to use specific Excel functions in their accounting job is statistically different than students’ perceived knowledge on how to use some of the same Excel functions. Our research contributes to educational accounting literature by documenting which Excel functions employers in public accounting want new hires to know prior to starting a job in public accounting. Also, this research informs accounting educators that students’ perceptions are not the same as public accounting employers’ expectations with respect to analytical skills using Excel technology.

Keywords: Accounting education; Critical thinking skills; Analytical skills; Technology-assisted tools; Excel functions; Public accounting (search for similar items in EconPapers)
Date: 2014
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (14)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0748575114000268
Full text for ScienceDirect subscribers only

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eee:joaced:v:32:y:2014:i:2:p:113-129

DOI: 10.1016/j.jaccedu.2014.03.002

Access Statistics for this article

Journal of Accounting Education is currently edited by Natalie Tatiana Churyk

More articles in Journal of Accounting Education from Elsevier
Bibliographic data for series maintained by Catherine Liu ().