Call us at +1-661-336-9555

cart

In this webinar, we define financial fraud and then describe how to detect suspicious activities. The webinar begins with a brief review of the Excel functionality used in an investigation: formulas, functions, and graphs. We then look at how to use default Excel tools such a Filter to examine a data set for fraud. We then discuss how to use Excel to spot suspicious activities using more advanced techniques such as Benford’s Law. Finally, we discuss best practices, how to present investigation results, and applying more advanced techniques.


•    Learn what financial fraud is
•    Provide a solid understanding of Excel tools
•    Learn how to use Excel tools to identify patterns and anomalies in the context of accounting principals
•    Learn how to apply statistical analysis methods to fraud investigation
•    Become familiar with more advanced investigative methods
•    Learn about the characteristics of a good investigator


•    Fraud Detection
•    What is it?
•    Why Excel?
•    Getting Familiar with Excel Tools
•    Formulas
•    Functions
•    Graphs
•    Fraud Detection Techniques
•    Filter
•    Formula and function example
•    WEEKDAY
•    TEXT
•    VLOOKUP
•    MATCH
•    Advanced techniques


Anyone interested in expanding their knowledge of fraud investigation. For example:

•    Financial professionals
•    Business owners 
•    Investigators looking to expand their skillsets


  • Financial professionals and business owners.

Jay Carlson More than 25 years of experience in the IT industry and 20 years as a technical writer, including working as the technical lead at a top software company supporting their financial software
•    Co-author of OfficeFest 2007, a self-published series of training modules that includes Using Microsoft® Excel® for Financial Analysis, Microsoft® Excel® Pivot Tables and Charts, as well as Visual Basic for Applications in Microsoft® Excel® 2007
•    SQL and iPhone® developer
•    Google Data Analytics, Six Sigma, MCSE, MCDBA, ITIL, and SCRUM certified
•    Southern Illinois University B.S. Administration of Justice
•    University of Montana M.S. Public Administration with an emphasis in finance
•    Grays Harbor College A.A. Journalism

•    Excel
•    SQL
•    Statistics
•    Technical Writer

View all trainings by this speaker
 
Live Webinar

Live Session for 1 Participant

$179

Live + Recorded Session

Get unlimited access to the link for six months for one participant, from the date of webinar completion.

$269

Live + Transcript

Get to attend the LIVE Session and also receive a PDF copy of the Transcript only after the completion of the LIVE webinar.

$249

Live + USB

Free shipment within 15 Working Days from the date of webinar completion.*

$399

On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$149

Downloadable Recorded Session

Get unlimited access to the link for six months.

$219

USB

Free shipment within 15 Working Days, from the date of webinar completion.*

$299

Group Session

Group Session Participants + Recorded

Live Session with unlimited participants. Invite any number of attendees to join.

$599

 

June 5, 2026

Language is Code - Intro to AI - Generative AI - ChatGPT and Copilot 365

Allen Evitts

Upcoming Webinars

Image

By Allen Evitts
Language is Code - Intro to AI - Generative AI - ChatGPT and Copilot 365
Date: June 5, 2026

Image

By Jenny Douras
Writing Effective Emails
Date: June 8, 2026

Image

By Elaine Eisenbeisz
From P-Values to Evidence: Interpreting Statistical Results in Regulatory Decision-Making
Date: June 8, 2026

Image

By Don Phin
Negating Negativity in the Workplace
Date: June 9, 2026

Image

By Beverly Beuermann-King
Stop Letting That Difficult Person Ruin Your Day: Effectively Handle Negative Attitudes and Difficult People
Date: June 9, 2026

Image

By Paul Pelletier
Mastering Tough Conversations: Turn Conflict into Clarity, Accountability, and Results
Date: June 9, 2026

Image

By Candie L. Simmons
Networking for Professional Success
Date: June 9, 2026

Image

By Susan Fahey Desmond
Writing Effective Job Descriptions
Date: June 9, 2026

Image

By Marcia Zidle
High-Impact Performance Management: Tools, Tactics & Coaching Skills For Busy Managers and Supervisors!
Date: June 9, 2026

Image

By Garrett Wasny
ChatGPT for Innovative Business Advisory Services for Accountants
Date: June 10, 2026

Image

By Dr. Susan Strauss
Female to Female Hostility @Workplace: All you Need to Know
Date: June 10, 2026

Image

By Erica Chisolm & Vanessa Hardiman
Mastering Performance Management: Strategies for Continuous Improvement and Success
Date: June 10, 2026

Image

By David Benaim
50+ new Excel features so far this decade
Date: June 10, 2026

Image

By Staci Warne
AI for Project Managers: Smarter Planning Reporting and Communication with ChatGPT
Date: June 10, 2026

Image

By Ginette M. Collazo
Latest Trends in Human Error Reduction in GMP Manufacturing
Date: June 11, 2026

Image

By Terry Winship
Understanding Office 365 Collaboration
Date: June 11, 2026

Image

By Sarah OBrien
Attachment Styles in the Workplace
Date: June 11, 2026

