Audit Command Language (ACL 101) for Beginners - Principles & Concepts of ACL Analytics Training Course

This course is designed for beginner to intermediate level ACL users. It introduces you to the ACL user graphical interface with a view to have an appreciation of the software and all the functionalities that came inbuilt. It will give you the background to understand and use ACL in an interactive, hands-on learning environment. Participants will have the opportunity to learn vital data analysis concepts and principles that form the basics of working with ACL software. Examples used in class will illustrate how the software can aid in the execution of your assurance reviews as a vital tool for performing test on business data and other data analytics efforts that add value to your audits.

At the end of this training course, you will be able to:

1. Introduction to CAATs (Computer Assisted Audit Tools)

2. ACL Fundamentals

3. Understand the fundamentals of data analytics concepts, appreciate ACL software user graphical interface (GUI), ACL inbuilt features & functionalities and data analysis cycles.

4. Understand the stages or steps involved in data access.

5. Import various source data type.

6. Export data to other data types.

7. Create tables to access data (includes: flat files, report files, Excel, XML, ODBC, and dBASE data).

8. Display and filter data.

9. Data integrity verification (confirming control totals, testing for reliability, completeness, uniqueness and relationships, create expressions, compare data from different files/systems, profile data, and produce data reports for output).

10. Carry out Income Assurance by using it to periodically re-compute charges like COT, Interest income, commissions and other areas of Income leakage in your operations.

11. Identify missing items, errors, duplicates and gaps

12. Reorder and combine tables.

13. Employ ACL to add value to audits using simple use cases.

14. Visualizing with the Analytics15 Analysis Application.

Course Duration = 3 Days

Course Fee per participant = USD 1,500


<< ACL Training Course


To register for our ACL 101 for Beginners Training Course, please complete the form below or Send us an email at info@oxleyconsults.com.ng.




Back To Information and Cyber Security Jobs

Learn More About Our Valuable IT Audit Programs/Checklists

Learn More About Our Valuable IT Risk Assessment & Treatment Checklists/Programs

Learn More About Leading Practices in Internal Audit Function


Top Training Courses

This course provides in-depth coverage of the five domain areas of CISA exam. It is a preparatory course for CISA exam candidates and our instructors are the best.Learn More
This course provides in-depth coverage of the nine domain areas of CEH exam. It is a preparatory course for CEH exam candidates and our instructors are the best.Learn More
This course provide in-depth insight into how to perform security audit of your Oracle Database infrastructure including Oracle 8i, 9i, 10g, 11g, 12c. The course is a practical approach to audit Oracle Database.Learn More
This course provides comprehensive guide/insight on how users can conduct review on their enteprise UNIX/LINUX infrastructure to assure its security.Learn More
Learn about ISACA certifications for which we offer exam preparatory courses/training to prospective candidates/particiapnts. We have the best instructors that will help guarantee your exam success.Learn More
This course provides in-depth knowledge and assessment guide for audit/assurance professionals on how to conduction ISMS audit in line with ISO/IEC 27001 standard.Learn More
This course provides in-depth knowledge on how to use ACL to perform intermediate to expert data analysis and implement real use cases to solve problems.Learn More


Popular Articles

Investing in Information Technology is pivotal to the success of a business and realization of enterprise goals/objectives. To create value for the business using IT.Learn More
Fintech applications such as Online Banking has disrupted the traditional "brick and mortar" banking that we all have been accustomed to over the years. Online Banking application brought about easyLearn More
Protecting Automated Teller Machine (ATM) network end-to-end requires layered approach to security (implementing security at ATM endpoints, physical and logical network)Learn More
Audit management software are used to automate the process of auditing. Most standardized audit management software come handy with good audit process automation....Learn More
The 21st century as the information/digital age has presented numerous challenges and opportunities for humanity. From widespread industrial revolution to notable advances in IT.Learn More
Cloud computing is the practice of using network of remote computing infrastructures hosted on the Internet to store, manage, and process data for end users....Learn More
The series attempts to answer governance/management questions & how IT they are mapped to COBIT 5 Enterprise GoalsLearn More
Remote access software are tools used to access or take full control of computing systems from a remote location either to provide support, access files...Learn More
Privilege access mgt is one of the critical elements of user access mgt for every organization & building controls around them is vital for security of information/IT assets.Learn More
Cybersecurity threats and attacks are a real-world problem today with thousands of organizational networks and web facing applications being compromised dailyLearn More
Mobile hacking is an exciting field for cybersecurity enthusiast and at the same time lucrative for hackers. This is given significant rise in the number of mobileLearn More

IT Audit, IT Risk and Cyber Security eBooks By Nwabueze Ohia

Auditing Your Information Systems and IT infrastructure: Practical Audit Programs/Checklists for Internal AuditorsGet Now
IT Infrastructure Risk & Vulnerability Library: A Consolidated Register of Operational & Technology Infrastructure Vulnerabilities for IT Assurance ProfessionalsGet Now
Auditing Your Payment Cards Processes, Systems and Applications: A Step By Step PCIDSS Compliance Audit Program For Brands, Issuers, Acquirers, ProcessorsGet Now
Auditing Your Windows Infrastructure, Intranet And Internet Security: A Practical Audit Program for Assurance ProfessionalsGet Now


Let us know your thoughts post. Leave a Comment below.