Covers topics including Advanced PivotTables, External data ranges (ODBC), and Visual basic: macros and user-defined functions.
Learning Objectives
- Learning Outcomes
- Identify the professional standards that apply to forensic accounting engagements, including what they offer and whether they impose restrictions
- Determine how professional standards relate to other requirements in forensic services (e.g., court requirements and case law)
- List the various forms of non-authoritative guidance from the AICPA that pertains to forensic accounting engagements, including what they offer and whether they impose restrictions
- Discuss examples of situations in which forensic accountants must follow standards and guidance depending on the types of services they are providing
Major Topics
Advanced PivotTables;External data ranges (ODBC);Visual basic: macros and user-defined functions;Digital workpapers;Securing worksheets and workbooks;Named ranges;VLOOKUP and related functions, Nest Offset, Text, Match;"IF" function and other efficiency gains;Encryption and data validation
