The primary reason to use data analytics to find fraud is because a lot of internal control systems have serious control weaknesses. In order to effectively test and monitor internal controls,organizations need to look at every transaction that takes place and test them against established parameters, across applications, across systems, from dissimilar applications and data sources. Most internal control systems simply cannot handle this. On top of that, as we implement internal systems, some controls are never even turned on.(ACL e-Book)
Internal audit departments are starting to embrace data analytics, but many have far to go to achieve their full potential, according to a survey from global consulting firm Protiviti. Data analytics does not need to be difficult or time consuming to start and in this course, we will focus on the key testing tools available within Microsoft Excel to be an effective data analytic auditor. Using case studies and sample data, basic to intermediate Excel techniques will be discussed for completing 10 analytic tests to benefit any audit program. From stratifications to fuzzy joining of tables, the top techniques that help minimize fraud and process risks will be explored.
Specific learning objectives include:
- Based on experience, learn why we selected our top 10 analytic tests.
- Use a case study set of examples in payables and general ledger to see how audit steps can be automated into analytics using Excel.
- Use Excel as audit software, able to mimic practically all data analytic commands found in more advanced tools.
- Apply analytics across the entire lifecycle from risk assessment, to planning, fieldwork, and reporting.
- CPE: 2 Credits
- Program Level / Prerequisites and Advance Preparation: Basic / None
- Delivery Method: Group Internet Based
- Category: Specialized Knowledge and Applications
- Cost: Individual: $0 for Subscribers and Site License Users (Note: non-subscribers and non site license users must opt-in to our promotions or pay to be eligible to attend and earn CPE).
Limited seating with preference for Registered AuditNet Subscribers (excluding no fee) and Site License Users.
If you are not a subscriber or site license user you must agree to opt-in to our mailing list. If you choose to opt out and do not pay to attend the Webinar we will notify you that your registration will be cancelled and you will not be able to attend. The registration system is set up to automatically approve your registration however this does not ensure that you will be able to join.
AuditNet LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of CPE on the National Registry of CPE Sponsors. State boards of accountancy have the authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.