Leveraging Microsoft Excel to Detect Fraudulent Activities

November
19
2025 (Wednesday)
Time 10:30 AM PST | 01:30 PM EST
Duration: 60 Minutes
14 Days Left To REGISTER
Id: 210347
Instructor
Jay Carlson 
Live
Recorded
Live + Recorded

Overview

Excel is a powerful tool for analyzing data, including financial analysis. In this presentation, you’ll discover how to use the tools in Excel to detect fraud and other types of financial crime.

Areas Covered in the Session

  • Fraud Detection - What is it?
  • Why Excel
  • Getting Familiar with Excel Tools
  • Fraud Detection Techniques
  • Filter
  • Formulas and functions
  • WEEKDAY
  • TEXT
  • VLOOKUP
  • XMATCH
  • Best Practices
  • Data Normalization
  • Ethics
  • What makes a good investigator?

Who Will Benefit

  • All

Speaker Profile

Jay Carlson With more than 25 years of experience in the IT industry - including 20 years as a technical writer - Jay Carlson had developed deep expertise in communicating complex technical concepts with clarity and precision. He had served as a technical lead at a leading software company, supporting its financial software solutions and guiding documentation strategy. He is also the co-author of OfficeFest 2007, a self-published series of training modules covering Using Microsoft® Excel® for Financial Analysis, Microsoft® Excel® Pivot Tables and Charts, and Visual Basic for Applications in Microsoft® Excel® 2007. In addition to writing background, he had hands-on experience as an SQL and iPhone® developer. Professional certifications include Google Data Analytics, Six Sigma, MCSE, MCDBA, ITIL, and SCRUM. Academically, he holds a B.S. in Administration of Justice from Southern Illinois University, an M.S. in Public Administration with an emphasis in Finance from the University of Montana, and an A.A. in Journalism from Grays Harbor College. His technical strengths include Excel, SQL, statistics, and technical documentation.
Access Recorded Version
One Attendee / Group Attendees

Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)