Alan's Excel Goodies
VBA code examples, formula and custom function examples by Alan.
[ Affiliated: January 29, 2006 | Your Feedback for this Link ]
EDC Worksheet Functions
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 ]
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 ]
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 ]
excel-training.de Formel- & Makro-Datenbank
Almost endless samples for fomulas and macros, clearly arranged by sections.
[ Affiliated: July 02, 2006 | Your Feedback for this Link ]
Prüfziffer für EAN-Codes
This User-Defined-Function calculates the check digit for EAN codes.
[ Affiliated: September 24, 2016 | Your Feedback for this Link ]
User defined astronomical functions in Excel
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 ]