Using Excel to Detect Fraudulent Activities

$219.00

SKU: 411840 Category:

Description

Learn how to identify unique patterns within the data to uncover fraudulent activities.

Microsoft Excel is one of the most productive and versatile pieces of software that you can spend money on. Evolving from a simple accounting ledger, Excel is now commonly used for statistical analysis, forecasting and data mining.
And folks just keep thinking of new and innovative ways to use Excel. In this webinar, we’ll do a review of Excel basics and then dive into using Excel to detect fraud.

Learning Objectives

– You will be able to define the key features of Excel that make it a useful tool for detecting fraudulent activities.
– You will be able to explain how to use Excel tools such as PivotTables, What-If analysis, and Solver to identify irregularities in financial data.
– You will be able to recognize useful Excel functions such for fraud detection and data validation.
– You will be able to review key strategies for leveraging Excel’s capabilities to enhance fraud detection efforts in financial and business data.

 

Presenter: Jay R. Carlson, FatDAWGS.com
Credits*: ACFE, AIPB, CPE
Time of program 100 min, 1 pm ET
Date of program April 10, 20258

Why Excel?
• Simple (Relatively)
• Versatile (Very)
• Inexpensive (Relatively)

Getting Started
• Install the Analysis Toolpak
• What Are You Trying to Communicate? Is Excel the Right Tool?
• How Will You Make That Happen? What Data Will You Present and How?
• Basic Idea of a First Draft

Excel Concept Overviews
• Keyboard Shortcuts
• Importance of Cell Formatting
• Absolute and Relative References
• Formulas
• Functions

Nifty Excel Tools
• Pivot Tables
• What-If
• Analyze Data
• Solver

Detecting Fraud
• Ageing Analysis
• Pareto Charts
• Benford’s Law
• Detecting Outliers

Useful Functions
• TEXT
• WEEKDAY
• IFERROR
• IFNA
• MATCH
• MOD

Conclusion

ACFE ,AIPB ,CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Jay R. Carlson-FatDAWGS.com