vlookup errors

Training Index

Continuing Professional Development for South Africa

   

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

If you are struggling to find the time to obtain your verifiable CPD training for SAICA we have launched some pages just for you. As a Chartered Accountant in South Africa it is not always easy to find 20 hours training that is verifiable, flexible and affordable. This is where we hope to help out.

Our Excel training has been set up in such a way that, using SMS, we will be able to verify that you have completed the courses. As it is available over the internet you will be able to do a little bit at a time instead of trying to find continuous hours to attend courses. You can do it from home or from work or wherever you have a computer and an internet connection. For more details on how these pages work please see the details at the bottom of the page. To get started, choose the title that interests you and click on the adjacent link. Alternatively just start at the beginning and work through it. Watch the video clip, do the exercises, answer the questions.

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

 

 

Title  

The Essentials- Function Wizard, Auditing Toolbar and Design Tips (110 CPD minutes)

Cleaning up a Spreadsheet- AutoFilter, GoTo Special, Paste Special & Transpose (145 CPD minutes)

Manipulating your data- Vlookup, EOMONTH etc (100 CPD minutes)

Reporting your data- Pivot Tables and Conditional Formating (85 CPD minutes)

Finance Functions- PMT, IRR, NPV etc (90 CPD minutes)

What If tools- Goalseek, Watch window etc (90 CPD minutes)

CPD1

CPD2

CPD3

CPD4

CPD5

CPD6

Google
Web AuditExcel.co.za

Spreadsheet Professional is the world's favorite auditing add in. Find out more on the Spreadsheet Professional pages!!

For the terms and conditions of this service click on these words- CPD Terms and Conditions

Do you like what you see. Tell your friends. If you have a training co-ordinator at your organisation tell them that there is free excel training available at this site.

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 .

 

 

 

Home | Contact Us | Sitemap | Training | Sarbanes Oxley | Articles | Links | Blog