Excel Essentials - Five key rules of spreadsheet design. By Simon Hurst
Introduction
Over the years ExcelZone has accumulated a vast reservoir of information on Excel and its use, not only in the form of news items and articles, but also your own questions and answers.
Continued...
The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.
Registration is FREE and allows you to view all content, ask questions, comment and much more.
Or if you are already registered, login here
Finally!
I agree - from an engineer's point of view, there tends to be no vision as to what the information contained in a spreadsheet may be used for the future. It's extremely frustrating! Lack of standardised data, no explanations, gaps between rows - the list is endless!
These tips are great - good to see them articulated, and I did come across this which is helping me to write a good practice guide for my department:
http://www.ssrb.org/index.html
Katy
At last! Some good advice in a public forum
Good spreadsheet design is rarley discussed.
Whilst I teach it here at the University of the West of Scotland to the Accountancy students the speadsheets I see in daily business use are almost always crude, naive and dangerous.