In this webinar, we begin by defining data analysis and understanding how it differs from analytics. We then look at data analysis methods such as forecasting, regression, Pareto charts, and decision trees. Finally, we learn about the how and why of Monte Carlo simulations.
WHY SHOULD YOU ATTEND?
Anyone interested in expanding their knowledge of fraud investigation. For example:
- Financial professionals
- Business owners
- Sales professionals and managers
AREA COVERED
• Data Analysis
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
LEARNING OBJECTIVES
- Learn what data analysis is
- Provide a solid understanding of Excel tools and analysis methods
- Learn how to use Excel tools to gain new insights
- Learn how to apply statistical analysis methods to financial data
- Become familiar with more advanced analysis methods
- Learn about best practices such as data integrity
WHO WILL BENEFIT?
- Financial professionals and business owners.
Anyone interested in expanding their knowledge of fraud investigation. For example:
- Financial professionals
- Business owners
- Sales professionals and managers
• Data Analysis
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
- Learn what data analysis is
- Provide a solid understanding of Excel tools and analysis methods
- Learn how to use Excel tools to gain new insights
- Learn how to apply statistical analysis methods to financial data
- Become familiar with more advanced analysis methods
- Learn about best practices such as data integrity
- Financial professionals and business owners.
