Excel and Valid8: Enhanced Forensic Accounting and Financial Tracing

Learning Objectives

• To analyze the different potential flaws of data ingress that can undermine your Excel analysis.
• To discuss how to work with transfers between accounts so the money flows are readily identifiable.
• To explain best practice analytics within Excel, such as Trending Reports and Stratification.

Course Description

Forensic accounting utilizes accounting, auditing, and investigative skills to examine the finances of an individual or business. It provides an accounting analysis suitable to be used in legal proceedings. Forensic accountants are trained to look beyond the numbers and deal with the business reality of a situation.

In this CPE webinar, co-founders of Valid8 Chris McCall and Tod McDonald will introduce Excel best practices to accelerate the forensic analysis of financial evidence.

The audience of this CPE course on accounting will learn how to build upon their existing Excel skills and solve for the quality, speed, and cost of preparing evidentiary financial data for an investigation.

Chris and Tod in this CPE course will use examples from real-world case studies of Valid8 to illustrate how professionals can enhance their work in Excel to gain insights that are backed by evidence.

This online CPE webinar is designed for professionals who:

• Need to understand how money has moved by reviewing financial transactions from evidence.
  
• Have a solid grounding in Excel.
• Would like to gain efficiencies with reviewing large sets of transactions.

Overview

• Document extraction best practice

  03 mins
• Prove accuracy and completeness

  07 mins
• Find transfers

  18 mins
• Automated analytics

  26 mins
• Improving the layout as per requirements in Excel tables

  33 mins
• Speeding up the creation of Pivot Tables

  38 mins
• Questions and queries

  40 mins