Workbook design and controls: A framework

• Published in: Journal of accounting education 2024-12, Vol.69, p.100933, Article 100933
• Main Authors: Zeller, Thomas, Dingrando, Erin, Booker, Danielle
• Format: Article
• Language: English
• Subjects: Accounting practice; Efficient review; Excel errors; Excel workbook design; In-class interactive case; Spreadsheet controls
• ISSN: 0748-5751
• DOI: 10.1016/j.jaccedu.2024.100933

•Undergraduate Excel workbook design and controls in-class teaching case.•Framework is provided to think through a workbook design that enables repeatable use, a quality review by a manager, and structured to minimize errors.•Pre-lecture student reading is provided. 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.