Image

By Marcia Zidle
Bootcamp for New Managers and Supervisors: Develop These Essential Leadership Skills & Be a Better Boss!
Date: June 11, 2026

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on The Complexity and Interplay Among ADAAA, FMLA, and Worker's Comp (WC) - How do they Work Together, or Not?
Date: June 12, 2026

Image

By John Fetzer
Analytical Method Validation Under Good Laboratory Practices GLPs
Date: June 12, 2026

Image

By Carolyn Troiano
Data Integrity and Privacy - Compliance with 21 CFR Part 11, SaaS/Cloud, EU GDPR in 2026
Date: June 15, 2026

Image

By Vikram Varma
AI in Excel and Power BI
Date: June 15, 2026

Image

By Diane L. Dee
Do's and Don'ts of Documenting Employee Behaviour, Performance, and Discipline
Date: June 15, 2026

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on How to Conduct an Internal Harassment and Bullying Investigation to Determine Facts and Minimize Liability
Date: June 15, 2026

Image

By Dr. Bill Trombetta
The Perfect Storm Coming to Healthcare: Value Based Care Meets Fraud and Abuse and Social Determinants of Healthcare
Date: June 16, 2026

Image

By Bruce Lee
Fostering a Culture of Respect: Eliminating Gossip, Rumours, & Destructive Behaviour
Date: June 16, 2026

Image

By Mark Schwartz
Payroll Record Keeping: How to Thin Out File Cabinets and Quickly Respond to Information Requests
Date: June 16, 2026

Image

By Edwin Waldbusser
Medical Device Cybersecurity Following FDA’s 2026 Premarket Guidance
Date: June 17, 2026

Image

By Dev Strischek
Construction Lending And Real Credit Administration: Evaluating, Underwriting, And Monitoring Construction Loans
Date: June 17, 2026

Image

By Ritu Arora
Integrating AI Tools in Microsoft Office
Date: June 18, 2026

Image

By Ms. Michael Redmond
HIPAA Compliance in 2026 — Practical Strategies for Breach Prevention, Risk Reviews, and Audit-Ready Enforcement Preparation
Date: June 18, 2026

Image

By Hulya Kurt
Launch Your Career: The Ultimate Guide for Emerging Professionals
Date: June 22, 2026

Image

By Pete Tosh
Moving From an Operational Manager to a Strategic Leader
Date: June 22, 2026

Image

By Diane L. Dee
I-9 Audits: Strengthening Your Immigration Compliance Strategies in 2026
Date: June 23, 2026

Image

By Paul J. Cline
Dealing With Difficult People: At Work & In Life
Date: June 23, 2026

Image

By Lesley Crook
Discover how Emotional Intelligence turns AI from a technical rollout into a practical, secure capability people want to use every day!
Date: June 23, 2026

Image

By Markus Ehrenmueller-Jensen
The 60 Minutes Introduction to DAX
Date: June 24, 2026

Image

By David Nettleton
The 6 Most Common Problems in FDA Software Validation and Verification
Date: June 24, 2026

Image

By Aimee Bernstein
Empowering Conflict Resolution: Letting Go to Gain Control
Date: June 24, 2026

Image

By Kathryn E. Strachan
AI Across the Business: Practical Use Cases for Founders and Leaders
Date: June 25, 2026

Image

By Craig Brody
Using Copilot in Microsoft Excel
Date: June 25, 2026

Image

By Marcia Zidle
Faster, Better Talent Acquisition: Leveraging AI & ChatGPT for Smart Hiring and Effective Onboarding!
Date: June 25, 2026

Image

By William Mack Copeland
The Anti-Kickback Statute: Enforcement and Recent Updates
Date: June 26, 2026

Image

By Richard E Cascarino
ChatGPT for Accountants
Date: June 26, 2026

Image

By Jay Carlson
Leveraging Microsoft Excel to Detect Fraud
Date: June 27, 2026

Image

By Richard Erschik
ChatGPT: From Beginner to Next Steps
Date: June 29, 2026

Image

By Edlyn McGarity
Goal Mastery: From Resolutions to Results in 2026
Date: June 30, 2026

Image

By Margie Faulk
DOL Reverses Course on Independent Contractor Rule for 2026! How Will Employers Adapt to the Change?
Recorded Session

Image

By Edwin Waldbusser
Human Factors Usability Studies Following ISO 62366 and FDA Guidance
Recorded Session

Image

By Rebecca Staton-Reinstein
Project Management for administrative professionals
Recorded Session

Image

By Bob Verchota
Managing Toxic & Other Employees Who have Attitude Issues
Recorded Session

Image

By Margie Faulk
Handbook Overhaul 2026: Compliance, OBBB Act & Beyond
Recorded Session

Image

By Diane L. Dee
Kicking your Employee Retention Efforts into Overdrive: Stay Interviews, Pay Transparency, and Other Effective Strategies
Recorded Session

Image

By Terry Winship
The Importance of the first 5 seconds when presenting
Recorded Session

