Leveraging Microsoft Excel to Detect Fraudulent Activities
Jay Carlson 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.