SPREADSHEET
PROFESSIONAL TRAINING
|
| 1 |
Introduction
|
| |
A brief introduction of who we are, what the
issue is relating to spreadsheets and excel and what the spreadsheet training course
is looking to achieve. |
| 2 |
Auditing
Toolbar |
| |
Learn how to use the auditing toolbar in excel
as it is fundamental to understanding the inner workings of
a excel financial model |
| 3 |
Errors
in Spreadsheets- How and Why |
| |
A review of how some of the more common errors
happen in excel, how to spot these errors using Excel’s
inbuilt features and how to avoid making the errors in the future. |
|
|
SPREADSHEET
PROFESSIONAL
|
| 4 |
Reducing
the risks of spreadsheets in an organisation
|
| |
Some common sense ideas of addressing the growing
risk of business losses due to spreadsheet errors. |
| |
Loading Spreadsheet Professional and
setting it up for first use |
| |
How to load and use your copy of Spreadsheet
Professional (either the trial version or the full version) |
| |
Advice on the review process |
| |
Some advice based on our experience of the review
process and what you are trying to achieve. Provides guidelines
on a comprehensive financial model review process as used by
the major accounting firms. |
| 5 |
Maps
|
| |
Making use of the maps features in Spreadsheet
Professional, and what to look for in the patterns. |
| |
Prioritising the cells you look at |
| |
Using Spreadsheet Professional to prioritize
what cells to look at first and identifying cells that have
a high risk of error. |
| |
Comparisons |
| |
Learn to use Spreadsheet Professional to compare
spreadsheets for differences in inputs, formula or results.
|
| 6 |
Spreadsheet
Painter |
| |
Learn to use the Spreadsheet Painter to add meaning
to the spreadsheets you build and to help in the reviewing of
spreadsheets. |
| |
Spreadsheet Formula Tracer |
| |
Let Spreadsheet Professional help you visualize
complex formula. Particularly useful when building or reviewing
multi nested IF statements. |
| |
Sensitivity Tool |
| |
Learn to run Spreadsheet Professional’s
sensitivity tool on your spreadsheet models. Learn how to use
this in the review process. |
| |
Other Tools |
| |
Learn about the other tools available in Spreadsheet
Professional and how they can help you in building and reviewing
models. |
| |
Other reports |
| |
Learn about the other reports available in Spreadsheet
Professional and how they can help you in building and reviewing
models. |
| |
Options |
| |
Learn how to customize Spreadsheet Professional
to suit your needs. |
| 7 |
Getting
the best out of Spreadsheet Professional |
| |
Based on our experience, we have develops processes
and methods that we apply to Spreadsheet Professional results
that are even more meaningful. |
| |
| EXCEL HELP,
ADVICE AND INBUILT TOOLS |
| 8 |
Good
Spreadsheet Design |
| |
Learn about the best ways to design spreadsheet
models and why these techniques can reduce the number of Spreadsheet
Errors you make. |
| 9 |
External
Links |
| |
Learn how to use Excel’s inbuilt feature
to handle links between spreadsheets. |
| |
Find and Replace |
| |
Learn to use Find and Replace in the review process. |
| 10 |
Go
To Special |
| |
Use Excel’s inbuilt feature to track down
cells that exhibit certain characteristics. |
| For more details send
a mail to
|
