Training
Quick training courses to help you get a full grasp of all our products and supporting technologies
The purpose of this two-day introductory course is to acquaint new users with the bulk of IDEA’s basic functionality and breadth of tools. Training is immediately hands-on, so participants have the opportunity to quickly interact with the software by completing exercises and case studies using sample data.
After completing this training, participants will be able to:
- Understand the purpose and features of IDEA
- Consider business objectives to which IDEA can be applied
- Determine the data required and import the data.
- Use IDEA in Audit, Finance, and other industries to increase efficiency and effectiveness.
- Improve governance and controls, and reduce risk in their organization.
Course Outline
- Introducing IDEA
- Managing Databases
- Obtaining and Importing Data
- Reconciling and Examining Data
- Isolating Specific Records
- Profiling the Data
- Identifying Irregularities
- Sampling
- Auditing a General Ledger File
- Manipulating and Adding Fields
- Building Equations
- Using Multiple Databases
- Working with Output
- Recap Exercise
- Documentation Standards
- Other Products
- Accessing Resources
Prerequisites
Working knowledge of Microsoft® Windows® desktop environment and Microsoft® Office® applications.
This two-day course is ideal for those who have completed the IDEA Data Analysis Level 1 training or have a sound understanding of IDEA functionality. Participants learn more advanced topics, such as creating complex equations or criteria, automating tasks and Benford’s Law.
After completing this training, participants will be able to:
- Expand their use of data analytics in Audit, Finance, and other industries.
- Apply advanced data analytics techniques and best practices.
- Automate data analytics.
- Improve governance and controls, and reduce risk in their organization.
Course Outline
- Advanced Data Profiling using Benford’s Law
- Advanced Imports
- Advanced Extractions
- Connecting Multiple Databases
- Advanced @Functions
- Custom Functions
- Introduction to Automation in IDEA
- Case Study – Independent Study
- Case Study – Management Report
Prerequisites
Working knowledge of Microsoft® Windows® desktop environment and Microsoft® Office® applications. Familiarity with CI101 course topics. Completion of CI101 is recommended.
Introduction to Programming is a 2-day, hands-on course designed for those who have little to no knowledge of programming, and want to obtain the skills needed to develop complex applications. You will be guided through key programming concepts, including commenting, variables, user input, logic and design, loops, and functions. This training will utilize the IDEAScript Editor to navigate through the fundamentals and provides a brief introduction to the integration of programming and IDEAScript
Course Outline
- Understanding the fundamentals of programming
- Learning the Integrated Development Environment interface
- Adding comments to your applications
- Integrating variables and constants
- Implementing dialog boxes to obtain user input
- Creating and using Functions and subroutines
- Adding conditional and logical structures
- Adding branching structures
- Integrating loops
This two-day course introduces experienced users to the fundamentals of programming and 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:
- Read and understand the logic of IDEAScripts
- Automate repetitive tasks, such as importing files
- Create special tests and functions
Course Outline
- Introducing IDEAScript
- Recording a macro
- Understanding IDEAScript syntax
- Working with macro
- Customizing a macro
- Using the language browser
- Functions and sub-routines
- Case study
Prerequisites
- Working knowledge of IDEA
- Familiarity with CI101 and CI102 course topics
- Completion of CI101 and CI102 is recommended
This two-day course is ideal for those who have completed the IDEA Data Analysis Level 1 training or have a sound understanding of IDEA functionality. Participants learn more advanced topics, such as creating complex equations or criteria, automating tasks and Benford’s Law.
After completing this training, participants will be able to:
- Expand their use of data analytics in Audit, Finance, and other industries.
- Apply advanced data analytics techniques and best practices.
- Automate data analytics.
- Improve governance and controls, and reduce risk in their organization.
Course Outline
- Advanced Data Profiling using Benford’s Law
- Advanced Imports
- Advanced Extractions
- Connecting Multiple Databases
- Advanced @Functions
- Custom Functions
- Introduction to Automation in IDEA
- Case Study – Independent Study
- Case Study – Management Report
Prerequisites
Working knowledge of Microsoft® Windows® desktop environment and Microsoft® Office® applications. Familiarity with CI101 course topics. Completion of CI101 is recommended.
This one-day course was developed to refresh long-time IDEA users and people that took the required training but want to be better prepared to write the Certified IDEA Data Analyst (CIDA) exam. This course was written using the concept of a case study to cover most of the core functionality of IDEA and focus on the content and the style of the CIDA exam.
After completing this training, participants will be able to:
- Use IDEA tasks in the context of their daily work
- Write the CIDA exam
- Apply data analytics in a real-life situation
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 IDEA or completion of CI101 and CI102 training.
The IDEA Data Analysis Workbook contains 3 case studies on Accounts Receivable, Accounts Payable, and Inventory Analysis. Each case study goes through an audit investigation scenario and numerous exercises to perform tests related to that investigation.
This course is designed to help integrate data analytics as a part of any Accounting, Auditing, or Forensics courses and/or workshops and will be available free of charge to any University or College joining our IDEA Academic Partnership. The Workbook online version (PDF) can be made available for students and professors.
This course is suitable for use with the Educational version of IDEA, as all data files contain fewer than 5000 records.
Introduction to IDEA is a half-day workshop that will provide an in-depth overview of the data analysis functionality within the platform, including indexing, summarizing, joining, and filtering. Attendees will import and perform data verification, as well as a basic analysis of a general ledger file. An accounts receivable file will be aged and assessed against an AR credit limit file. IDEA’s navigation, visualization capabilities, and arsenal of online resources will also be covered.
Mastering Problem Imports in IDEA is a half-day workshop that provides experienced IDEA users with advanced knowledge of importing print reports and PDF files into IDEA using the Report Reader, as well as working with difficult Excel and delimited text files. Attendees will practice working with multi-line layers and fields, floating traps, headers, and footers. We will also address the common challenge of transforming complex Excel reports and delimited files into usable data files required to deliver an accurate analysis, and most importantly, greater insights to enable your organization to make quicker and more informed decisions.
Building Complex Equations in IDEA is a half-day course for experienced users who want to expand their knowledge of utilizing IDEA @Functions and embedded equations to solve complex testing procedures. Attendees will learn how to use a range of IDEA @Functions to transform date fields, extract multiple values from a field, cleanse data to enhance testing, pull records containing specific words or phrases, work with multiple conditions without having to nest @if statements, and much more.
Standardizing Data in IDEA is a half-day course for intermediate IDEA users who interact with raw data from range of sources, platforms, and have to blend data to provide an in-depth analysis. We focus on importing pdf files and using @Functions and built in IDEA analytics to validate data. An often understated step in the data analytics process is data preparation and cleansing. Without taking the necessary steps, data will be of limited use in testing and informing critical business decisions. Data validation is the method for checking the accuracy, quality, and completeness of your data, ensuring that test results do in fact provide a true picture and deliver actionable insights.
Analyzing Travel and Entertainment in IDEA is a half-day workshop that will cover the entire process of T&E from start to finish, including how to work with key stakeholders, creating recovery processes, modeling fraud behaviors, and executing testing procedures. Travel and entertainment expenses are a critical focus of proactive fraud audits and it can result in large recoveries and identification of potential losses. From fraud and abuse to clerical errors and loss prevention, this course will take you from novice to expert using IDEA to analyze T&E Expenses.
Analyzing Accounts Payable in IDEA is a half-day workshop that takes learners through their role as an auditor hired to perform an Accounts Payable Audit and Fraud Investigation. The auditor evaluates business and audit risks associated with Accounts Payable and then reviews potential tests that can be used to address those risks. The case study includes a review of using IDEA to import data files, profile payments, extract unusual transactions, using Benford’s Law, join data files and much more. This class uses the Accounts Payable case study from the IDEA Data Analysis Workbook.
Analyzing Accounts Receivable in IDEA is a half-day workshop that takes learners through an Accounts Receivable Audit. The auditor evaluates business and audit risks associated with Accounts Receivable and then reviews potential tests that can be used to address those risks. This training showcases how to utilize IDEA to verify totals, sampling, aging, identifying unusual AR transactions, and recalculating transactions. This class uses the Accounts Receivable case study from the IDEA Data Analysis Workbook.
Analyzing Inventory in IDEA is a half-day workshop that takes learners through an Inventory Review. The auditor evaluates business and audit risks associated with Inventory and then reviews potential tests that can be used to address those risks. This case study includes audit testing to agree total inventory values, check adequacy and accuracy of inventory, assess the re-ordering system, and analyze profit margins and pricing. This class uses the Inventory Analysis case study from the IDEA Data Analysis Workbook.
The Power of Python in IDEA is a half-day workshop that teaches how to combine the power of Python with IDEA. Starting in version 10.3, IDEA has included Python integration to perform custom analysis. This course looks at three methods of Python integration with IDEA: custom functions, converting IDEAScript code, and custom Python programming with the IDEALib.py module. This is not a course on Python, and the course assumes a basic understanding of Python code and how to run a script.
AARO Company Reporting I
Content:
- AARO’s key concepts
- Manual reporting
- Workflows
- Reporting layouts
- Specifications
- Import and stage data to AARO
- Reporting from Excel
- Export reports
AARO Company Reporting II
Content:
- Intercompany reporting
- Intercompany reconciliation
- Intercompany analysis – match report
- Export options of intercompany transactions
- Reconciliation rules and report
- Comment reconciliation violations
- Complete reconciled reports
Target group: The training’s main target audience is company reporters who need to understand the basic concepts in AARO and understand how to use AARO to report their company’s financial statements to the group.
The training is also suitable for group accountants to get the basics of how the reporting tools work in AARO for them to set the reporting closing process for the group.
We recommend this training for users that are familiar with working in the old Windows client and now want a better understanding on how to navigate through the web client.
Company Reporters
Group Reporters
Level: Basic
Prerequisite: None
Suggested next training: AARO Analysis – Reports and Excel
AARO Group Accounting I
Content:
- Group’s closing process
- Consolidation principles in AARO
- Accounting Standards
- Acquisition and Excess value register
AARO Group Accounting II
Content:
- Journals module – Group adjustments
- Match & Elimination set up
- Check Reports for analyzing your closing and legal changes
Target group: You are working with group accounting and know the principles of group consolidation well. You work with group control or the system administration and want to understand the basics of AARO’s group consolidation.
Group Reporters
System Administrators
Prerequisite: Company reporting
Level: Basic
Suggested next training: AARO Legal In-depth
AARO Analysis – Reports and Excel
Content:
- Create, edit and run reports
- Analyse report details
- Additional features in reports
- Comments reports
- Export reports
- Reports and basic analysis in AARO MS Excel Add-in
- Document handling
Target group: This session is intended for you that want to learn about AAROs report and analysis’ features and the different possibilities that are available for analysing your financial statements in MS Excel Add-in. This training is for you who is working with the analysis feature in AARO to build management reports.
We recommend this training for users who are used to working in the old Windows client and now wants a better knowledge of the web client.
Group Reporters
Group Controllers
Management
Company Reporters
Prerequisite: None
Level: Basic
Suggested next training: AARO Analysis – Dashboard and Charts
AARO Analysis – Dashboard and Charts
Content:
- Create and Edit Dashboards
- Add dashboard gadgets
- Agenda & Workflows
- News, Text and Favourites
- Report and selection gadget
- Sharing dashboards
- Create Charts reports
- Chart types and settings
- Charts in Dashboard
Target group: This session is intended for you that want to learn or refresh your previous knowledge of AARO’s dashboard and chart reports.
Group Reporters
Group Controllers
Management
Prerequisite: AARO Analysis – Reports and Excel
Level: Basic
Suggested next training: AARO System Administration – Workflows and Reconciliation
AARO System Administration – Closing Administration
Content:
- Chart of accounts
- Creating and editing accounts
- Dimensions and groups for the operational organization
- Input reporting forms and packages
- Period administration
Target group: This training is for you who needs to set up in AARO; the chart of accounts, reporting packages, organization structure and administration of periods. The training is good for you who is new as a system administrator in AARO or need to update your knowledge.
CFO’s
System Administrators
Prerequisite: Company reporting
Level: Basic
Suggested next training: AARO System Administration – Reporting and User Restrictions
AARO System Administration – Reporting and User Restrictions
Content:
- Validations – restrict reporting on valid entities
- User administration – Restrict access to system features and menus
- User administration – set read and write access
- User administration – set access to reporting packages
- Responsibility groups for reporting
- User groups administration – set user restrictions to the dashboard
Target group: If you are working in group accounting or as system administrator, this training will give you the tools for setting up users and subsidiaries with access to the right functionalities.
Group Reporters
System Administrators
Prerequisite: AARO Company Reporting, AARO System Administration – Closing administration
Level: Basic
AARO System Administration – Workflows and Reconciliation
Content:
- Dashboard administration
- Workflow setup
- User groups
- Reconciliation rules
- Reconciliation violations and comment override
- Completing Packages
Target group: This training is suitable for an administrator or developer of the closing routines and personnel responsible for analysis during the closing process. By the end of the training, you will be able to define activities and workflows for different user groups during the closing process.
Group Reporters
System Administrators
Prerequisite: AARO Company reporting, AARO Analysis – Dashboard and Charts, AARO System administration – Closing administration
Level: Basic
AARO Legal In-depth
- The course is structured in 4 different modules/parts. Our recommendation is to participate in the modules in the order given.
- If this is not possible, then it’s a must to take the first two modules (Acquisitions and Divestment) before taking the last 2 (Mergers and Acquisition of Groups).
- We have discounted rates when taking all 4 modules at a go. Check cost at the bottom of the page.
The 4 modules are:
- Acquisition of subsidiaries and Step Acquisitions (4 hours)
- Divestment (4 hours)
- Mergers (4 hours)
- Acquisition of Groups and impairment of shares (4 hours)
Target group: The training is relevant for you that have deep knowledge about the principles of group accounting and have at least 6 months experience of working with AARO.
Group Reporters
Prerequisite: AARO Group Accounting, 6 months experience of using AARO.
Level: Advanced
AARO Lease IFRS 16
Content:
- How to register lease contracts in AARO Lease IFRS 16, including description of the fields in Lease registration form.
- How to run reports in AARO to follow up on lease information and analyze the numbers.
- Presentation of reports/charts on Dashboard in AARO.
For system administrators/superusers on customer side, also:
- Basic AARO functionality; create companies, dimensions and periods that are needed for Lease contract registration.
Target group: The course is aimed at those who will work actively with registration and management of contracts. We also review the reporting tool for monitoring the effects of IFRS 16.
Company Reporters
Group Reporters
Prerequisite: None
Level: Basic
We offer Delta training on customers’ request. In our delta training, we go through the new functionalities in the latest version of AARO (AARO23). The new functionalities in this Delta training include:
- Integration with services in AARO
- ALR period copy option
- Revert All
- Remove all items button in parameter
- Exclude dimensions in workflows
- Discontinued or phased out legacy functionality
- Historic values account
- Opening rates setup automated
- Import admin improved
- Divest button
Target group: This training is suitable for existing AARO users that wants to learn about new features in our recent versions in order to plan your future progress and development of your AARO installation.
Group Reporters