IDEA Data Analysis Level 1


IDEA Data Analysis Level 2


IDEA Scripts for Analysts


IDEA Data Analysis CIDA Exam Preparation

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


Working Knowledge IDEA

Completion IDEA Level 1

Completion IDEA Level 2

Contact us for details information about Training