Workbook design and controls: A framework

Thomas Zeller, Erin Dingrando and Danielle Booker

Journal of Accounting Education, 2024, vol. 69, issue C

Abstract: This is an in-class Excel workbook design and controls teaching case. The case is built from a real-world workbook application. Knowing workbook design and spreadsheet control tools and techniques to support a business decision is a long-standing professional accounting competency. The workbook should tell the business story. Proper workbook design and spreadsheet controls assure the workbook provides insight built on solid ground and stands-up to a critical review. Accounting graduates and young professionals are typically adept at using powerful Excel tools, such as pivot tables, lookup functions, data sort and more, turning data to information. Yet there is much more to telling a business story in a workbook. We provide a framework for the accounting professional to think through a workbook design that enables repeatable use, a quality review by a manager, structured to minimize errors, and used interactively to make a business decision. This case can be used in undergraduate accounting analytics, accounting information systems, forensic accounting, financial, or managerial accounting classes. An Excel workbook file accompanies this case.

Keywords: Excel workbook design; Spreadsheet controls; Accounting practice; Excel errors; Efficient review; In-class interactive case (search for similar items in EconPapers)
Date: 2024
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0748575124000496
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:69:y:2024:i:c:s0748575124000496

DOI: 10.1016/j.jaccedu.2024.100933

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 ().