|
Training Index
Functions by category Statistics Functions in
Microsoft Excel
|
|
|
Excel formula and
functions that help perform statistical calculations on cells (basic and
advanced) Below are some video clips of extremely useful
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 |
Price
|
Video
Clip
(Windows Media Player) |
Rank
The Rank function allows you to rank a selection of cells in
ascending or descending order automatically. Easier than using complex
IF functions to achieve the same goal. Once you have learnt this, go
to Tips and Tricks, to see how
to automatically move cells around depending on there order.Excel Help File Description:
Returns the rank of a number in a list of numbers. The rank of a
number is its size relative to other values in a list. (If you were to
sort the list, the rank of the number would be its position.)
|
FREE |
|
 |
MAX and MIN
Max and Min allows you to specify the maximum or minimum number that
can appear in a cell.Excel Help File Description: Returns
the largest (or smallest) value in a set of values
|
FREE |
|
|
|
Quote of the page:
Never let the fear of striking out get in your way- Babe Ruth
(baseball player)
|
|
|
More free Excel Training?
Visit the
TRAINING index
page! |
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 .
|
