File Download: https://www.exceluniversity.com/yt_s...

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


Subscribe here https://www.youtube.com/c/ExcelUniver... and turn on all notifications for MS Excel time hacks that will make you more productive!

⚡ Say goodbye to late nights and spreadsheet struggles! Become a timesaving Excel pro exceluniversity.com/challenge

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

Excel PivotTables for Beginners (2023)    • Excel PivotTables for Beginners (2024)  

Watch VLOOKUP Hacks Playlist here    • VLOOKUP Hacks Series  

Watch VLOOKUP vs SUMIFS Playlist here    • VLOOKUP vs SUMIFS Series  

Watch Dynamic Arrays playlist here    • Dynamic Arrays Series  

Watch Treasure Maps playlist here    • Treasure Maps Series  

Watch Slow to Fast playlist here    • Slow to Fast Series