ACL Training
ACL Analytics
Our instructors all have an Accounting Background. Make the most out of your ACL Analytics now.
Audit Command Language [ACL] Data Analytics
We pride ourselves in customer oriented services, expert content and technical support to help you achieve success. We are here to empower your people, processes and methodologies with technology and best practices. To match strategic objectives with technical necessities. You may chose from classroom or onsite training.
For organizations looking for tailored instruction, ACL Certified Trainers can come to you to onboard your team. Our training team reaches out to you to understand your needs, coordinate the preparation of facilities, and delivers tailored learning experiences. Bring the classroom to you, working in your space with your data.
ACL Foundations
Duration: 24 Hrs
Course Level: Basic
Fields of Study
- Specialized Knowledge and Applications
- Data Analytics
Prerequisites
- Minimal or no experience with ACL™ Analytics.
This is a group-live, instructor-led course in an interactive classroom. This course introduces fundamental concepts and maintains a comprehensible, progressive approach that follows the five phases of the data analysis cycle. The course incorporates an instructor-led case study, which enhances the learning process by seeing how a typical audit/data analysis project is conducted in ACL™ Analytics.
This three-day course is a comprehensive introduction to ACL™ Analytics, designed for new and beginner users who want to learn the concepts and features needed to start using ACL™ Analytics. In an interactive hands-on environment, you will learn fundamentals such as basic data concepts and how to work within the ACL™ Analytics environment, as well as integral skills such as how to conduct analysis steps and procedures and accomplish analysis objectives in ACL™ Analytics. You will learn the proper methodology and best practices for all five phases of the data analysis cycle (planning, importing, preparing, analysing, and reporting). On the third day, basic scripting will be introduced. Through this comprehensive introduction and practical application, you will learn how to effectively use ACL™ Analytics to accomplish your audit and/or business objectives.
- Efficiently and effectively using ACL™ Analytics to achieve your analysis objectives, report your findings, and build a narrative of your organization’s data.
- Reduce time and resources needed to analyze data.
- Detect gaps and control failures.
- Leverage hundreds of built-in data analysis commands and tools.
- Access and reconcile data from various systems in order to identify potential issues.
- Identify outliers and issues.
- Analyze data to achieve objectives.
- Combine data from multiple source types in order to make comparisons between them.
- Identify trends between issues that may be indicative of the root cause(s) of the problem.
- Create working paper documentation detailing your objectives, the analysis steps taken to achieve them, and the results returned.
- Use basic scripting to automate processes and initiate continuous monitoring.
ACL Applications
Duration: 16 Hrs
Course Level: Intermediate
Fields of Study
- Specialized Knowledge and Applications
- Data Analytics
Prerequisites
- ACL™ Foundations-level course or self-taught to comparable level.
This is a group-live, instructor-led course in an interactive classroom. To complete case study analysis, you will use the latest version of ACL™ Analytics. Under the guidance of your ACL™ Certified trainer, you will progressively develop the ability to work independently. At the end of each case, the full solution will be demonstrated.
This two-day course is a practical application of ACL™ Analytics, designed for users who want to use ACL™ Analytics more effectively in real-life situations. By working through a series of progressively challenging case studies, you will develop your critical thinking and application of ACL™ Analytics. In an interactive, hands-on environment, your ACL™ Certified trainer will teach you to accomplish data analysis tasks of varying complexity through the integration of ACL™ commands and expressions. Through this practical application, you will learn how to effectively separate objectives into manageable milestones and enhance your effectiveness with ACL™ Analytics.
The case studies include business-relevant data such as Purchasing to Payables, Travel & Entertainment, and Procurement expenses.
- Apply ACL™ Analytics in a structured data analysis process.
- Critically determine and assess objectives and planning analysis.
- Separate objectives into intuitive milestones.
- Import various source data types.
- Prepare data for analysis (data integrity tests such as controls, bounds, completeness, uniqueness, relationships and reliability; critically assessing whether integrity issues will impair analysis objectives).
- Identify and apply the ACL™ Analytics functionality needed to achieve desired objectives.
- Test issues to identify trends that may be indicative of cause(s) of them.
- Create working paper documentation showing your objectives, the analysis steps taken to achieve them, and the results returned.
ACL Scripting
Duration: 24 Hrs
Course Level: Advanced
Fields of Study
- Specialized Knowledge and Applications
- Data Analytics
Prerequisites
- ACL Applications-level course or at least six months previous experience using ACL™ Analytics.
This is a group-live, instructor-led course in an interactive classroom. For in-class activities, participants use the latest version of ACL Analytics. The class size supports individual attention and development.
In this three-day course, you will learn how to use ACL Analytics 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 Analytics tasks, freeing up time to concentrate on activities that require critical thinking and judgment. Scripts also help preserve best practices, which prevents 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.
- Create simple and interactive scripts to implement automated routines, continuous monitoring and gain further insight into your data.
- Apply ACL commands and functions to perform parsing and harmonization of complex fields.
- Apply ACL commands and functions to search for matching data.