UM  > Faculty of Business Administration
Residential Collegefalse
Status已發表Published
Spreadsheet Proficiency: Which Spreadsheet Skills Are Important?
Lee, Chang Boon; Tang, Heng; Sam, Kin Meng; Xiong, Gang
2018
Source PublicationJournal of Information Technology Management
ABS Journal Level1
ISSN1042-1319
VolumeXXIXIssue:3Pages:35-44
Abstract

Many academic studies and industry reports have stressed the need for workers to be proficient in spreadsheets. As spreadsheets have hundreds of functions and features, it is useful to know which particular spreadsheet skills are important. Unfortunately, there are few studies that determine the relative importance of specific spreadsheet skills. This research examines, in general as well as in specifics, the importance of spreadsheet skills for accountants. It also determines the knowledge new accountants have regarding detailed spreadsheet skills. The results of this study found that: (1) Recruitment advertisements mentioned the need for Excel proficiency almost 50 percent of the time; (2) The top three spreadsheet skills perceived as important among practicing accountants are ‘Lookup and Pivot Table’, ‘Data entry, format and calculations’, and ‘Logic’; and (3) The top three spreadsheet skills that newly hired accountants are knowledgeable are ‘Data entry, format and calculations’, ‘Charting’, and ‘Logic’. The results obtained in this study suggest that aspiring accountants should include ‘Lookup and Pivot Table’ as part of their portfolio of spreadsheet skills. These results also provide useful knowledge for accountants, employers, and educators in aiding their communications regarding spreadsheets proficiency.

KeywordSpreadsheets Lookup Proficiency Excel Pivot Table
Language英語English
Document TypeJournal article
CollectionFaculty of Business Administration
DEPARTMENT OF ACCOUNTING AND INFORMATION MANAGEMENT
Corresponding AuthorLee, Chang Boon
AffiliationUniversity of Macau
First Author AffilicationUniversity of Macau
Corresponding Author AffilicationUniversity of Macau
Recommended Citation
GB/T 7714
Lee, Chang Boon,Tang, Heng,Sam, Kin Meng,等. Spreadsheet Proficiency: Which Spreadsheet Skills Are Important?[J]. Journal of Information Technology Management, 2018, XXIX(3), 35-44.
APA Lee, Chang Boon., Tang, Heng., Sam, Kin Meng., & Xiong, Gang (2018). Spreadsheet Proficiency: Which Spreadsheet Skills Are Important?. Journal of Information Technology Management, XXIX(3), 35-44.
MLA Lee, Chang Boon,et al."Spreadsheet Proficiency: Which Spreadsheet Skills Are Important?".Journal of Information Technology Management XXIX.3(2018):35-44.
Files in This Item:
There are no files associated with this item.
Related Services
Recommend this item
Bookmark
Usage statistics
Export to Endnote
Google Scholar
Similar articles in Google Scholar
[Lee, Chang Boon]'s Articles
[Tang, Heng]'s Articles
[Sam, Kin Meng]'s Articles
Baidu academic
Similar articles in Baidu academic
[Lee, Chang Boon]'s Articles
[Tang, Heng]'s Articles
[Sam, Kin Meng]'s Articles
Bing Scholar
Similar articles in Bing Scholar
[Lee, Chang Boon]'s Articles
[Tang, Heng]'s Articles
[Sam, Kin Meng]'s Articles
Terms of Use
No data!
Social Bookmark/Share
All comments (0)
No comment.
 

Items in the repository are protected by copyright, with all rights reserved, unless otherwise indicated.