 |
Training Index
Absolute musts to use Microsoft Excel
|
|
Below are some video clips of extremely useful features built into
Microsoft Excel. Whether you are an absolute beginner or consider
yourself an expert, make sure you know of these features and how to
use them.
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) |
The Function Wizard
The function wizard allows you to use any of Excels functions in a
very user friendly way. You therefore do not need to remember the
complex syntax of any of the commands. |
FREE
|
|
 |
The Auditing Toolbar
The Auditing Toolbar is one if Excel's best kept secrets. It allows
you to visualise the cells used in any formulae. In particular is
allows you to view what cells are being used by a particular formulae,
what other cells are relying on the cell you have specified, follow
links to other spreadsheets and more recent versions of Excel include
some error checking capabilities. |
FREE
|
|
|
Good Spreadsheet Design Techniques
The are some basic aspects of spreadsheets which should be
considered. When developing your spreadsheets some upfront thought can
be vital. After you have viewed the free material on How Errors
Happen, this will further enforce some good design tips. PLEASE NOTE
THAT THIS IS A BIG FILE. GIVE IT SOME TIME TO DOWNLOAD |
FREE
|
|
|
Loading the freely available Add Ins
With a standard installation of Excel, you are provided with a
number of add ins that you can activate. These add significant
functionality to Excel and should be loaded. |
FREE
|
(2 min) |
|
|
Quote of the page:
Luck is a matter of preparation meeting opportunity- Oprah Winfrey
(broadcaster)
|
|
|
More training required?
Visit the
TRAINING pages |
Do you like what you see. Tell your friends. If you have a
training coordinator
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 .
|
