Untitled Document
Print Page   |   Contact Us   |   Report Abuse   |   Sign In   |   Register
Community Search
Intermediate Excel for Internal Auditors (INTEX) 24-25 November 2025 (Face-to-Face)
Register Map this EventMap this Event Tell a Friend About This EventTell a Friend
 

 Export to Your Calendar 2025/11/24 to 2025/11/25
When: 24-25 November 2025
08:30
Where: Map this event »
Definitive Conferencing
Corner of Definitive Lane & Kruin street
Harmelia
Isando 1619
South Africa
Presenter: Prozilog
Contact: Project Coordinator: CPD and Events
neo@governanceacademy.co.za
011 609 1761 Ext 411


Online registration is available until: 2025/11/24
« Go to Upcoming Event List  

Presenter/s:

Prozilog

Duration:

2 Days – Classroom Only

CPD Hours:

16

Fees:

Excl VAT

Incl VAT

IIASA Member:

R 6747.00

R 7759.00

IIASA Non-Member:

R 7786.00

R 8954.00

Course Description

A prerequisite for attending this course is the successful completion of the Basic Excel course for Internal Auditors (EXCEL).

Internal Auditors attending this course will be able to build upon the knowledge and skills acquired during the Beginners’ Course (EXCEL) and learn more about the use of Excel as both a General Audit Tool as well as a Data Analysis Tool. Internal Auditors will be able to design their own formulas and solutions to general audit procedures and basic Data Analysis solutions.

 

Course Content

Elaboration on Basic Excel Skills

  • Extended Formulas and Functions
  • Formula and Spreadsheet Auditing
  • Resolving Formula Issues
  • Spreadsheet and File Protection
  • Create Named Cells and Ranges
  • Group Sheets
  • Go To / Go To Special
  • Lookup Formulas for Data Analysis
  • IF-Functions and designing your own formulas
  • Text Formulas
  • Financial Formulas
  • Date Formulas
  • Statistical Formulas

    Introduction to Data Analysis

  • Data Imports
  • Data Validation
  • Data Cleaning
  • Pre-set Filters and Rule-based Filters
  • Pivot Tables
  • Slicers and Graphs

Macros and Coding

  • Find and Run Installed Macros
  • Record and playback own Macros
  • Adjust a recorded Macro

     

    Reporting

  • Building Interactive Reports in Excel and Transferring Interactive Reports to other Microsoft Applications such as Word and PowerPoint.

 

Practical Fraud Analysis using Excel

 

Principle 3 – Demonstrate Competency Standard 3.1 - Competency

 

Continuous Case Studies using Internal Audit related scenarios and data.

 

Post-assessment: Major Case Study

 

Who should attend?

 

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.

 
Membership Management Software Powered by YourMembership  ::  Legal