Essayer IDEA

Formation en classe dans votre région

Analyzing Accounts Receivable in IDEA

Level 2

Live, Online
Avr 8, 2021 10:00

Analyzing Accounts Receivable in IDEA is a half-day, instructor-led course that walks students through a case study where they were hired to perform an Accounts Receivable Audit at Bright IDEAs, Inc. The auditor evaluates business and audit risks associated with Accounts Payable 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. We will also use a portion of the IDEA Data Analysis Workbook for your reference.

 

Learning Objectives:

  • Import MS Access and print reports into IDEA
  • Use Field Stats and Control Totals to reconcile and Validate data
  • Create new fields to identify and extract unusual AR transactions
  • AR Aging
  • Add comment fields
  • Create random samples
  • Analyze credit notes, account balances, and unauthorized accounts
  • Recalculate transactions

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 8, 2021 - Avr 8, 2021
10:00 - 2:00

$300 USD

Introduction to Programming for Data Analysts

Level 1

Live, Online
Avr 12, 2021 8:30

Introduction to Programming is a 2-day, virtual and 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. You will join a live, instructorled virtual desktop environment to individually test your knowledge, and ask questions. This training will utilize the IDEAScript Editor to navigate through the fundamentals and
provides a brief introduction to the integration of programming and IDEAScript.

 

Learning Objectives:

  • Understand Variables and Constants and how to use them effectively
  • Create basic dialog boxes to request and accept information from the user
  • Create, modify, and reuse functions
  • Use conditions and logical statements
  • Introduction to branching and loops

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 12, 2021 - Avr 13, 2021
8:30 - 4:30
Central US

$850 USD

Intro to IDEA

Level 1

Live, Online
Avr 14, 2021 10:00

Introduction to IDEA® is a half-day, hands-on workshop that will provide an in-depth overview of the data analysis functionality within the platform, including indexing, summarizing, joining, and filtering. Attendees will first import and perform data verification, as well as a basic analysis of a general ledger file. Then 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 to ensure your individual success following this course.
We encourage you to complete the “Getting Started with IDEA” webinar prior to attending this course, as you will need to be familiar with IDEA’s basic features and functions.

Learning Objectives:

 

  • Create and set up projects
  • Navigate the IDEA File Explorer and Library
  • Import Excel files with multiple sheets
  • Use field statistics to verify and reconcile data
  • Summarize and Joining Databases
  • Filter data and creating extractions
  • Create new fields and basic equations
  • Age and Gap Detection
  • Simple duplicate detection and exclusion
  • Utilize Discover for data visualization
  • File documentation and history using Project Overview
  • Resources available to IDEA customers

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 14, 2021 - Avr 14, 2021
10:00 - 2:00
Central US

$300 USD

IDEA Data Analysis

Level 1

LIVE, Online
Avr 14, 2021 11:00

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. Topics include manipulating and adding fields, building equations, importing data, using multiple databases, reconciling data, isolating specific records, identifying irregularities, sampling, and more.

Additional Notes:

You will be working within a virtual computer lab; you do not need IDEA installed in order to attend.
The use of two monitor screens is strongly recommended during your training course.
This is a live, instructor-led course, and attendance is required throughout the session.
Your trainer will send your login information one week prior to the course.

Cancellation Policy

CaseWare IDEA Inc. requires notice of cancellation no later than 10 business days before the training start date. If less than 10 business days’ notice is given, 50% of the training fee will be refunded up to three business days before the training start date. No refund is possible if notice of cancellation is received less than three business days before the training start date.

Please contact ideatraining@caseware.com with any questions.

S'inscrire

English

Avr 14, 2021 - Avr 15, 2021
11:00 - 7:00
Eastern US

$1150 CAD

Analyzing Inventory in IDEA

Level 2

Live, Online
Avr 15, 2021 10:00

Analyzing Inventory in IDEA is a half-day, instructor-led that walks students through a case study where they are hired to perform an Inventory Review at Bright IDEAs, Inc. 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. We will also utilize a portion of the IDEA Data Analysis Workbook for your reference.

 

Learning Objectives:

  • Import ASCII delimited files using field statistics and control totals to verify accuracy of import
  • Use equations to extract obsolete inventory items and negative quantities
  • Calculate usage ratios and months of inventory
  • Stratify inventory into bands
  • Calculate total provisions counts and value by location
  • Test accuracy of the reordering system
  • Analyze selling prices and inventory movements
  • Analyze profit margins

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 15, 2021 - Avr 15, 2021
10:00 - 2:00
Central US

$300 USD

IDEA Data Analysis

Level 2

LIVE, Online
Avr 26, 2021 9:00

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 connecting databases. Topics include advanced imports, data profiling with Benford’s Law, advanced extractions, connecting multiple databases, advanced @functions, custom functions, and introduction to automation in IDEA.

Additional Notes:

You will be working within a virtual computer lab; you do not need IDEA installed in order to attend.
The use of two monitor screens is strongly recommended during your training course.
This is a live, instructor-led course, and attendance is required throughout the session.
Your trainer will send your login information one week prior to the course.

Cancellation Policy

CaseWare IDEA Inc. requires notice of cancellation no later than 10 business days before the training start date. If less than 10 business days’ notice is given, 50% of the training fee will be refunded up to three business days before the training start date. No refund is possible if notice of cancellation is received less than three business days before the training start date.

Please contact ideatraining@caseware.com with any questions.

S'inscrire

English

Avr 26, 2021 - Avr 27, 2021
9:00 - 5:00
Eastern US

$1150 CAD

