IDEA Script Course

SHARE AND AUTOMATE WORKFLOWS.

IDEAScript for Analysts / 75%

IDEAScript for Analysts (3 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

100%
Working Knowledge IDEA
90%
Completion IDEA Level 1
70%
Completion IDEA Level 2