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 14: Pivot Tables (CPD= 45 min)

Pivot Tables (9 minutes)

Pivot tables allows you to report on vast sums of information in a quick and efficient manner.

Data Reporting Exercise (30 minutes)

Follow the instructions in the file.

Data Reporting Exercise Solution (6 minutes)

Question 14
Which of the following statements is FALSE with regards Pivot tables

Answers:
A- Pivot Table enable you to manipulate a database into several different reports with ease

B- Pivot table allow you to convert a report into a graph

C- Pivot tables allow you have blanks in the headers

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

Section 15: Conditional Formatting (CPD= 40 min)

Conditional formatting (10 minutes)

Learn how to use Excel's conditional formatting to automatically change the format of a cell based either on the contents of the cell itself, or the contents of another cell.

Conditional formatting exercise (26 minutes)
Follow the instructions in the file.
Conditional Formatting Exercise Solution (4 minutes)

Question 15:
Conditional formatting allows you to do the following

Answers:
A- Change the format of a cell/s on a permanent basis

B- Change the format depending on the contents of the cells or other cells

C- Protect a cell/s format from being overwritten with a password

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 .