Data Analytics for Auditors
November 2011 Webinars
Starting Up ACL Software™, Running Over 100 Reports Instantly, and Using the Latest Best Practices $89
Maximizing Microsoft Excel 2007 / 2010™
as a Data Analysis Audit Tool (3 Topics) $89
Special Offer
Sign up for both for only $150
Important Note: Upon payment we send out the registration instructions via email. You must check your email and open the email with the registration instructions. This is especially important if you use a free email account such as HotMail, Yahoo or Gmail.
Starting Up ACL Software™, Running Over 100 Reports Instantly, and Using the Latest Best Practices
November 2, 2011 11 am - 1 pm EDT
(2 CPEs) $89
Running over 100 reports, provided to each attendee as ACL SoftwareTM scripts, is just the start of what will be learned in this content-rich webinar. Novices to gurus will gleam knowledge from Rich Lanza's 20 year experience with ACL Software™ as he shares his best practices from data import to script writing. Any ACL practitioner, especially ones that need some "quick-hits" with the product, will walk away from the webinar with the necessary tools and knowledge.
Learning objectives include:
- Assess the top 10 data import issues and overcome them using ACL and associated best practices gained over the last 20 years.
- Understand how to build a script in less than two minutes that can add immediate value to your organization.
- Be able to run over 100 reports immediately after the course with a focus on top reports within accounts payable, general ledger, and payroll areas.
- Listen to case studies on detecting fraud and finding cash recoveries so they can be applied to your organization.
- See Rich's top scripting best practices in action.
Date: Wed., November 2, 2011
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
Your moderator:
Jim Kaplan, CIA, CFE, President of Auditnet
Speaker - Richard B. Lanza, CPA, CFE – President – Cash Recovery Partners, LLC
Helps companies identify their hidden
financial assets, mostly using technology and referring them to
specialists. He has two decades of experience in audit technology and
recovery auditing, becoming a leading authority in these areas.
Rich is the author of 13 publications and training courses including his first, 101 ACL Applications: A Toolkit for Today’s Auditor, the IIA’s Proactively Detecting Fraud With Computer Audit Reports, which earned him an award from the ACFE and recently, Cost Recovery: Turning Your Accounts Payable Department Into a Profit Center for John Wiley & Sons. Rich was also recently a key contributor to the IIA’s Global Technology Audit Guide (GTAG) Fraud in an Automated World and ISACA's Data Analytics - A Practical Approach research whitepapers.
He has worked for companies ranging in size from $30 million to $30 billion, and in all he has helped them produce tremendous savings through the use of technology and cost recovery initiatives. His websites, www.findmillions.net and www.auditsoftware.net, help companies to identify cost recovery and prospective savings in all areas of their business while implementing the latest in audit technology.
Additional Giveaways
-
101 ACL Applications: A Toolkit for Today's Auditors publication (including ACL document with 101 reports ready-made for ACL). Click here for the table of contents (Value $100)
-
Select chapters from Rich's latest publication: Cost Recovery: Turning Your Accounts Payable Department into a Profit Center.
-
Other advanced ACL scripts developed by Rich Lanza for use immediately to complete complex tasks.
TO SIGN UP FOR THIS EVENT CLICK HERE AND SELECT STARTING UP ACL SOFTWARE LINE IN THE PAYMENT BOX!
Maximizing Microsoft Excel 2007 / 2010™ as a Data Analysis Audit Tool
November 16, 2011
(2 CPEs) $89
Note: This webinar
will be split into the following three topics:
-
Applying Data Magic and Other Excel™ Alchemy
Data magic seems to appear when millions of dollars are revealed in potential recoveries. Learn about useful tests in the areas of accounts payable, contract auditing, payroll, and general ledger using Microsoft Excel™. Specific learning objectives include:
- Learn specific data analysis tests to query and mine data for gold in the areas of accounts payable, general ledger, contract auditing, and health benefit reviews using the most common data analysis tools.
- Obtain a list of minimum suggested reports to run on a periodic basis to improve any business process function.
- Be able to operate a Pivot Table template with your own accounts payable data to provide audit-report ready analysis.
-
Risk Ranking Your Spreadsheets and Auditing with Excel
Excel has permeated all of our business processes as it provides a flexible and simple-to-create development platform. However, the mini-systems built in Excel can be rife with errors given the lack of software methodology, poor security, and ease-of-change that comes with the Excel territory. Specific learning objectives include:
- Learn to risk assess an entire population of Excel spreadsheets in minutes using automated tools (provided in the webinar).
- Adopt a consistent methodology for scoring spreadsheets based on their impact and likelihood for failure.
- Spot the top areas of risk within spreadsheets based on past case studies of failure.
-
Graphing for Auditors
Finding errors, inefficiencies, and fraud is largely about understanding patterns, and making exceptions to those patterns stand out. Statistical analysis is an essential tool in that process. Another essential tool is graphing. In this course, you’ll learn how to translate unwieldy files of financial data, with tens of thousands of transactions ranging from $1 to $10 million, into a single compact scattergraph, pie chart, or overlay—and then to pick out the key items that merit sampling and follow-up. Specific learning objectives include:
- Understand the numerous Graph types and their different analytical strengths.
- Be able to operate a graph template for creating numerous audit-report ready presentations of payables, general ledger, and payroll data.
- Learning why financial data poses special statistical challenges for graphing purposes
Date: Wed., November 16, 2011
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded based on a 50-minute hour.
Program Level / Prerequisites and Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
Your moderator:
Jim Kaplan, CIA, CFE, President of Auditnet
Speaker - Richard B. Lanza, CPA, CFE – President – Cash Recovery Partners, LLC
Helps companies identify their hidden
financial assets, mostly using technology and referring them to
specialists. He has two decades of experience in audit technology and
recovery auditing, becoming a leading authority in these areas.
Rich is the author of 13 publications and training courses including his first, 101 ACL Applications: A Toolkit for Today’s Auditor, the IIA’s Proactively Detecting Fraud With Computer Audit Reports, which earned him an award from the ACFE and recently, Cost Recovery: Turning Your Accounts Payable Department Into a Profit Center for John Wiley & Sons. Rich was also recently a key contributor to the IIA’s Global Technology Audit Guide (GTAG) Fraud in an Automated World and ISACA's Data Analytics - A Practical Approach research whitepapers.
He has worked for companies ranging in size from $30 million to $30 billion, and in all he has helped them produce tremendous savings through the use of technology and cost recovery initiatives. His websites, www.findmillions.net and www.auditsoftware.net, help companies to identify cost recovery and prospective savings in all areas of their business while implementing the latest in audit technology.
Additional Giveaways
- Graphing template for numerous audit report ready presentations of payables, general ledger, and payroll data.
- Pivot Table template to assist in your next accounts payable audit using common payables information.
- 30-day free license to ActiveData for Excel.
- Macro template that will automatically calculate a risk score for every one of your Excel spreadsheets
Questions, complaint resolution, and refund policy
If you have any questions regarding the course, our administrative and complaint policies, or were not satisfied with this course and would like a refund of your seminar fee, please contact:
Richard B. Lanza,
President of Cash Recovery Partners, via the following means:
Phone: 201-650-4150
Fax: 973-270-2428
Email: rich@auditsoftware.net
Address: PO Box 31, Lake Hopatcong, NJ 07849
Cash Recovery Partners, 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.learningmarket.org.