1 / 5

Enhancing Spreadsheet Efficacy in Business: Challenges and Solutions

Spreadsheets are instrumental in today's business landscape, serving for data storage, decision-making, and interfacing with various systems like ERP and databases. However, issues such as bugs, undocumented errors, and chaotic processes hinder their effectiveness. This presentation by Professor Steve Powell from Dartmouth's Tuck School of Business discusses common spreadsheet problems and proposes solutions, including improved training, established standards, and auditing tools. By raising awareness and utilizing specialized software, organizations can enhance their spreadsheet capabilities and make better-informed decisions.

yepa
Télécharger la présentation

Enhancing Spreadsheet Efficacy in Business: Challenges and Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Use of Spreadsheets Steve Powell Professor of Business Administration Tuck School Dartmouth College sgp@dartmouth.edu Foundations of Spreadsheets Conference Rome, Italy September 30, 2004

  2. Spreadsheet Usage • ubiquitous • used for data storage and tracking, routine decision support, one-off decision making, EIS… • interface routinely with database and ERP systems (e.g., Oracle, SAP)… • used in concert with other PC software: Word, Access, ….

  3. Spreadsheet Problems • bugs are everywhere • errors in use are suspected but rarely documented • lost opportunities due to lack of knowledge of Excel tools (e.g., Pivot Table, Goal Seek, Data Validation, …) • design processes are chaotic and inefficient • testing is non-existent • standards and training are minimal or non-existent • generating insights is not well-understood

  4. Spreadsheet Solutions • organizational • improve training • establish standards and incentives • raise awareness • technical • alternative software • auditing tools (see Spreadsheet Auditing Software, Nixon and O’Hara, http://www.gre.ac.uk/%7Ecd02/EUSPRIG/2001/Nixon_2001.htm) • formulation tools • analysis tools

  5. Technical Solutions • alternative software • Quickbase http://www.quickbase.com/ • auditing tools • Spreadsheet Detective http://www.uq.net.au/detective/ • OAK http://www.operis.com/oak.htm/ • Spreadsheet Professional http://www.spreadsheetinnovations.com/ • SPACE http://www.hmce.gov.uk/business/services/space.htm/ • Xlsior http://www.xlsior.com/ • Formulation tools • ID Builder http://www.macwayuhl.com/IDBuilder.PDF • Analysis tools • Sensitivity Toolkit http://mba.tuck.dartmouth.edu/toolkit/

More Related