This two-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. Topics include recording a macro, IDEAScript environment, IDEAScript syntax, customizing macros, using the Language Browser, functions and subroutines, and more.
| Course Level |
Advanced |
| Length |
Two days (16 CPE) |
| Delivery Method |
Group Internet-Based |
| Event Time |
8:30 AM - 4:30 PM Central |
| Prerequisites |
Working knowledge of IDEA. Familiarity with CI101 and CI102 course topics. Completion of CI101 and CI102 is recommended. |
- Courses led by certified IDEA instructors
- Earn up to 16 hours of NASBA CPE (8 hours per day)
- Course materials provide comprehensive, step-by-step instruction for reference including IDEA screenshots, tips and exercises to keep your skills sharp
- Public training courses help you work towards CaseWare Analytics IDEA Certifications
- Gain skills and confidence scripting data analytics to conduct more efficient and effective audits
- Network with fellow IDEA users to share best practices and grow your professional network
- Information about resources and additional products designed to save time and effort
After completing this training, participants will be able to:
- Create scripts using IDEA’s History, Project Overview and Recording functions
- Understand IDEAScript Syntax
- Work with variables, objects, and constants
- Customize scripts using message boxes
- Use the IDEA Language Browser
- Create Conditional Structures (If...Then...Else)
- Create Repeating and Looping structures (Do...Loop Until \ While)(For...Next)
- Use Functions and Subroutines to organize scripts
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
