IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.


Training & Events

This event has passed
Event Image

Building Complex Equations

SKU: ws-190822 Category: Tag:
August 22nd | 1:00 PM - 4:00 PM CDT | Live Online
Live Online | Central Time   View map


5 in stock


This event has passed

3 Has Sold

This 3-hour course will teach the practice of using IDEA @functions and embedded equations to solve complex testing procedures.
  • Build nested @functions
  • Work with dates
  • Extract multiple values from a column of information
  • Cleanse data to enhance your testing
  • Pull records containing specific words or phrases contained anywhere in a field
  • Use with multiple conditions without having to nest @if statements
Course LevelIntermediate
Length3 Hours (3.4 CPE)
CPE CategoryAuditing
Delivery MethodGroup Internet-Based
Event Time1:00 PM - 4:00 PM CDT
PrerequisitesWorking 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.

Mario Perez, CIDA

Sr. Analytics Consultant
Mario brings more than 12 years of experience as an advanced-level IDEA user to his role at Audimation where he provides training, instructional videos, and technical support and consulting services. Mario was introduced to IDEA as an audit associate at BDO New York. He has traveled the world sharing his enthusiasm for data analytics including working as the IDEA distributor in Scandinavia as well as training and consulting engagements in Saint Vincent and the Grenadines and The Bahamas.
NASBA CPE LogoAudimation 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:
CPAs may contact us by email at [email protected] to receive promotional materials containing details on the required elements of the National Registry of CPE Sponsors.

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