10 worst Microsoft Excel practices
 
URL: http://michiel.wordpress.com/2009/04/05/10-worst-microsoft-excel-practices/
There are a lot of people who know they ‘know’ Excel, even sometimes stating they are experts of some sort. Well, they were not, and Michiel van der Blonk could usually spot it because they make one of the ‘mistakes’ listed on this page.
[ Affiliated: April 13, 2009 ]
|
Excel-Limits
URL: http://www.xlam.ch/xlimits/
On this site you find 892 specifications of 199 limitations in Microsoft Excel, which were gathered in the last 5 years. It probably concerns the world-wide largest existing collection of limitations, specifications and boundaries in Microsoft Excel. Most specifications refer to the usual Windows Excel versions 97, 2000, 2002/XP and 2003. In addition, you find many information to Microsoft Excel for Macintosh.
[ Affiliated: May 06, 2007 ]
|
|
PDF: IBM - Spreadsheet Modelling Best Practice
PDF dokument
URL: http://www.eusprig.org/smbp.pdf
Nick Read and Jonathan Batson's Best Practice Spreadsheet Modelling Methodology is a guide to developing high quality spreadsheets. This guide is of interest to anyone who relies on decisions from spreadsheet models. The techniques described include areas such as ensuring that the objectives of the model are clear, defining the calculations, good design practice, testing and understanding and presenting the results from spreadsheet models.
[ Affiliated: February 18, 2007 ]
|
|
The New Guidelines for Writing Spreadsheets
URL: http://www.mang.canterbury.ac.nz/people/jfraffen/spreadsheets/index.html
Current prescriptions for spreadsheet style specify modular separation of data, calculation, and output, based on the notion that writing a spreadsheet is like writing a computer program. Users do not want and do not use this style. This article presents a new style, based on writing prose, graphics, and mathematics. The new style emphasizes readability.
[ Affiliated: November 28, 2004 ]
|
|
Using Access or Excel to manage your data
URL: http://office.microsoft.com/en-us/assistance/HA010429181033.aspx
Here you find a good summary when to use Excel or Access to manage your data.
[ Affiliated: May 01, 2005 ]
|
xl-faq.de
URL: http://www.xl-faq.de
German Excel FAQ and many date and times formulas.
[ Affiliated: April 06, 2003 ]
|
|
