Call us at +1-661-336-9555

cart

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.


  • 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

•    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

Anyone interested in expanding their knowledge of fraud investigation. For example:
  • Financial professionals
  • Business owners 
  • Sales professionals and managers

  • Financial professionals and business owners.

Jay Carlson 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
•    Co-author of 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
•    SQL and iPhone® developer
•    Google Data Analytics, Six Sigma, MCSE, MCDBA, ITIL, and SCRUM certified
•    Southern Illinois University B.S. Administration of Justice
•    University of Montana M.S. Public Administration with an emphasis in finance
•    Grays Harbor College A.A. Journalism

•    Excel
•    SQL
•    Statistics
•    Technical Writer

View all trainings by this speaker
 
Live Webinar

Live Session for 1 Participant

$179

Live + Recorded Session

Get unlimited access to the link for six months for one participant, from the date of webinar completion.

$269

Live + Transcript

Get to attend the LIVE Session and also receive a PDF copy of the Transcript only after the completion of the LIVE webinar.

$249

Live + USB

Free shipment within 15 Working Days from the date of webinar completion.*

$399

On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$149

Downloadable Recorded Session

Get unlimited access to the link for six months.

$219

USB

Free shipment within 15 Working Days, from the date of webinar completion.*

$299

Group Session

Group Session Participants + Recorded

Live Session with unlimited participants. Invite any number of attendees to join.

$599

 

June 23, 2026

Dealing With Difficult People: At Work & In Life

Paul J. Cline

Upcoming Webinars

Image

By Paul J. Cline
Dealing With Difficult People: At Work & In Life
Date: June 23, 2026

Image

By Lesley Crook
Discover how Emotional Intelligence turns AI from a technical rollout into a practical, secure capability people want to use every day!
Date: June 23, 2026

Image

By Aimee Bernstein
Empowering Conflict Resolution: Letting Go to Gain Control
Date: June 24, 2026

Image

By David Nettleton
The 6 Most Common Problems in FDA Software Validation and Verification
Date: June 24, 2026

Image

By Marcia Zidle
High-Impact Performance Management: Tools, Tactics & Coaching Skills For Busy Managers and Supervisors!
Date: June 24, 2026

Image

By Markus Ehrenmueller-Jensen
The 60 Minutes Introduction to DAX
Date: June 24, 2026

Image

By Kathryn E. Strachan
AI Across the Business: Practical Use Cases for Founders and Leaders
Date: June 25, 2026

Image

By Marcia Zidle
Faster, Better Talent Acquisition: Leveraging AI & ChatGPT for Smart Hiring and Effective Onboarding!
Date: June 25, 2026

Image

By Craig Brody
Using Copilot in Microsoft Excel
Date: June 25, 2026

Image

By Richard E Cascarino
ChatGPT for Accountants
Date: June 26, 2026

Image

By William Mack Copeland
The Anti-Kickback Statute: Enforcement and Recent Updates
Date: June 26, 2026

Image

By Jay Carlson
Leveraging Microsoft Excel to Detect Fraud
Date: June 27, 2026

Image

By Richard Erschik
ChatGPT: From Beginner to Next Steps
Date: June 29, 2026

Image

By Don Phin
Emotional Intelligence: Mastering the Emotions of Great Leadership
Date: June 29, 2026

Image

By Audrey Halpern
Do's and Don'ts of Giving Effective Feedback for Performance Improvement
Date: June 29, 2026

Image

By Deb Schaffer
Copilot and HR: An Introduction for HR Professionals
Date: June 30, 2026

Image

By Edlyn McGarity
Goal Mastery: From Resolutions to Results in 2026
Date: June 30, 2026

Image

By Tonia Morris
Moving from Peer to Boss: Supervisor 101
Date: June 30, 2026

Image

By Margie Faulk
Your AI Advantage: How HR Professionals Can Use Claude to Stay Compliant, Save Time, and Work Smarter
Date: July 1, 2026

Image

By Ritu Arora
Copilot for Excel – Work Smarter with AI
Date: July 1, 2026

Image

By Ginette M. Collazo
Human Error Reduction Techniques for Floor Supervisors
Date: July 2, 2026

Image

By Richard Erschik
AI and ChatGPT for Beginners
Date: July 2, 2026

Image

By Carolyn Troiano
Validation of FDA-Regulated Medical Device and SaMD Products Using AI, ML, and LLMs, such as ChatGPT
Date: July 3, 2026

Image

By Edwin Waldbusser
Human Factors Usability Studies Following ISO 62366 and FDA Guidance
Date: July 3, 2026

Image

