Limited Period Access to myCPE Prime Unlimited CPE Access starting at $199. Subscribe Now

Excel and Valid8: Enhanced Forensic Accounting and Financial Tracing

  • Accountant
  • CPA (CA)
  • CPA/CFF
  • CFE
  • CIA
  • CMA
  • CPA (US)
  • CVA
  • CA - ICAEW
  • IAP
  • QIAL
  • MRTP
  • ACCA
  • MAFF
  • CBA/MCBA
  • CA - Ireland
  • CA - Scotland
  • CPA - Ireland
  • CFIRS
  • CWS

Published: January, 2022

You need to register for the webinar to watch the video.

Click Here to Register

Before starting this self study program, please go through the instructional document.

  • Course Description
  • Course Qualification
  • Presenter
  • FAQ

Course Description

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

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.

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.

Recommended For

  • This CPE course is recommended for CPAs, CFEs, CFFs, IAPs, QIALs, Internal as well as external auditors, Bankruptcy, Restructuring, and other professionals who need to understand how money has moved from evidentiary records.
  • This CPE webinar is recommended for accountants, auditors, and other professionals who desire to learn Best Excel Practices for Forensic Accounting and Financial Tracing.

Who Should Attend?

  • Accountant
  • Accounting and audit managers/practitioners
  • Accounting Managers
  • Accounts Director
  • Auditors
  • Chartered Professional Accountant
  • Chief Accounting Officer
  • Director of Accounting
  • Entrepreneurial Accountant
  • Forensic Accountant
  • Forensic Auditor
  • Fraud & Forensic Auditor
  • Fraud Analyst
  • Fraud Detection Specialist
  • Fraud Examiner
  • Fraud Investigator
  • Fraud Professionals

Course Qualification

Webinar Qualifies For

  • 1 CPE Credit of Accounting for Certified Public Accountants (CPA-US)
  • 1 CPD Credit of Financial Reporting for Certified Financial Forensics (CFF)
  • 1 CPE Credit of Fraud Auditing and Forensic Accounting for Certified Fraud Examiner (CFE)
  • 1 CPE Credit of Forensic auditing for Certified Internal Auditors (CIA)
  • 1 CPE Credit of Accounting & Auditing for Certified Management Accountants (CMA)
  • 1 CPE Credit of Financial accounting for Certified Valuation Analyst (CVA)
  • 1 CPE Credit of Accounting for Internal Audit Practitioner (IAP)
  • 1 CPD Credit of Accounting for Chartered Professional Accountant (CPA Canada)
  • 1 CPE Credit of Financial accounting for Certified Business Appraiser/Master Certified Business Appraiser (CBA/MCBA)
  • 1 CE Credit for Certified Fiduciary & Investment Risk Specialist (CFIRS)
  • 1 CE Credit for Certified Wealth Strategist (CWS)
  • 1 General Credit of Accounting for Accountant/Bookkeeper/Tax Professionals
  • 1 CPD Credit for Chartered Accountants - Ireland (CAI)
  • 1 CPD Credit for CPA - Ireland
  • 1 CPD Credit for Chartered Accountants - Scotland
  • 1 CPD Credit for CA - ICAEW
  • 1 CPD Credit for Chartered Certified Accountants (ACCA)
  • 1 CPE Credit of Accounting for Qualification in Internal Audit Leadership (QIAL)
  • 1 CE Credit of Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01274-22-O)

Additional details

  • Course Level :
    Basic
  • Credits :
    1
  • Instructional Method :
    QAS Self Study
  • Pre-requisites :
    None
  • Advance Preparation :
    None

IRS APPROVED

MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478

