 |
Training Index
Functions by category Information Functions
|
|
|
Excel formula and functions that allow
you to automatically generated information relating to a cell, sheet or
book. Extremely useful especially if you are trying to build spreadsheets
that need to identify and correct problems themselves. Below are some video clips of extremely useful
information functions built into
Microsoft Excel.
|
Be aware that these video clips use Windows Media Player. Click on the
hyperlink and, depending on your connection speed, you may need to wait a
few moments.
| Title |
Video
Clip
(Windows Media Player) |
ISERROR
The ISERROR function allows you to test whether a cell has
generated an error message. This is particularly useful for division
by zero (#DIV/0!) errors and is often combined with an
IF statement to provide an
alternate action if an error is generated.Excel Help File Description:
Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!,
#NAME?, or #NULL!).
|
|
 |
|
Quote of the page:
Think globally, act locally, think tribally, act universally.- John
Naisbitt (futurologist)
|
|
|
Spreadsheet Professional
will cut down on the number of errors in any
spreadsheet. |
Do you like what you see. Tell your friends. If you have a training co-ordinator
at your organisation tell them that there is free excel training available
at this site.
Don't like what you see. Tell us at
training@AuditExcel.co.za .
Do you have suggestions of what you would like to see. Tell us at
training@AuditExcel.co.za .
|
