Spreadsheet Professional
|
|
|
Excel spreadsheets are generally extremely difficult to review
or audit to ensure that they are accurate. The process generally
requires a cell by cell review which can be extremely time consuming
and inefficient for the person doing the review. Fatigue and complacency
mean that an audit is seldom done properly or to the extent required.
Spreadsheet Professional alleviates these issues and increases
the probability of finding errors in Excel spreadsheets and
therefore improves the quality of your models, |
whether they are financial
models or built for some other purpose (engineering, actuarial etc.).
Spreadsheet Professional assists by investigating formula
consistency, comparing different spreadsheets, providing visual
representation of complex formulas and identifying typical errors
found in excel spreadsheets.
|
|
|
If you have a ‘slowish’ internet connection,
download (right click and then Save target) the video
clip of Spreadsheet Professional. You can also read more about
Spreadsheet Professional by going to the Spreadsheet
Professional pages. Added benefits of using Spreadsheet Professional are that it tends
to improve the modelling techniques of your developers and therefore
results in improved design, development, review and audit of all
types of spreadsheet models in Microsoft Excel.
As a result of using Spreadsheet Professional your organisation
will enhance the tools already available in Excel. Even a high level
use of Spreadsheet Professional will show up errors that would normally
take hours to find.
|
The other major benefit will be the enhanced productivity of your
staff as they spend less time identifying excel spreadsheet errors
and are more thorough in the process. In some cases up to 80% of
the time spent looking for errors in spreadsheets can be saved.
The alternate is looking at a spreadsheet on a cell by cell basis
and hoping that your concentration lasts.
Inbuilt features of Excel
Excel has developed over the years to be one of the most feature
packed software packages out there. However, most Excel users have
only learnt about some of the inbuilt tools available, and then
only on a trial and error basis. This means that some functions
which are simple and already exist in Excel are redeveloped and
therefore can cause errors. Our training
section highlights some of these features and how that can be used.
|