MY-CPE LLC (Sponsor Id#: GEHNZ) has entered into an agreement with the Internal Revenue Service, to meet the requirements of 31 Code of Federal Regulations, section 10.6(g), covering maintenance of attendance records, retention of program outlines, qualifications of instructors, and length of class hours. This agreement does not constitute an endorsement by the IRS as to the quality of the program or its contribution to the professional competence of the enrolled individual. Credit earned by attendees with a PTIN will be reported directly to the IRS as required of all providers. To ensure your CPE hours are reported, update your profile in My Account to include your PTIN number. Please note: IRS CE is only mandatory for EAs and ERPAs. For all other tax return preparers, CE is voluntary.

NASBA APPROVED

MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478

MY-CPE LLC (Sponsor Id#: 143597) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of 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: www.NASBARegistry.org.

Presenter

About Presenter

Chris McCall

Co-Founder & CEO, Valid8

As CEO and founder, Chris leads VALID8’s vision, strategy, and execution. Prior to founding VALID8, Chris led marketing as Chief Marketing Officer for NexGen Storage where he built a world class marketing team around strategic market analysis and product management.

Chris started his career as an Electrical Engineer designing systems for Boeing 747’s. Identifying the need to modernize the engineering design data infrastructure, he revamped how system design software could leverage large datasets more effectively. Passionate about extracting value from big data systems, Chris took on several product roles with start-ups acquired by F500 companies HP and SanDisk.

About Company

World class financial investigations need to be fast, accurate, and comprehensive. Valid8 extracts and reconciles banking transactions from any PDF statement file in less than 24 hours. Transfers between accounts and legal entities are identified to compress data preparation time and simplify asset discovery and finding fraudulent transfers.

Faq

FAQs content

  • To receive Continuing Education credit for the event, you must register for the webcast prior to the start of each program.
  • Continuing Education Credit Certificate is available to all eligible participants within 24 hours of each webinar.
  • You must attend complete live webinar and respond to all polling questions asked during the webinar. Credits would be issued on 50 minute credit hour basis.
  • Polling feature Not supported: If you are logging in through browser or web portal in the browser (zoom.us) it doesn’t support the polling feature. Please be advised the current polling feature can only be supported via Zoom desktop and mobile app. You can check the same here : https://support.zoom.us/hc/en-us/articles/203749865-Polling-for-webinars
  • This event may be a recorded rebroadcast of a live event done in past and the instructor will be available to answer your questions during/after the webinar.
  • If you still face the polling problem please don’t panic and provide your response in the chat and we shall consider the same for processing for credits. You can download Zoom by clicking on the mentioned link : https://zoom.us/download
  • Our courses meet the global Continuing Professional Development (CPD-IES7) Standard for Chartered Accountants with International Education Standard 7 (IES 7) set by The International Federation of Accountants (IFAC), the International Accounting Education Standards Board (IAESB) and the Association of Chartered Certified Accountants (ACCA). Based on our accreditation by existing IFAC members and affiliates, we believe learners can count their professionally relevant, verifiable learning activities on myCPE, including taking on demand courses and attending live webinars, toward fulfillment of their verifiable CPD-IES7 requirements. However, if there is any question, we recommend that the individual learner confirm with his/her professional licensing organization before taking myCPE courses for CPD-IES7 credit.
  • You can manage your continuing education certificates and credits through your certificate dashboard which is available when you are logged in to your account (LOGIN)
  • As an accredited provider of Continuing Professional Education in the United States, myCPE online learning platform, courses, and webinars meet the requirements set forth by the Institute of Management Accountants (IMA), an IFAC Member Organization, as well as the National State Boards of Accountancy (NASBA) and the Institute of Internal Auditors (IIA), both IFAC Affiliates. As well as it has been approved by NASBA, Internal Revenue Service (IRS), Certified Financial Planner Board (CFP Board), California Tax Education Council (CTEC), Society of Human Resource Professional (SHRM), Human Resource Certification Institute (HRCI) and many more.Therefore, we believe learners can count their professionally relevant, verifiable learning activities on myCPE, including taking on demand courses and attending live webinars, toward fulfillment of their verifiable continuing education requirement as CPD-IES7 requirements. However, if there is any question, we recommend that the individual learner confirm with his/her professional licensing organization before taking myCPE courses for CPD-IES7 credit.
  • myCPE Courses are taken by : CPA | CMA | CFE | CIA | CPA(Yellow Book)| CFP | CFA | CPA (Govt.) | EA | CRTP | MRTP | ORTP | ABV | CITP | CVA | PFS | CFF and others.

Ratings and Review

4.3

897 Ratings

Excellent

402

Very Good

347

Average

127

Poor

17

Terrible

4

JB

Janet Barber, CPA (US), CGMA

Aug 30th, 2022

Fantastic program! I wish they had a similar version for Estates to help recreate the activity and for personal use in planning and reconstruction.

AG

Amanda Girton, CPA (US)

Sep 12th, 2022

I do not do forensic accounting, but this was a very informative CPE. I liked seeing the demonstration of the software.

JA

Jessica Anderson, CIA, CPA (US)

May 13th, 2022

The presentation effectively demonstrated how Valid 8 can streamline financial audits.

DS

Dale Scrimger, CPA (US)

Jul 31st, 2022

The simplification of the information and the real life examples.

BW

Brittany Withey, CPA (US)

Jun 30th, 2022

good presentation, software seems very useful and user friendly

We use cookies to make your experience on this website better