i-nth - My ten principles for Excel good practice

8 May 2013

I have been asked to share my personal principles for Excel good practice - and I thought you might be interested to see them too. My ten Excel principles...

Full article: My ten principles for Excel good practice

Essential reading

Errors in operational spreadsheets

Errors in the data, formulas, or manipulation of spreadsheets could be costly, even devastating.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.