background preloader

SA90 - XL Spreadsheet Design & Standards

Facebook Twitter

BEST PRACTICES USING EXCEL IN CORPORATE ENVIROINMENTS. PART 1. Is there ever a good reason to use a direct cell reference in place of a defined name? Good Spreadsheet practice - what are your thoughts on this? Information technology. Best Practice Modelling Standards. Developing any spreadsheet in accordance with best practice; and Reducing the time and cost associated with spreadsheet development, maintenance and use.

Best Practice Modelling Standards

The standards were originally developed by BPM and first publicly released in July 2003. Since then, they have rapidly gained general market acceptance and have been implemented by companies, investment banks, commercial banks, accounting firms, government bodies, advisors and stockbrokers all over the world. The standards are now governed by the Spreadsheet Standards Review Board ('SSRB'), a body established to facilitate participation in the Standards by the business community, with the charter to assess submissions to modify standards, as well as maintain and develop the standards. The standards can easily be implemented within any organisation using BPM's best practice modelling software, training courses or consulting services. For more information in relation to the SSRB, visit Implementation. Spreadsheet Standards Review Board. European Spreadsheet Risks Interest Group - spreadsheet risk management and solutions conference.

New Guidelines For Spreadsheets. How do you know your spreadsheet is right? An Introduction to Spreadsheets. An Introduction to Spreadsheets These notes are designed to help you understand the principles of using spreadsheet packages.

An Introduction to Spreadsheets

They have been written by Duncan Williamson, who has also written the downloadable spreadsheets available in this section. The notes are split into various sections. You can either work through gradually by scrolling down the page or access the sections directly by following the links below: Introduction There is good news and bad news as far as using spreadsheets in the teaching learning process is concerned: The good news is that students and teachers can enjoy using them and they can use them to build models, draw graphs and make predictions...

Of course, students who have used the spreadsheet package have learned at least a few things about those packages; it's just that, for example, trying to help students to get a better understanding of management accounting via spreadsheeting does not work. Efficient XL Spreadsheet Design. Questions? Excel Help See Also: speed up vba code & Slow Macros & Excel/VBA Golden Rules & Excel Services Best Practices | Consider The Code-VBA Add-in To Ensure your code is efficient Code Intro Excel is without doubt a very powerful spreadsheet application and arguably the best in the world. However, many people often design their spreadsheets with no foresight at all. Excel Best Practice & Design On this page. Twenty Principles for Good Spreadsheet Practice. There have been countless posts on IT Counts and the Excel Community about the risks of poorly designed spreadsheets and the time that can be wasted by inefficient use of spreadsheets.

Twenty Principles for Good Spreadsheet Practice

The IT Faculty is publishing what we hope will be a major contribution towards addressing those problems, and now is your chance to improve our 'public consultation draft', by providing feedback here. Over the past several months a dozen or so ‘spreadsheet gurus’ – the term is meant as a compliment ­– have been debating what ought to be our ‘Twenty Principles of Good Spreadsheet Practice’. The result of that debate can be downloaded and read here. I should add that this is an interim result, since what we are now doing is opening that debate wider, so that we can further improve what we have done in the light of feedback that comes in over the next few weeks. This document is not meant to be a set of ‘spreadsheet standards’: there are already plenty of those in existence. ICAEW - 20 Principles for good spreadsheet practice. Spreadsheet Design Concepts. This web page considers primarily the impact that ACBA's Electronic Working Papers software has on its approach to spreadsheet and systems design, but these do not override the basic concepts of good design.

Spreadsheet Design Concepts

The concepts of good spreadsheet design and construction have been widely discussed and written about. However there is no universal agreement on what the "rules" should be. Below we provide links to web sites and articles. In general, these provide an excellent basis for understanding how to construct user friendly and robust spreadsheets. If you read them all, however, you will find some contradictions of detail between them and indeed within them. One possible rationale for the wide range of approaches for the management of good spreadsheet design lies in the conceptual simplicity of the spreadsheet itself. ACBA Electronic Working Papers (EWP) - what it does A copy of ACBA-EWP can be obtained on request by email . Why does this make a difference? Compare the Index below with. How to Make Your Spreadsheets Less Lame. How to Make Your Spreadsheets Less Lame Spreadsheets are lame.

How to Make Your Spreadsheets Less Lame

There’s no two ways about it. We designers hate spreadsheets because they’re a shining example of boring data presented in a boring manner. Unfortunately for designers, spreadsheets are a necessary evil and could even be called a great and essential tool in the business world. Today we’re going to see how to improve both the aesthetics and readability of your spreadsheets with a few super basic design principles that literally anyone can follow. The Starting Document To begin we’ll need an actual spreadsheet.