IDEAScript for Analysis (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
Importing and Reconciling Project Data
Profiling and Isolating Payment Data
Identifying Irregularities and Using Field Manipulation
Summarizing Data and Working with Multiple Files
Prerequisites
Working knowledge of Microsoft® Windows® desktop environment Microsoft® Office® applications.
Familiarity with CI101 course topics.
Completion of CI101 is recommended.
Contact us for details information about Trainingor
