Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 19th Nov'24 to 29th Nov'24
Part 5/6 - Choosing your Data Analytical Software
- Management Use of Excel
- Use of Excel in financial analysis
- Data Acquisition
- Excel Database Functions
- Excel Financial Functions
- Ratio Analysis
- Du Pont Analysis
- Z-Score Analysis
- ACL Add-in
- Using ACL Scripts
- IDEA and Data Analysis
- SAS and Data Analysis
- Other Popular Audit Software
- ACL and Data Analysis
- Seeking Anomalous Data
- ACL Analysis Options
Overview of the webinar
While a variety of powerful tools are readily available today, the skills required to utilize such tools are not. Not only must the correct testing techniques be selected but the effective interpretation of outcomes presented by the software is essential in the drawing of appropriate conclusions based on the data analysis.
Who should attend?
- Director of Purchasing
- Product Design Engineer
- Procurement Specialist
- Vice President
- Global Product Compliance Manager
- Procurement Manager
- Director of Quality
- Training & Development Manager
- Quality Managers
- Internal Auditor
Why should you attend?
Since the spread of IT systems has made it a pre-requisite that auditors as well as management have the ability to examine high volumes of data and transaction in order to determine patterns and trends. In addition, the increasing need to continuously monitor and audit IT systems has created an imperative for the effective use of appropriate data mining tools.
This Series of 6 webinars is - based on Richard Cascarino’s book “Data Analytics for Internal Auditors” .
Part-1.Understanding Sampling for Auditors
- Judgmental vs Statistical Sampling
- Probability theory in Data Analysis
- Types of Evidence
- Population Analysis
- Correlations and Regressions
- Conducting the Audit
- Obtaining Information from IT Systems for Analysis
- Use of Computer Assisted Audit Techniques
- Analysis of Big Data
- Results Analysis and Validation
- Fraud Detection using Data Analysis
- Root Cause Analysis
Part-4.Analysis and Monitoring
- Data analysis and Continuous Monitoring
- Continuous Auditing
- Financial Analysis
Part-5.Data Analytics Software
- Excel and Data Analysis
- ACL and Data Analysis
- IDEA and Data Analysis
- SAS and Data Analysis
- Analysis Reporting
- Data Visualization and Presentation
Faculty - Mr.Richard Cascarino
Richard E. Cascarino, MBA, CIA, CISM, CFE, CRMA Well known in international auditing, Richard is a principal of Richard Cascarino & Associates based in Colorado, USA, and Johannesburg, South Africa with over 32 years experience in audit training and consultancy.
He is a regular speaker at National and International conferences and has presented courses throughout Africa, Europe, the Middle East, and the USA.
Richard is a Past President of the Institute of Internal Auditors in South Africa, was the founding Regional Director of the Southern African Region of the IIA-Inc, and is a member of ISACA, and the Association of Certified Fraud Examiners, where he is a member of the Board of Regents for Higher Education.
Richard was Chairman of the Audit Committee of Gauteng cluster 2 (Premier's office, Shared Services, and Health) in Johannesburg and was also the Chairman of the Audit and Risk Committee of the Department of Public Enterprises in South Africa.