IDEAScript for Analysts (Three Days)

This three-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.

After completing this training, participants will be able to:

• Automate repetitive tasks such as importing files.
• Create special tests and functions.
• Control and leverage the functionality of other OLE-enabled software such as Microsoft® Excel®.
• Create smart data analytics systems with customizable dialog boxes, tags, and reports.

Course Outline

• Introducing IDEAScript
• Recording a Macro
• Understanding IDEAScript Syntax
• Working with Macro
• Customizing a Macro
• Using the Language Browser
• Functions and Sub-Routines
• Array Handling
• Creating Dialog Boxes
• Creating Your Own IDEAScript Script

Prerequisites

• Working knowledge of IDEA.
• Familiarity with CI101 and CI102 course topics.
• Completion of CI101 and CI102 is recommended.