Yexcel Logo Feedback
Suggest a new link
Search Yexcel

Yexcel  >  Basics
This sites should every Excel user know.

10 worst Microsoft Excel practices    open in new window          
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    open in new window    
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    open in new window            
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    open in new window        
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    open in new window            
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    open in new window          
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    open in new window            
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    open in new window            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 ]

Monika Weber's OFFICE-HELP-DESK    open in new window                
URL: http://www.jumper.ch
Many samples, articles and downloads by MVP Monika Weber.
[ Affiliated: February 12, 2006  |  Feedback for this link ]

Pivot-Tabellen - Einführung und Erklärung    open in new window        
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 ]

PSC Excel Web Source    open in new window                
URL: http://www.cpearson.com/excel.htm
The PSC Excel Web Source is one of the most comprehensive Excel and Excel/VBA sites on the Internet. More than just a list of links or downloadable files, it has over 150 of pages devoted to specific Excel topics, hundreds of example formulas, and much more.
[ Affiliated: June 18, 2006  |  Feedback for this link ]

Rund um Excel und mehr    open in new window            
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    open in new window          
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 ]

Using Access or Excel to manage your data    open in new window          
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  |  Feedback for this link ]

xl-faq.de    open in new window          
URL: http://www.xl-faq.de
German Excel FAQ and many date and times formulas.
[ Affiliated: April 06, 2003  |  Feedback for this link ]

Diese Kategorie im deutschsprachigen Yexcel - Das Excel-Portal:  Basics

All Links Search Yexcel Site Map
© 2005 - 2023 Raphael Hein  -   Legal Information  -   Yexcel is a project of the German Da|ten|bank|Ma|nu|fak|tur

You are also working with Microsoft Access? Come and visit our sister site:  Yaccess - The Access Portal