NOTE:

This is a sample of what the training course looks like on the CD.

The items in this bright yellow can be clicked on and a sample of the  video clip viewed.

You can also read through the contents on what the course consists of.

How to use this course

First and foremost because this is video, you can replay, pause, rewind, and fast forward. You can watch a little, pause and try, and then continue. You can break the course into bite size chunks to suite your time constraints. But whatever you do, work through all the presentations and/ or exercises. Each section will save you time in your normal day. Use all these features to get the most out of Excel.

We suggest you follow the guidance provided by the Course File (available below). You can replay the whole or segments of the  video to cement your understanding. The video will pop up in a separate screen. When you are finished close it down. You can always reopen it. Similarly with the exercises, once you have finished close down the unnecessary folders to avoid clutter. We suggest you watch all the videos in sequence to get a good understanding of what Spreadsheet Professional can do for you.

Meanings of Symbols used below:

= Course Documentation for printing = Video Clip to watch    = Excel file containing exercise

 

Financial Model reviews using Spreadsheet Professional

 
Before you start we recommend you print out the following document which is referred to as the Course File.

Course File

This documentation can be used in conjunction with the video clips and exercises. Use the documentation as a guide through the course. It also contains all the print outs to avoid you having to re print continuously.

Now you can get started by watching the video clip below.

Getting Started

How to use the videos, loading the software and customising it for this course

 

The Spreadsheet Model review process

The review process and the feedback template.

 

Maps

How to use the Maps feature in Spreadsheet Professional.

 

Maps Exercise

 

Prioritising the cells you look at

Which cells to look at first to find the errors

 

Understanding all the tests performed.

What do all the tests mean?

 

Calculation Tests Exercise

 

Comparing Spreadsheets

A quick way to compare spreadsheets to find differences.

 

Comparison Exercise

 
Some additional advice for reviewing spreadsheets

A brief presentation on other things you can do to make better use of Spreadsheet Professional

 

That is the basis of spreadsheet reviews. However, Spreadsheet Professional has a number of other useful features. These have been included below.

 
The Spreadsheet Painter

 Quickly color the cells in a spreadsheet depending on whether they are inputs, calculations, text etc.

 
The Formula Tracer

 Obtain a diagrammatic representation of any formula and drill down to see what cells are used.

 
The Sensitivity Tool

 Run a sensitivity on your spreadsheet in 4 clicks

 
Other tools

 Learn about the Translation bar and the Spreadsheet Checker

 
Other Reports Available

See the other reports that are available to document the spreadsheet you are reviewing

 
Choosing your Preferences

 Customize your version of Spreadsheet Professional to meet your exact needs.

 
If you have any questions you are welcome to contact us at info@AuditExcel.co.za .