IDEAScript for Data Analysts Level 1

Level 1

Live, Online
Avr 26, 2021 8:30

The IDEAScript for Data Analysis – Level 1 is a hands-on, advanced two-day course that guides you through the integration of your programming knowledge and the IDEAScript syntax. It is
recommended that you are both competent in IDEA® and fundamental programming. You will gain knowledge on how to create a new script that integrates IDEA’s function,
walk through the objects needed to make IDEA perform joins, summarizations, and any other task that you may require. You will also develop skills on how to make IDEA create the code and
modifications/customizations that require your scripts to be more user oriented, and also view many relevant real-world case studies. This course is instructor-led with a virtual
desktop to provide you with skills needed to create powerful IDEAScript applications and integrations. The IDEAScript Editor is also utilized to create applications and make the script run
automatically using Windows Task Scheduler.

 

  • Introduction to IDEAScript
  • IDEAScript Environment
  • Introduction to IDEA objects
  • Create scripts by Recording macros, using History and Project Overview
  • Script modification and clean-up
  • Utilize IDEA commands
  • Read database information
  • Modify IDEAScript for user interaction

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 26, 2021 - Avr 27, 2021
8:30 - 4:30
Central US

$850 USD

IDEA Data Analysis

Level 1

Live, Online
Avr 27, 2021 8:30

IDEA® Data Analysis Level 1 is a hands-on, two-day, comprehensive introductory course that will acquaint new users with the IDEA platform’s functionality and wide range of tools to simplify your daily workflow and deliver greater insights. Participants will have the opportunity to interact with the software through a range exercises using sample data and will receive personalized support from the instructor – promoting improved competency of the content.
Topics include, but are not limited to adding and manipulating fields, building equations, importing data, using multiple databases, reconciling data, identifying irregularities, isolating specific records, and sampling. Relevant real-world case studies will also be shared.

 

Learning Objectives:

  • Understand the basic features and functionality of the IDEA platform
  • Determine what data is required, and how to obtain and import various types
  • Effectively manage and use multiple databases (append & join databases)
  • Reconcile and examine data to search for outliers and potential fraud
  • Isolate specific records for investigation
  • Profile data using stratification and summarization
  • Identify irregularities including Duplicate Key and Gap Detection
  • Apply commonly used sampling techniques: systematic, random, and stratified random
  • Build equations to add virtual fields, filter, sort and match data, automate repeatable processes

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 27, 2021 - Avr 28, 2021
8:30 - 4:30
Central US

$850 USD

Intro to IDEA

Level 1

Live, Online
Avr 28, 2021 10:00

Introduction to IDEA® is a half-day, hands-on workshop that will provide an in-depth overview of the data analysis functionality within the platform, including indexing, summarizing, joining, and filtering. Attendees will first import and perform data verification, as well as a basic analysis of a general ledger file. Then 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 to ensure your individual success following this course.
We encourage you to complete the “Getting Started with IDEA” webinar prior to attending this course, as you will need to be familiar with IDEA’s basic features and functions.

Learning Objectives:

 

  • Create and set up projects
  • Navigate the IDEA File Explorer and Library
  • Import Excel files with multiple sheets
  • Use field statistics to verify and reconcile data
  • Summarize and Joining Databases
  • Filter data and creating extractions
  • Create new fields and basic equations
  • Age and Gap Detection
  • Simple duplicate detection and exclusion
  • Utilize Discover for data visualization
  • File documentation and history using Project Overview
  • Resources available to IDEA customers

 

Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply.
Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

S'inscrire

English

Avr 28, 2021 - Avr 28, 2021
10:00 - 2:00
Central US

$300 USD

Detecting Fraud in Payroll & Human Resources - April 30 - Online

Level 1

Live, Online
Avr 30, 2021 8:30

Payroll and Human Resources are heavy with policies, procedures, and tight controls in most companies due to their responsibility over substantial cash outflow. How, then, does a global airline suffer a $35 million payroll fraud? How does an administrative assistant receive $1.4 million in overtime not worked over 17 years? How do 700 clients of a payroll processing company lose their payroll funds for an entire pay cycle? How does a global investment bank end up in a foreign corrupt practices investigation from their hiring tendencies?

This hands-on session offers the tools necessary to detect such problems early. Building off of our Detecting Fraud Using Data Analysis course; we dive deeper into a specific process and add to our repertoire of data analysis techniques. Through hands-on exercises and case studies, you will reinforce your learning, and see fraud as we encounter it in the field.

 

  • Understand Our Role in Fraud Detection:
    • Mindsets that keep people from detecting fraud
    • A five-step approach to fraud detection
  • Recognize What Can Go Wrong in Payroll & Human Resources:
    • How to detect ghosts on the payroll, incentive-drive frauds, theft in time reporting, false recruiting, embezzlement of payroll funds, corrupt hiring practices, and the newer phishing scams targeting Human Resources
    • How to work with HR to create an environment hostile towards fraud
  • Apply Data Analysis Techniques to Case Studies:
    • Building logical extractions to target symptoms of problems; identifying curious patterns; practical analyses for detecting violations of statistical laws
    • Payroll and HR fraud cases worth knowing, how to analyze them, and how to build an effective ‘pre-mortem’ testing plan to avoid the same problems

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply. Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

S'inscrire

English

Avr 30, 2021 - Avr 30, 2021
8:30 - 4:30
Central US

Fill out the following form to register for the course.

  • Please enter your full address including city and country.
  • Ce champ n’est utilisé qu’à des fins de validation et devrait rester inchangé.