By Manish Gupta
ChatGPT for CPAs and Finance Professionals
Date: July 6, 2026

Image

By Pete Tosh
Managing Toxic & Other Employees Who Have Attitude Issues
Date: July 6, 2026

Image

By Diane L. Dee
I-9 Audits: Strengthening Your Immigration Compliance Strategies in 2026
Date: July 6, 2026

Image

By Steven G. Meilleur
I-9 Enforcement & Compliance: A 5-Step Plan for Employers to Mitigate Risk
Date: July 7, 2026

Image

By Ms. Michael Redmond
Major cGMP Issues: FDA Concerns in 2026
Date: July 7, 2026

Image

By Jay Carlson
Leveraging Excel for Decision Making and Data Analysis
Date: July 7, 2026

Image

By Paul J. Cline
4-Hour Virtual Seminar on Transformational Leadership - The Ultimate Leadership Course
Date: July 7, 2026

Image

By Justin Muscolino
Understanding EBITDA – Definition, Formula & Calculation
Date: July 8, 2026

Image

By Beverly Beuermann-King
Managing Toxic Employees: Strategies For Leaders To Effectively Deal With Employee Attitude Issues
Date: July 8, 2026

Image

By Margie Faulk
DOL Reverses Course on Independent Contractor Rule for 2026! How Will Employers Adapt to the Change?
Date: July 8, 2026

Image

By Rebecca Staton-Reinstein
Leadership: Strategic Planning and Decision Making
Date: July 8, 2026

Image

By William J. Rothwell
Navigating HR Like A Pro: What Every Small Business & New HR Person Should Know, Do and Avoid
Date: July 9, 2026

Image

By Deb Schaffer
ChatGPT and Project Management: Leveraging AI for Project Management Excellence
Date: July 9, 2026

Image

By Dr. John C. Fetzer
HPLC Analytical Method Development and Validation
Date: July 9, 2026

Image

By Allen Evitts
Managing Projects When AI Joins the Team: Human Judgment, AI Agents, and the New PM Role
Date: July 10, 2026

Image

By Bruce Lee
Negotiating Skills For Professional Results - Winning Strategies Before, During, and In Closing, to Get More and Pay Less
Date: July 10, 2026

Image

By William Mack Copeland
Paying and Receiving Payments for Referrals: You Can Go to Jail; Here's Why
Date: July 14, 2026

Image

By David Nettleton
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11 Compliance
Date: July 14, 2026

Image

By Tom Fragale
ChatGPT for Excel
Date: July 14, 2026

Image

By Craig Brody
Transcend VLOOKUP in Microsoft Excel
Date: July 14, 2026

Image

By Karla Brandau
The Age-Inclusive Workplace: How to Lead and Work Across Generations
Date: July 15, 2026

Image

By Dr. Susan Strauss
Tattoos, hijabs, piercings, and pink hair: The challenges of a dress & appearance code
Date: July 15, 2026

Image

By Dev Strischek
Ten Red Flags that Signal Financial Distress in Business Customers
Date: July 15, 2026

Image

By Mark Schwartz
The New W4 - How to Assist Employees with Proper Completion for Payroll Withholding Purposes
Date: July 16, 2026

Image

By Dr. B. Lynn Ware
What's New in Onboarding
Date: July 16, 2026

Image

By Mark Gorkin
Transforming Anger And Conflict Into Collaborative Problem Solving: The Stress Doc’s Four Faces Of Anger – Model And Method
Date: July 16, 2026

Image

By Pete Tosh
Moving From an Operational Manager to a Strategic Leader
Recorded Session

Image

By Bruce Lee
Fostering a Culture of Respect: Eliminating Gossip, Rumours, & Destructive Behaviour
Recorded Session

Image

By Diane L. Dee
Do's and Don'ts of Documenting Employee Behaviour, Performance, and Discipline
Recorded Session

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on How to Conduct an Internal Harassment and Bullying Investigation to Determine Facts and Minimize Liability
Recorded Session

Image

By Carolyn Troiano
Data Integrity and Privacy - Compliance with 21 CFR Part 11, SaaS/Cloud, EU GDPR in 2026
Recorded Session

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on The Complexity and Interplay Among ADAAA, FMLA, and Worker's Comp (WC) - How do they Work Together, or Not?
Recorded Session

Image

By Marcia Zidle
Bootcamp for New Managers and Supervisors: Develop These Essential Leadership Skills & Be a Better Boss!
Recorded Session

Image

By Sarah OBrien
Attachment Styles in the Workplace
Recorded Session

Image

By Terry Winship
Understanding Office 365 Collaboration
Recorded Session

Image

