URL: http://xl.barasch.com
VBA code examples, formula and custom function examples by Alan.
[ Affiliated: January 29, 2006 | Your Feedback for this Link ]
URL: http://www.decisionmodels.com
All you need to know about the calculation mechanisms of Microsoft Excel and how to use them to optimise speed.
[ Affiliated: January 13, 2008 | Your Feedback for this Link ]
URL: http://www.erlandsendata.no/english/index.php
In the menu on the left you find subpages containing Worksheet Functions, e.g. for adding, counting or lookup.
[ Affiliated: February 04, 2007 | Your Feedback for this Link ]
URL: https://analystcave.com/excel-optimize-excel-formulas-excel-optimizer/#Download
The Excel Optimizer is a simple AddIn to Excel that runs certain rules across your Workbook and points out the main pain-points or suggests certain improvements – all with performance in mind. Some rules can be implemented while others will simply point out what needs to get done.
[ Affiliated: October 17, 2023 | Your Feedback for this Link ]
URL: https://www.excelfunctions.net
ExcelFunctions.net has been created to provide help with Excel functions and formulas. It provides information and examples of each of the Built-In Functions and also shows you how to combine these functions with each other, and with the Mathematical Operators (+, -, *, /, etc.), to create Excel Formulas. There is also a section explaining Excel Array Formulas, which is essential reading for some of the more complex (but most useful) Excel functions and formulas. And for those who want to learn how to program their own functions in Excel, it has an Introductory Guide to Excel Macros and an Excel VBA Tutorial.
[ Affiliated: August 08, 2022 | Your Feedback for this Link ]
URL: http://www.excel-training.de/makro_Liste_frs.asp?kat=VBA-Funktion&art=M
Almost endless samples for fomulas and macros, clearly arranged by sections.
[ Affiliated: July 02, 2006 | Your Feedback for this Link ]
URL: http://dabama.de/EANCode.htm
This User-Defined-Function calculates the check digit for EAN codes.
[ Affiliated: September 24, 2016 | Your Feedback for this Link ]
URL: http://www.stargazing.net/kepler/astrofnc.html
This page provides details of a range of user functions for astronomy for Microsoft Excel version 5 or later. These functions may also be of interest to land surveyors and construction technicians, as well as teachers of astronomy and amateur astronomers.
[ Affiliated: May 13, 2006 | Your Feedback for this Link ]
Legal Information | © 2001– Raphael Hein – The Microsoft Excel VBA Specialist from the Da|ten|bank|Ma|nu|fak|tur
Do you also work with Microsoft Access? Come and visit: Yaccess - The Access Portal
Die deutschsprachige Version findest Du unter Yexcel - Das Excel-Portal