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 past 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 Free Limited seating with preference for Registered AuditNet Subscribers (excluding free) and Site License Users.
AuditNet 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 final 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.
All materials contained on this site are protected by United States copyright law and may not be reproduced, distributed, transmitted, displayed, published, broadcast, performed nor used to prepare derivative works, without the prior written permission of AuditNet®. You may not alter or remove any trademark, copyright, logo or other notice from copies of the content. For further information, see section 1 of the Terms and Conditions and section 2 of the Subscriber Access Agreement.