Gordon Industrial Building

Singapore 409838

+65 6344 6657

bwsadmin@bwsolutions.com.sg

IDEAScript for Analysts

We Are Ready To Help Here.

Send us an email and we’ll get in touch shortly, or call us at +65 6344 6657
CONTACT US

SHARE AND AUTOMATE WORKFLOWS.

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.
Cancellation Policy
  • BusinessWare Solutions Pte. Ltd. requires notice of cancellation no later than 10 business days before the training start date.
  • There is no charge for course substitutions.
  • BusinessWare Solutions Pte. Ltd. retains the right to cancel training courses when the minimum number of participants has not been reached.
  • Full refunds will be made should such cancellation be required.

We Are Ready To Help Here.

Send us an email and we’ll get in touch shortly, or call us at +65 6344 6657
CONTACT US

+65 6344 6657 Contact us for your business requirements today.

Contact Us