Audimation Services has been acquired by Caseware International Learn More.


Training & Events

This event has passed
Event Image

AS205: Building Complex Equations

SKU: ws-buildingcomplexequations-1 Category: Tag:
May 12, 2022 | 10:00 AM - 02:00 PM CST | Live Online | 4 CPE
Live Online | 10:00 AM Central   View map


6 in stock


This event has passed

2 Has Sold

This 4 CPE course will teach the practice of using IDEA @functions and embedded equations to solve complex testing procedures.
**Please note participants are required to be actively engaged in the class and complete coursework to qualify for CPE credit.**
Course Level Intermediate
Length 4 CPE
Field of Study Auditing
Delivery Method Group Internet-Based
Prerequisites Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications. IDEA Data Analysis Level 1 and one year of consistent use of IDEA including importing, adding fields, extracting data, and summarizing data. No advance preparation is required.
After completing this training, participants will be able to:
  • Apply @functions to properly convert date information from character type
  • Differentiate between Boolean data type values when building equations
  • Apply @functions to extract quarterly information from a date field
  • Apply @functions function to filter information from a database
  • Identify and apply @functions that can be used to cleanse and normalize data
  • Select and apply @functions that can parse and filter specific date components in a date field
  • Identify and apply IDEA @functions that are used to perform field searches
  • Recognize the proper syntax for applying @functions for searching within a field
  • Recognize the @functions used in parsing data within character fields
  • Identify and apply @functions that can be used to find information through pattern matching
  • Identify and apply the proper syntax for building equations to match a pattern within a field
Audimation Services, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of the continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: For concerns regarding course offerings, certifications or complaints, please contact: Sarah Davies, Training Services Administrator [email protected] 832-327-1890

This website has been designed for modern browsers. Please update. Update my browser now