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.
Agenda
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
Speakers
Jay R. Carlson,
FatDAWGS.com- Principal and co-owner of FatDAWGS.com, an IT solutions company
- Microsoft® Certified System Engineer (MCSE) as well as a Microsoft® Certified Database Administrator (MCDBA)
- 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
- Through FatDAWGS.com, co-wrote 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”
- Co-developed commercial SQL solutions and well-reviewed iPhone® applications
- Graduate, Southern Illinois University; master’s degree in public administration with an emphasis in finance, University of Montana; associate’s degree in journalism
Who Should Attend
This live webinar is designed for business owners and managers, auditors, CPAs, finance directors, compliance specialists, supervisors, associates, analysts, bookkeepers, and accountants.
