Excel for beginners - tools for internal auditors

Seminar Objective:

Upon completing the course, participants will have an understanding of how to utilise excel as a CAAT tool to analyse and interrogate data.

Seminar Content
• Introduction to excel as a computer assisted auditing technique
• Using Excel to analyse and interrogate data
• Downloading data from various formats into Excel
• Specific CAAT's tools using Excel
o Using Conditional Formatting
o Using Icon Sets to Mark Values
o Turning Your Data on Its Side with Transpose
o Looking up Data
o Getting Good Records from Bad Data
o Sorting Your Data
o Analysing Data with Pivot Tables
o Creating a Random Sample from a Dataset
o Finding and Analyzing Records Using AutoFilter
o Formula Auditing
o Matching Two Lists
o Finding Duplicates or Unique Values
• Reporting using Excel
• All information is explained using actual data in interactive case
studies

COST PER DELEGATE (Incl vat):
MEMBERS:R3 410
NON MEMBERS:R4 180

Click here to download course information:
http://www.iiasa.org.za/files/courses/EXCEL.pdf

Date: 20 February 2013 to 22 February 2013
Time: 08:00 - 16:30
Venue: Corporate Conference Centre, Johannesburg
Cost: R3410 - R4180