ACL Software Training Classes & Course Overview
Sunera offers ACL training classes to both Corporate/Government clients (details below) and Individuals (link) .
Corporate/Government ACL Training Classes - Are you planning to make your internal audits more efficient and effective by using Audit Command Language (ACL) software? Sunera offers two-day and three-day on-site ACL training courses for Internal Audit Departments to help auditors become more proficient with ACL. Our ACL training classes are designed to be interactive and relevant which should result in the Internal Audit Department staff members applying the lessons learned to their workplace. As part of making the ACL training relevant, we typically utilize data extracts from the client, which are incorporated into the examples developed and used during the training course. The ACL class is taught using a hands-on training approach based on ACL license availability.
The hands-on training presentation is given by an ACL Certified Data Analyst with years of practical experience in all industries and delivering training classes for over 10 years. Additionally, we have the can provide up to 7 CPE credits for each course takers’ completed day of training.
Individuals - If you are an individual who wishes to register for one of Sunera’s ACL software training classes or just find out more information, please follow the below link to view our upcoming dates and locations as well as cost.
Link - ACL Class Registration
NASBA Registration
Sunera LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority of the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN 37219-2417. Telephone 615.880.4200. Web site www.nasba.org. Sponsor # 108908
ACL Software Training Course Schedule
The first day will cover the basics of ACL to ensure the participants understand the fundamentals of the tool. Furthermore, the focus will be on how and when to practically use each ACL technique.
Day 1 will include:
- Project organization
- Data imports
- Tables / formats / log files
- Setting up fields and variables
- Filters
- ACL basic functionality
- Sort / Summarize / Joins
- Managing through data issues
- Date fields
- Introduction to Scripts
The second day will be focused on reinforcing some of the lessons learned on Day 1, developing basic and advanced scripts, and tackling some of the more difficult data issues including importing from pdf reports.
Day 2 will include:
- Advanced scripting techniques
- Group / Loop commands
- Anti-fraud techniques
- User input handling / interactive functionality
- Introduction to continuous monitoring techniques
The third day (optional but recommended) will be focused on establishing a continuous monitoring program using ACL. Scripts will be designed to take advantage of ACL’s ability to store and compare data over time.
Day 3 will include:
- Continuous Monitoring Techniques
- Variable Substitution
- ODBC connections
- Types of continuous monitoring procedures
- User input handling to support CM
- Working with dated tables
- Other continuous monitoring techniques
Cost
The below table summarizes the cost to deliver Sunera's ACL training class to either corporate or government entities.
| Cost | Description |
| $1500 | Class Preparation. We customize class using your company’s data |
| $3000/$4500 | 2 Day ACL Class or 3 Day ACL Class (3 Day Class Recommended) |
| Variable | Reasonable travel expenses for Sunera’s trainer |
