How to Launder Money with Excel (Benford's Law)

preview_player
Показать описание

This video shows how to use Excel to launder cash from a questionable source through a legitamite business. To show how, we have a special guest named Walter. After he shows how he does it, we'll show how we can use an auditor's tool called Benford's law to compare the distribution of the sales log to the expected distribution per Benford. This video shows:
- store the sales log in a Table (how to create a Table)
- use the RANDBETWEEN function to create fake transactions
- how to use a PivotTable to compute the distibution of first digits
- how to compare to the expected distribution per Benford's law

Chapter's In This Video:
00:00 - Introduction
00:15 - Table
00:43 - RANDBETWEEN
01:53 - Benford's Law

Also, check out these videos with time saving Excel Hacks:

Рекомендации по теме
Комментарии
Автор

Very clever and entertaining way to teach several techniques. I’m retired now but still love learning about the capabilities power of excel. Thank you for your videos. Cheers

smahood
Автор

Is it only me thinking 1st April been 2 days ago?🤔

skenming
visit shbcf.ru