Creating Fake Data in Excel: random dollar amounts & dates using RANDARRAY & TEXT

/in /by

To do training we need fake data (dummy data) to work with. In this video I show how to use RANDARRAY and the TEXT function to create a list of dummy transactions. This solution also takes advantage of Dynamic Arrays and the new calculation engine behind Excel. We also generate a list of fake dates.

Power Query Tips & Techniques Course
https://www.linkedin.com/learning/excel-power-query-tips-and-techniques-office-365/what-you-should-know?u=2125562
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
#DynamicArrays
#RANDARRAY
#FakeDataGenerator

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2