ACL Certified Training
Register
for this training course
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 organization.
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
- 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
Date: May 26 - 28
Fees: N120,000.00
For
enquiries:
1. Call Jason 0803 5861053
2. E-mail us for a nomination form at ise@phillipsconsulting.net
| 
