AuditNet®

Excel and Other Stats for Auditors Training

 

Sign up for General Audit Statistics and Software Training without Travel Series
June-September Special

 

Sign up for the ACL Webinar Training Series and for a limited time also get access to the Video Vignettes!

or If you are only interested in the training without CPE then subscribe to AuditSoftwareVideos

 

Excel & Other Audit Software Training - $190 After Rebates

 

Package Price includes 14 CPE and 12 Months Access to 28 Hours of Excel & Other Audit Software Training

 $449

·         E-Books by Mr. Excel (Bill Jelen) – (1) Excel for Auditors, (2) VLOOKUP Awesome Quick, and (3) Excel Gurus Gone Wild

($ 60)

·         6 Months Additional Access (18 months total) to Excel & Other Audit Software Video Training

($199)

Net Cost After Rebates

$190

 

ACLTM Software Training and Excel & Other Audit Software – $150 After Rebates

 

Package Price includes 28 CPE and 12 Months Access of 60 Hours of ACLTM / Excel & Audit Software Training

 $799

·         Payables Test Set for ACLTM – includes 30 ACL scripts and book on auditing the payables area

($200)

·         E-Books by Mr. Excel (Bill Jelen) – (1) Excel for Auditors, (2) VLOOKUP Awesome Quick, and (3) Excel Gurus Gone Wild

($ 51)

·         6 Months Access (18 months total) to ACL Video Training

($199)

·         6 Months Access (18 months total) to Excel & Other Audit Software Video Training

($199)

Net Cost After Rebates

$150

 

Payment Information

 

Below is the link to our Merchant Account (PayPal) to pay by credit card. If you are unable to make payment through PayPal it may be because of your browser settings. If you have a PayPal account it will first prompt you to use PayPal for payment. To pay by credit card indicate that you do not want to use your PayPal information but would like to pay by credit card. If these options do not work then you can :

  • Send an email to webinars@auditnet.org and request an invoice,

  • Pay over the phone by leaving a message at 1-800-385-1625 (Toll Free U.S.)

  • Fill out the Credit Card Order Form and send it by email or FAX it to 703-991-0876 (you will need to send us an email to receive the password to open the form)
Special Pricing June-December 2012


 

Receive the expert audit software training you’ve been looking for right from your own office. AuditSoftware.net developed specialized web-based audit software training course focused on retention and quick practical application of your Excel knowledge. This web-based program of Excel and other related courses provides you with the know-how and tools to use Excel effectively- and quickly - within your organization. Already developed scripts and sample data files will be included to jump start your project work and can be used in future testing and training. Live webinar courses will be offered giving you the opportunity to apply new skills to your audit projects with measurable results. Accessing the recorded version of these webinars provides the reference capability you need during project work throughout the month and beyond.

 

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.

 

 

Sign Up for the Individual Live Classes Available for 2012 as Well

Cost $89 (2.0 CPE) each 7 Webinars

Audit Software Training Webinar Series

Package Pricing Audit Software Only or Audit Software and ACL

 

*** - Key Note for All Webinars – Once a webinar is complete, the user will have 12 months access to a taped version of the webinar in its entirety, along with links to any needed data files for the courses.  This access will expire one year after the date of the live webinar.    No CPE credits are available for this video yet it is provided for later viewing and practice, such as closer to an actual audit date. 

JULY 2012

 

Benfords Law and Other Mathematical Theories in Auditing - Part 2 July 18, 2012

 

This course will continue from the original course and will delve into additional mathematical phenomenon that can be used by auditors.

Date: July 18, 2012

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

 

AUGUST 2012

 

Active Data for Excel - The Perfect Complement to any Data Analysis Function Practical Case Studies - August 9, 2012

This course assists auditors in implementing data analysis routines using ActiveData for Microsoft ExcelTM, a popular Excel add-in that allows users to complete many audit software tasks right in Excel.   The course comes with a 30-day free license to the product add-in that works directly within Excel.

The specific learning topics are:

  • Understand the powerful combination of ActiveData and Excel
  • Master basic techniques for importing managing data
  • Using sample data, run and view results in report format
  • Learn how skills learned can be transferred to ACL and other data analysis tools

Date: August 9, 2012

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

 

 

Pivot Tables for Auditors August 22, 2012

An entire course devoted to example audit reports and other analysis that can be performed with Pivot Tables in Microsoft Excel.  Sample Pivot Tables and data will be provided to jump-start your program.

 

 

Date: August 22, 2012

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

 

 

OCTOBER 2012

 

9. Using Excel's Functions, Formatting Audit Tools October 24, 2012

Learn about various ACL functions that can assist in a data analysis audit or in completing your workpapers in Excel.  Also learn the ins and outs of Excel’s own audit tools

 

 

Date: October 24, 2012

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

 

November 2012

 

Active Data for Excel - Advanced Techniques and Tests  November 6, 2012

 

Some of the more advanced techniques and tests will be covered in this Active Data course.  Building

 

The specific learning topics are:

  • Apply more advanced techniques in analyzing data including stratifying, digital analysis, and identifying duplicates
  • Learn 16 common fraud detection, cash recovery, and audit tests within accounts payable, accounts receivable and general ledger audit areas
  • Using sample data, run and view results in report format

 

Date: November 6, 2012

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

 

DECEMBER 2012

 

Best Practices in Audit Software Implementations December 6

Are you paying more than you should for software? Do you need a solid plan to maximize technology this year? Gain a clear definition of the audit, anti-fraud, and assurance software market, ensuring you create the best business plan before buying anything. See the forecasted industry trends that will affect your next purchase so you don't select the wrong technology.  Learn best practices for your next installation to avoid any implementation pitfalls.

The specific learning topics are:
  • Risk Management Software
  • Sarbanes-Oxley Documentation Solutions
  • Continuous Controls Monitoring
  • Data Analysis
  • Work Collaboration and Management
  • Employee and Control Assessment Tools

Date: December 6, 2012

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

 

Graphing Data in Excel for Auditors Part II December 19

Follow up course to the original session held in 2012.  This course will be more intermediate in nature, delving into more advanced graphing techniques for use by auditors. 

 

 

 

Date: December 19, 2012

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

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.


ABOUT TRUST ONLINE