By Dr. Susan Strauss
Female to Female Hostility @Workplace: All you Need to Know
Recorded Session

Image

By David Benaim
50+ new Excel features so far this decade
Recorded Session

Image

By Don Phin
Negating Negativity in the Workplace
Recorded Session

Image

By Susan Fahey Desmond
Writing Effective Job Descriptions
Recorded Session

Image

By Beverly Beuermann-King
Stop Letting That Difficult Person Ruin Your Day: Effectively Handle Negative Attitudes and Difficult People
Recorded Session

Image

By Rebecca Staton-Reinstein
Project Management for administrative professionals
Recorded Session

Image

By Bob Verchota
Managing Toxic & Other Employees Who have Attitude Issues
Recorded Session

Image

By Margie Faulk
Handbook Overhaul 2026: Compliance, OBBB Act & Beyond
Recorded Session

Image

By Diane L. Dee
Kicking your Employee Retention Efforts into Overdrive: Stay Interviews, Pay Transparency, and Other Effective Strategies
Recorded Session

Image

By Terry Winship
The Importance of the first 5 seconds when presenting
Recorded Session

Image

By Sarah OBrien
Emotional Intelligence for Leadership
Recorded Session

Image

By Dr. Susan Strauss
Workplace Investigations 101: How to Conduct your Investigation Like a Pro
Recorded Session

Image

By Mark Gorkin
Stress, Change And Team Resilience Through Humor: An Interactive Playshop
Recorded Session

Image

By Edwin Waldbusser
FDA Regulation of Artificial Intelligence/ Machine Learning
Recorded Session

Image

By Susan Fahey Desmond
HANDLING FMLA ABUSE
Recorded Session

Image

By Paul Pelletier
Thriving in a Hybrid Workplace: Keys to Leadership and Team Success
Recorded Session

Image

By Garrett Wasny
Chat GPT for Accountants
Recorded Session

Image

By Justin Muscolino
Accounting Foundations: Understanding the GAAP
Recorded Session

Image

By Jenny Douras
Dealing with Difficult People
Recorded Session

Image

By Cathy Horwitz
Excel Power Skills: Master Functions, Formulas, and Macros – A 3-Hour Workshop
Recorded Session

Image

By Paul J. Cline
Ultimate Persuasion Strategies! - Secret Influence Tools & Skills
Recorded Session

Image

By Mr.Derek Henry
Excel 101: Mastering the Fundamentals
Recorded Session

Image

By Pete Tosh
Utilizing HR Metrics to Illustrate & Improve Human Resource's Contribution
Recorded Session

Image

By Mike Thomas
Excel - Formulas and Functions 101
Recorded Session

Image

By Melveen Stevenson
Workplace Compliance in 2026: New Laws, Big Changes, and What Comes Next (includes OBBBA)
Recorded Session

Image

By Bob Verchota
How to Conduct Exit Interviews - Implementing and Enhancing Your Exit Interview Program
Recorded Session

Image

By Don Phin
Onboarding is NOT Orientation - How to Improve the New Employee Experience
Recorded Session

Image

By Melveen Stevenson
California Meal and Rest Breaks: What You Don't Know Can Cost You
Recorded Session

Image

By Michael Healey
Conquer Toxic People - Learn To Protect Yourself And Get Your Sanity Back
Recorded Session

Image

By Richard E Cascarino
Accounting For Non Accountants : Debit, Credits And Financial Statements
Recorded Session

Image

By Mike Thomas
Excel + AI: The Smart User's Guide to Faster, Easier Work with ChatGPT
Recorded Session

Image

By Paul J. Cline
4-Hour Virtual Seminar on Secrets of Psychology - Why People Do The Things They Do
Recorded Session

Image

By Dev Strischek
Better Business Writing-How to Write Right
Recorded Session

Image

By Mike Thomas
Excel - Pivot Tables - The Key To Modern Data Analysis and Reporting
Recorded Session

Image

By Danielle DeLucy
Batch Record Review and Product Release
Recorded Session

Image

By Bob Verchota
Onboarding Best Practices for Millennial and All Employees
Recorded Session

Image

By Justin Muscolino
Electronic Payment Fraud Prevention Best Practice
Recorded Session

Image

By Brian G. Rosenberg
Payments Fraud Detect & Prevent Check, ACH and P-Card Schemes
Recorded Session

Image

By Daniel Clark
Writing Techniques for Auditors and Risk Management Professionals
Recorded Session

Image

By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Recorded Session

Image

By Justin Muscolino
CFPB's Debt Collections Rules
Recorded Session

Unsubscribe

×

Subscribe Here

×