ACL 303 Advanced ACL Concepts and Techniques: Functions and Scripts

CPE Credits: 25

Focus and Features

In this three-day course you will learn how to use ACL functions and scripts to gain new insight into your data and do more in less time. Functions let you investigate your data in ways you haven’t thought of before, adding power and detail to your analysis. Scripts let you automate routine ACL tasks, freeing up time to concentrate on activities that require critical thinking and judgment. Scripts also help preserve best practices, which prevent errors, and results in better controls in your Organisation.
ACL Certified trainers will show you how to implement scripts into your daily routine, and they will guide you through activities that illustrate how to work with scripts and functions efficiently and easily.

What You Will Learn

Functions
You will learn how to use functions in computed fields and filters to perform
•    Input validation
•    Data harmonization
•    Data cleansing
•    Data type conversion
•    String-specific or “wildcard’ searches
•    Complex recalculations
•    Advanced data manipulation

Scripts
You will learn how to automate ACL processes by creating and running scripts. You will learn how to:
•    Create interactive scripts
•    Edit and run scripts
•    Create variables
•    Develop multiline commands
•    Add processing efficiency and logic control to a script
•    Design simple, conditional, and nested groups
•    Design visual dialog boxes

Who Should Attend

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

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:  Aug 29-31st
Fee:  N 180,000(Exclusive of VAT)