ACL 105 Foundations of ACL: Concepts and Practices

CPE Credits: 25

Focus and Features
Designed for beginner to intermediate level users of ACL, this three-day course introduces you to ACL in an interactive, hands-on learning environment. You will learn key data analysis concepts and the basics of working with ACL software. Examples used in class will illustrate how the software can add value to your audits

What You Will Learn

Fundamentals
•    Data concepts
•    ACL basics
•    Data analysis cycle

Data Access
•    Three stages of data access
•    Creating tables to access data (includes: flat files, report files, Excel, ODBC, and dBASE data)
•    Displaying and filtering data

Data Integrity Verification
•    Verifying integrity
•    Confirming control totals
•    Checking for correct bounds
•    Identifying missing items
•    Identifying duplicates
•    Testing for reliability

Data Analysis
•    Working with computed fields
•    Isolating data
•    Profiling data
•    Reordering tables
•    Combining tables

Reporting Results
•    Creating a report from a view
•    Advanced reporting
•    Graphing results
•    Using the log
•    Documenting your analysis

Who Should Attend

Financial, Operational, and External Auditors; Information System Auditors and Audit Management; Data analysts and Financial Control personal; Prospective ACL users.

Prerequisites

Participants should have a basic knowledge of Windows

Course Method

This is a live, instructor-led course in a classroom setting. For in-class activities, participants use the latest version of ACL. The class size supports individual attention and development.

Duration: 3 days
Dates: May 9-11th, Oct 10-12th(Exclusive of VAT)
Fee:  N 120,000