Home / Video /
Creating Fake Data in Excel: random dollar amounts & date..
Title
:
Creating Fake Data in Excel: random dollar amounts & dates using RANDARRAY & TEXT
Duration
:
04:54
Viewed
:
1,419
Published
:
04-11-2019
Source
:
Youtube
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.
![HOW TO LOOK BETTER ON ZOOM [ How to Light & Angle Your Screen to Look Your Best]](http://i.ytimg.com/vi/YO6utfQm7Bg/default.jpg "HOW TO LOOK BETTER ON ZOOM [ How to Light & Angle Your Screen to Look Your Best]")
