CPD training for Professional

SAICA/ IRBA CPD Training available on our new site http://www.AuditExcel.com or go directly to the SAICA CPD training page .

These pages are designed to allow people to learn about using Microsoft Excel in a structured way. We have also built in the functionality to allow you to test yourself and at the same time verify that you have completed the training. This will be especially useful for professionals who need to earn points or hours that can be verified as training for the year e.g. (CA) SA (Chartered Accountants), CIMA, Doctors etc. It can also be used by people who want to improve their excel skills and include proof of this training on their CV's.

If you are struggling to watch the video clips due to your connection speed or network, see the bottom of the page to find out how to get a CD's with all the video clips included.

NOTE:

Due to the limited participants, the SMS line has been discontinued by the network provider. While we search for an alternate solution you can mail us the answers and we will verify them from our side. Send you mail to info@AuditExcel.co.za

Section 18: Goalseek (CPD= 20 min)

Goalseek (3 min)

The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis.

This clip also shows you how to perform a goalseek straight off a graph.

Data Tables (CPD= 30 min)

Data Tables (8 min)

Learn how to use Excel's Data Tables feature to automatically run multiple scenarios through a model.

Scenarios (CPD= 20 min)

Scenarios (4 min)

The scenario feature allows you to quickly change a number of input cells based on some pre defined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios.

The watch window (CPD= 20 min)

Watch Window (3 min)

The watch window allows you to continuously view cells that interest you (no matter where they are on the spreadsheet) while making changes to inputs in the model.

What If Exercise 1
Follow the instructions in the file.
What If Solution
What the end file should look like after the exercise
Question 18:
xxx

Answers:
A- xxx

B- xxx

C- xxx

SMS the letters CPD, the section number and answer to See Note Above (South Africa ONLY)
e.g. CPD 1F

To understand the terms and conditions of receiving the certificate of completed modules please visit this page- CPD Terms and Conditions

To find out more about getting all this training material on a convenient CD visit this page - All video clips on a convenient CD.

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 .