Oz's Excel Tip: Keep a Workbook for Random Data in Excel

4 years ago
6

Welcome back to another episode of Excel.TV where Oz his major Excel tip. Here it is: always create a workbook with random data.

Oz didn't feel like sharing his workbook, but if you'd like here are some videos and tutorials you can use to help you create a fake data worksheet!

https://excel.tv/ozs-excel-tip-keep-a-workbook-for-random-data-in-excel/

CREATING RANDOM DATA IN EXCEL USING RANDBETWEEN AND CHOOSE
https://excel.tv/creating-random-data-in-excel-using-randbetween-and-choose/

Creating Fake Data in Excel: random dollar amounts & dates using RANDARRAY & TEXT
https://www.youtube.com/watch?v=zhNf8EnzU-E

How to Create Sample/Dummy Data Sets in Excel
https://www.youtube.com/watch?v=RERDNtjG7w8

Dummy Data – How to use the Random Functions
https://chandoo.org/wp/dummy-data-random-functions/

Creating Sample Data Sets for Excel Spreadsheets
https://www.consultdmw.com/create-excel-data-set.html

Mockaroo (this is what I use!)
https://mockaroo.com/

Generate Data Using Excel: RAND & RANDBETWEEN
https://datascopic.net/generate-data/

Loading comments...