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
Prerequisites
Working Knowledge IDEA
Completion IDEA Level 1
Completion IDEA Level 2
Contact us for details information about Training
Solutions
Internal Audit Risk Management IT Assurance & Governance Independent Review and Vulnerability AssessmentProducts IDEA Data Analysis Software Alessa - Continuous Control Monitoring Pentana Audit - Audit & Control Management Pentana Risk - Performance & Risk Mngmnt Smart Exporter - SAP Data Extraction Tool Smart Analyzer - Financial Apps for IDEA
Services Internal Audit Service Risk Management Service IDEA Professional Service IT Audit Service IT Advisory Service Independent Review and Vulnerability Assessment Business Continuity Management
PT. Insight Consulting
Sona Topas Tower, Level 16
Jl Jend. Sudirman Kav. 26
Jakarta 12920, Indonesia.
