|
|
2025/12/08 to 2025/12/09
|
|
When:
|
8-9 December 2025
Registration starts at 8:15
|
|
Where:
|
Map this event »
Definitive Conferencing
Corner of Definitive Lane & Kruin street
Harmelia
Isando, Gauteng 1619
South Africa
|
|
Presenter:
|
Prozilog
|
|
Contact:
|
Project Coordinator: CPD and Events
neo@governanceacademy.co.za
011 609 1761 Ext 403
|
|
|
« Go to Upcoming Event List
|
|
| Presenter/s: | Prozilog | | Duration: | 2 Days | | CPD Hours: | 16 | | Fees | ex VAT | inc VAT | | | Member: | R6 620.00 | R7 613.00 | | | Non-Member: | R7 640.00 | R8 787.00 | | | Seminar Objective Upon completing the course, participants will have an understanding of how to utilise excel as a CAA T 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
- Using Conditional Formatting
- Using Icon Sets to Mark Values
- Turning Your Data on Its Side with Transpose
- Looking up Data
- Getting Good Records from Bad Data
- Sorting Your Data
- Analyzing Data with Pivot Tables
- Creating a Random Sample from a Dataset
- Finding and Analyzing Records Using AutoFilter
- Formula Auditing
- Matching Two Lists
- Finding Duplicates or Unique Values
- Reporting using Excel
All information is explained using actual data in interactive case studies | Who should attend? - Entry or introductory level for those requiring a fundamental understanding
- Internal auditors who are already practicing internal audit and have a basic understanding of the subject
| Level 1 | | Entry or introductory level for those requiring a fundamental understanding of the subject. | | Level 2 | | Internal auditors who are already practicing internal audit and have a basic understanding of the subject | | Level 3 | | Supervisory/competent/senior internal auditors: those who already have a sound, practical grasp of the fundamentals of internal auditing and manage staff | | Level 4 | | For advanced internal auditors: Auditors with excellent understanding of topics being presented, who are interested in exchanging knowledge with instructors and other participants | | | Please be advised of the event terms and conditions.
Delegates are also requested to review the content and the levels of the courses presented before booking, to ensure they are attending the right course. |
|
|
|
Print Page
