Download Excel File: https://excelisfun.net/files/EMT1745.xlsx
Learn how to create a random monthly sales data set with the fields: Date, Units, Product and Discounted Price. Learn about the functions: RANDBETWEEN, RANDARRY, RAND, NORM.INV, INDEX, XLOOKUP, CHOOSE, INT, DATE, EOMONTH and ROUND.
1. (00:00) Introduction
2. (00:28) Create Start and End Date formulas
3. (01:12) Create Date Field with RANDBETWEEN function
4. (02:09) Create Date Field with RANDARRAY function
5. (03:00) Create Units Field with RANDARRAY function
6. (03:17) Create Product Field with INDEX, RANDARRAY and ROWS function
7. (04:09) Create Price Field with XLOOKUP function
8. (04:34) Create Discounted Field with LOOKUP function
9. (05:39) Create Discounted Price Field with the complement of the discount to calculate the Price Net Equivalent
10. (06:16) Round Discounted Price using the ROUND function
11. (06:53) Bonus Formula to create a formula with three different distributions of random numbers using the functions NORM.INV, CHOOSE and RANDBETWEEN
12. (09:49) Summary, Closing and Video Links