Print Page   |   Sign In   |   Register
Search
Members
Claudelle von EckChief Executive Officer of the IIA SA

Excel for Beginners: Tools for Internal Auditors (EXCEL) 6-7 February 2018
Register Map this EventMap this Event Tell a Friend About This EventTell a Friend
 

Participants should bring their own computers

 Export to Your Calendar 2018-02-06 to 2018-02-07
When: 6-7 February 2018
Registration starts at 8am
Where: Map this event »
Leadership Academy
Edenvale, 7th Avenue no 71
Block B
Johannesburg, Gauteng  1609
South Africa
Contact: Project Coordinator: CPD and Events


Online registration is available until: 2018-02-06
« Go to Upcoming Event List  

Untitled Document

Presenter/s: Prozilog
Duration: 2 Days
CPD Hours: 16
Fees
ex VAT
inc VAT
  Member:
R4 528.94
R5 163
  Non-Member:
R5 489.47
R6 258

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

A 10% discount applies if 2 or more participants from the same company attend this course.
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.

Sign In
Sign In securely
Blogs
Upcoming Events

2018-02-01 » 2018-02-02
Building a Sustainable Quality Program (BSQP)1-2 February 2018 JHB

2018-02-06 » 2018-02-07
Excel for Beginners: Tools for Internal Auditors (EXCEL) 6-7 February 2018

2018-02-08 » 2018-02-09
CIA Learning System Instructor-Led Course - Part 1 (CIA1) - 8-9 February 2018

2018-02-21 » 2018-02-23
Performing an Effective Quality Assessment (PEQA) 21-23 February 2018 - Western Cape