The Bookstore: Spreadsheet & Database-Related Tools
Mr. Excel
Save 12% on Mr. Excel products (enter the discount code “audit” without the quotes to receive the discount)
Mr. Excel provides a host of Excel publications and training products for beginners to advanced users. Titles such as “Guerilla Data Analysis in Excel” and “Pivot Table Data Crunching” help to expand any users knowledge in Microsoft Excel.
ActiveData for Excel
ActiveData for Excel adds over 100 features to Microsoft Excel TM for accountants, auditors, and fraud-detection specialists. The time savings and efficiencies gained means the software pays for itself in two or three uses. You never have to learn a new environment or leave the one you're comfortable in. The powerful analysis features such as group summaries, gap and duplicate detection, stratification, and digital analysis (Benford's Law) were previously only available in tools such as ACL and Caseware IDEA that cost thousands of dollars more.
ActiveData for Office
ActiveData For Office TM is a stand-alone application enabling you to easily analyze your data beyond the 65,536 row limit of ExcelTM. It provides new levels of control over your information while allowing you the flexibility to view your results within ActiveData For Office itself or within your familiar Microsoft OfficeTM environment. It offers enhanced functionality through it's tight integration with MS Access, Word, Excel, Internet Explorer and many other popular business applications.
Fraud Detection and Cash Recovery Using ActiveData for Excel
This eight-hour CPE self-study course assists auditors, fraud examiners, and management in implementing data analysis routines using ActiveData for Microsoft Excel . A grasp of this new material brings greater proficiency in using audit software to detect and prevent organizational inefficiency, ineffectiveness, and fraud. It walks through 16 common fraud detection, cash recovery, and audit tests within the accounts payable, accounts receivable, and general ledger audit areas.
This course will:
Introduce you to the powerful combination of ActiveData and Excel
Walk you through basic fraud detection and cash recovery reporting concepts
Map out each step for the most common of fraud detection, cash recovery and audit tests
Equip you with sample data, providing a glimpse of the resulting report prior to the (crunch time) situation
Suggest fraud detection and audit procedures to perform on the resulting reports
Fraud Detection and Cash Recovery Using ActiveData for Office
This eight-hour CPE self-study course assists auditors, fraud examiners, and management in implementing data analysis routines using ActiveData for Microsoft Office. A grasp of this new material brings greater proficiency in using audit software to detect and prevent organizational inefficiency, ineffectiveness, and fraud. It walks through 16 common fraud detection, cash recovery, and audit tests within the accounts payable, accounts receivable, and general ledger audit areas.
This course will:
Introduce you to the powerful combination of ActiveData and Office
Walk you through basic fraud detection and cash recovery reporting concepts
Map out each step for the most common of fraud detection, cash recovery and audit tests
Equip you with sample data, providing a glimpse of the resulting report prior to the (crunch time) situation
Suggest fraud detection and audit procedures to perform on the resulting reports
Top Audit Tests Using ActiveData for Excel
Want to get up and running FAST with ActiveData for Excel ? Need to get measurable results for your organization and get the most from your ActiveData for Excel investment? Want to learn how to practically apply ActiveData for Excel to top audit areas with minimal learning curve? Then take a look at the Top Audit Tests Using ActiveData for Excel user manual that walks you, step-by-step through popular audit tests in the most popular audit areas:
Accounts Payable,
Accounts Receivable
General Ledger
This is an e-book that integrates directly into the ActiveData for Excel help menu. Not only that but the guide provides sample data to test your skills prior to using "live" company data.
Using Microsoft Access to Audit Payables for Fraud
Accounts payable has always been a target of choice for employee fraud. This course gives you a clear understanding of the concepts used to audit payables for fraud with Microsoft Access® and why certain tests are more effective than others. In this eight-credit-hour CPE course you'll learn:
Basic features of Microsoft Access
Types of audit software
Proactive detection of fraud using audit and other planning tools
Four steps needed to request data from a client
How to modify tests for different situations and needs
How identify where vendor payments are going
How to summarize debit memos.
To learn more, watch the sample video (requires Macromedia Flash Player).
