This one day course introduces experienced users to more advanced topics devoted to workflow automation with IDEAScript macros. IDEAScript, the IDEA programming language behind IDEAScript macros, is similar to and compatible with Visual Basic for Applications, the macro language used in Excel®, PowerPoint®, Word®, Access®, and other Microsoft Office® applications.
One day (8 CPE)
8:30 AM - 4:30 PM
Working knowledge of IDEA. Familiarity with CI101 and CI102 course topics. Completion of CI104 is recommended.
Jennifer L. Ellison, CFE
Consulting Services Manager
Jennifer has nearly two decades of experience in IT audit, forensic audit, and ethics and compliance for Fortune 200 energy services companies across 20 countries. In 2018, Jennifer joined Audimation Services as an Audit Analytics Consultant to help clients implement and apply CaseWare IDEA® to extend their auditing and fraud detection capabilities. As an IDEA Power User since 2001 — primarily using IDEA in fraud investigation and anti-corruption audits — Jennifer takes her online and on-site training and consulting to the next level by sharing specific, real world examples of IDEA applications and providing knowledge and support for Professional Services. Also an experienced SAP user, she helps clients download and analyze SAP information. Jennifer is a graduate of Ambassador University and is a Certified Fraud Examiner (CFE) as well as a Certified Information Systems Audit (CISA) – non-practicing.
Recording a Macro
Understanding IDEAScript Syntax
Working with a Macro
Customizing a Macro
Using the Language Browser
Functions and Sub-Routines
Creating Dialog Boxes
Creating your own IDEAScript
After completing this training, participants will be able to:
Create custom dialog boxes and validate user input for correctness
Create scripts robust to usage by many people within the organization
Utilize arrays in IDEAScript
Audimation Services, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of the 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: nasbaregistry.org
CPAs may contact us by email at [email protected] to receive promotional materials containing details on the required elements of the National Registry of CPE Sponsors.