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 | Feedback for this link ]
|
Excel Formula Translator
URL: http://en.excel-translator.de/
The Excel Translator translates Excel formulas from and into more then 30 languages. Just in case you find a nice formula in a catalan Excel file ;-)
[ Affiliated: May 06, 2014 | Feedback for this link ]
|
Excel Function Bible for Excel 2007-2016
URL: http://www.rondebruin.nl/efb/efb.htm
The Excel Function Bible is aimed at providing meaningful and practical help in finding and implementing the 468 Excel functions. It replaces and adds significantly to the help users can call for whilst building or using Excel workbooks.
[ Affiliated: January 20, 2016 | Feedback for this link ]
|
Excel Tutorial by Excel Easy
URL: http://www.excel-easy.com/
Excel Easy offers a fully illustrated tutorial on how to use Excel. It includes screen shots and explanations of practically every part of the Excel program.
[ Affiliated: July 04, 2014 | Feedback for this link ]
|
Excel, Formeln, VBA Programmierung, UDF, Tipps & Tricks
URL: http://www.j-hennekes.de
A collection of tips, hints and code samples, tutorials on pivot tables and advanced filters, a formula collection and articles on limitations, user defined functions and shortcuts.
[ Affiliated: November 14, 2010 | Feedback for this link ]
|
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 | Feedback for this link ]
|
Herbers Excel Server
URL: http://www.herber.de/
THE German Excel guru! Many tips, downloads and the German Excel FAQ.
[ Affiliated: October 03, 2001 | Feedback for this link ]
|
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 | Feedback for this link ]
|
Pivot-Tabellen - Einführung und Erklärung
URL: http://www.pivot-tabelle.de/
Users, who worked rarely with pivot tables, learn how to use this powerful tool for data analysis meaningful In this German illustrated guide.
[ Affiliated: September 01, 2014 | Feedback for this link ]
|
Rund um Excel und mehr
URL: http://www.vba-beispiele.de/
Jörg Lorenz's site contains many tips, samples, manuals and Frequently Asked Questions.
[ Affiliated: February 18, 2007 | Feedback for this link ]
|
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 | Feedback for this link ]
|
xl-faq.de
URL: http://www.xl-faq.de
German Excel FAQ and many date and times formulas.
[ Affiliated: April 06, 2003 | Feedback for this link ]
|
|