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) |
Calculate the Compound Annual Growth Rate
(CAGR) using Excel (NEW)
Use the RATE function to calculate the CAGR |
FREE |
CAGR
(2 min) |
 |
Show the underlying formulae in all
cells
A shortcut which allows you to show either the results in all cells
or the underlying formula in the cells. |
FREE
|
|
|
Filling in the blank cells quickly and
easily
There are occasions when you would like to fill in all blank cells
with a formula. This is a quick and easy way to achieve this. Use is
made of the GoTo Special
command so it may be worthwhile learning about it. |
FREE
|
|
|
Cleaning up data using the Data
Autofilter
Excel is often used as a means of cleaning up data and produces
reports. Often the most time consuming aspect is the data cleanup.
Using the Data AutoFilter it is possible to achieve more in less time. |
FREE
|
(7 min) |
|
Changing Multiple Worksheets at the same
time
In Excel it is possible to change a number of worksheets at the same
time. Extremely useful but don't forget to switch it off once you are
done! |
FREE |
(4 min) |
|
Automatic sorting of a list
Rank a list of numbers and then automatically (without macros) have
the numbers sort themselves into your preferred order (and pull other
information with it if necessary). Can be used to generate sport
league tables e.g. English Premiership log or the World Cup Soccer
logs.
You need to know the workings of the
VLOOKUP and
RANK functions.
|
FREE |
Automatic Sort
(5 min) |
|
|
Quote of the page:
In the end, all business operations can be reduced to three words:
people, product, and profits.- Lee Iacocca
|
|
|
Spreadsheet Professional is the world's favorite auditing add in. Find
out more on the Spreadsheet
Professional pages!! |
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.
