Spreadsheet design

Spreadsheet design

Didn't find your answer?

Does anybody know of any books or courses about spreadsheet design. On more than one occasion I have heard the term "Industry Standard" but wonder if there really is such a thing.
Andrew Whitehead

Replies (3)

Please login or register to join the discussion.

avatar
By tomtrainer
26th Apr 2003 21:36

Good spreadsheet design
I am very interested in learning about good spreadsheet design; not what the formulae do, and how to use pivot tables etc, but how to structure a spreadsheet so it is easy to use, easy to develop, less liable to have links corrupted etc.

Any one know of any relevant courses or books?

Thanks (0)
avatar
By User deleted
01st Aug 2002 17:36

Try the ProductivITy Kit Excel module
Andrew,

The results from our IT Zone Survey show that more than three quarters of accountants use Excel for some sort of purpose. Excel is so popular that has become a "de facto" industry standard for analysing and reporting accounts data.

You can buy an Excel training package designed specifically for accountants by Simon Hurst - right here on AccountingWEB in a matter of minutes. His ProductivITy Kit Excel module covers:
* Advanced charting
* Presentation – number formats, working with text and underlining
* The lunchtime Pivot
* Working with accounting data
* Designing reliable spreadsheets – protection, documentation, templates

It costs £60+VAT, but you also get a regular "ProductivITy Tips" newswire from Simon. You can take a look at a free sample from the charting tutorial at:
https://www.accountingweb.co.uk/cgi-bin/item.cgi?id=82101

Also see AccountingWEB's Excel links page

Thanks (0)
avatar
By AnonymousUser
25th Jul 2002 12:54

Mastering Financial Modelling by Alistair L Day, published by Financial Times may be the sort of thing you are looking for. It has 5 chapters on developing spreadsheet models and then further chapters on financial areas such as cash flow,forecasting, risk analysis etc.
It also comes with a cd with examples and templates on.

Thanks (0)