Image

By Sarah OBrien
Emotional Intelligence for Leadership
Recorded Session

Image

By Dr. Susan Strauss
Workplace Investigations 101: How to Conduct your Investigation Like a Pro
Recorded Session

Image

By Tonia Morris
Moving from Peer to Boss: Supervisor 101
Recorded Session

Image

By David Nettleton
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11 Compliance
Recorded Session

Image

By Beverly Beuermann-King
Managing Toxic Employees: Strategies For Leaders To Effectively Deal With Employee Attitude Issues
Recorded Session

Image

By Mark Gorkin
Stress, Change And Team Resilience Through Humor: An Interactive Playshop
Recorded Session

Image

By Paul J. Cline
4-Hour Virtual Seminar on Transformational Leadership - The Ultimate Leadership Course
Recorded Session

Image

By Edwin Waldbusser
FDA Regulation of Artificial Intelligence/ Machine Learning
Recorded Session

Image

By Rebecca Staton-Reinstein
Leadership: Strategic Planning and Decision Making
Recorded Session

Image

By Susan Fahey Desmond
HANDLING FMLA ABUSE
Recorded Session

Image

By Justin Muscolino
Understanding EBITDA – Definition, Formula & Calculation
Recorded Session

Image

By Paul Pelletier
Thriving in a Hybrid Workplace: Keys to Leadership and Team Success
Recorded Session

Image

By Garrett Wasny
Chat GPT for Accountants
Recorded Session

Image

By Justin Muscolino
Accounting Foundations: Understanding the GAAP
Recorded Session

Image

By Jenny Douras
Dealing with Difficult People
Recorded Session

Image

By Deb Schaffer
ChatGPT and Project Management: Leveraging AI for Project Management Excellence
Recorded Session

Image

By Cathy Horwitz
Excel Power Skills: Master Functions, Formulas, and Macros – A 3-Hour Workshop
Recorded Session

Image

By Paul J. Cline
Ultimate Persuasion Strategies! - Secret Influence Tools & Skills
Recorded Session

Image

By Mr.Derek Henry
Excel 101: Mastering the Fundamentals
Recorded Session

Image

By Richard Erschik
AI and ChatGPT for Beginners
Recorded Session

Image

By Ginette M. Collazo
Human Error Reduction Techniques for Floor Supervisors
Recorded Session

Image

By Pete Tosh
Utilizing HR Metrics to Illustrate & Improve Human Resource's Contribution
Recorded Session

Image

By Mark Gorkin
Transforming Anger And Conflict Into Collaborative Problem Solving: The Stress Doc’s Four Faces Of Anger – Model And Method
Recorded Session

Image

By Mike Thomas
Excel - Formulas and Functions 101
Recorded Session

Image

By Melveen Stevenson
Workplace Compliance in 2026: New Laws, Big Changes, and What Comes Next (includes OBBBA)
Recorded Session

Image

By Bob Verchota
How to Conduct Exit Interviews - Implementing and Enhancing Your Exit Interview Program
Recorded Session

Image

By Don Phin
Onboarding is NOT Orientation - How to Improve the New Employee Experience
Recorded Session

Image

By Audrey Halpern
Do's and Don'ts of Giving Effective Feedback for Performance Improvement
Recorded Session

Image

By Dr. B. Lynn Ware
What's New in Onboarding
Recorded Session

Image

By Melveen Stevenson
California Meal and Rest Breaks: What You Don't Know Can Cost You
Recorded Session

Image

By Michael Healey
Conquer Toxic People - Learn To Protect Yourself And Get Your Sanity Back
Recorded Session

Image

By Richard E Cascarino
Accounting For Non Accountants : Debit, Credits And Financial Statements
Recorded Session

Image

By Mike Thomas
Excel + AI: The Smart User's Guide to Faster, Easier Work with ChatGPT
Recorded Session

Image

By Paul J. Cline
4-Hour Virtual Seminar on Secrets of Psychology - Why People Do The Things They Do
Recorded Session

Image

By Dev Strischek
Better Business Writing-How to Write Right
Recorded Session

Image

By Mike Thomas
Excel - Pivot Tables - The Key To Modern Data Analysis and Reporting
Recorded Session

Image

By Pete Tosh
Managing Toxic & Other Employees Who Have Attitude Issues
Recorded Session

Image

By Don Phin
Emotional Intelligence: Mastering the Emotions of Great Leadership
Recorded Session

Image

By Danielle DeLucy
Batch Record Review and Product Release
Recorded Session

Image

By Bob Verchota
Onboarding Best Practices for Millennial and All Employees
Recorded Session

Image

By Justin Muscolino
Electronic Payment Fraud Prevention Best Practice
Recorded Session

Image

By Brian G. Rosenberg
Payments Fraud Detect & Prevent Check, ACH and P-Card Schemes
Recorded Session

Image

By Daniel Clark
Writing Techniques for Auditors and Risk Management Professionals
Recorded Session

Unsubscribe

×

Subscribe Here

×