 Back to jkp-ads.com |
Ron de Bruin
|
 |
|
Back to jkp-ads.com |
Ron de Bruin
|
|
Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.
Luckily, Ron was kind enough to allow me to publish all of his Excel content here.
Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.
Kind regards
Jan Karel Pieterse
Excel Function Bible Help is created by Norman Harker(Australia) in association with Ron de Bruin(Netherlands). You can use the link below to download all the 468 example files and a Function Index workbook so it is easy to search and open the example workbooks. When you open the Excel Function Bible Menu workbook you will find a worksheet for each function classification group but I also add the classifications on my site with a brief description, check out the links below the download.
File date 15-June-2014 : History of downloads
Note: New version with different background colors and more
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. To make it easier to navigate through all the Excel
functions example workbooks(using a nice Ribbon interface) It will also be available as a
add-in soon.
A fully inclusive set of indexes allows users to
find particular functions and gives the brief descriptions. Using these
indexes on the classifications web pages users can bring up individual files for
each function.
The first worksheet of each function file provides
descriptions of the functions, the syntax, and descriptions of the arguments
required. The front page includes a brief history of the function that
allows users to determine which versions of Excel introduced the function
and whether and when capabilities of the functions were changed. Each front
page provides details of any equations used by the function in traditional
and linear format. An addition section provides the cause of error messages
that may be returned by the function. There is also a link on this worksheet
to the Excel online help for the function.
Second and subsequent
worksheets provide copy and paste facilitated examples of the use of the
function ranging from simple implementation to more complex examples of use
including use by interaction with other functions.
This is an evolving project. We would appreciate users providing us with
additional examples of typical or extremely useful applications of the
functions especially in conjunction with other functions. All examples
provided will be appropriately and prominently acknowledged.
Similarly, we don’t pretend to be perfect and would appreciate reports of
any bugs or errors that may have crept in. Please contact Norman Harker or
me to report bugs or providing us with additional examples.
Norman Harker : Contact Norman
Ron de Bruin : Contact Ron
Support : If you find the Excel Function Bible useful and want to support the development of the Excel Function Bible we appreciate a donation so we can keep the site adds free.