Okebiz Video Search



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.


Power Query Tips & Techniques Course
https://www.linkedin.com/learning/exc...


For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/ins...


#DynamicArrays
#RANDARRAY
#FakeDataGenerator

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Using RANDARRAY for a Random Data Generator in Excel: Random Names Using RANDARRAY for a Random Data Generator in ...
05:24 | 2
How to build Interactive Excel Dashboards How to build Interactive Excel Dashboards
52:26 | 609,953
Stock Market for Beginners 2021 | Step by Step Guide Stock Market for Beginners 2021 | Step by Step ...
57:18 | 256,979
The Ultimate Pivot Table Excel Tutorial The Ultimate Pivot Table Excel Tutorial
37:59 | 336,611
Merging Data with the 6 Joins in Power Query: Inner Join, Outer Joins and Anti-Joins Explained Merging Data with the 6 Joins in Power Query: I...
14:31 | 13,783
Unstack Data that is Separated by Bold Text: Challenge w/Kevin Lehrbass - Formulas, VBA, Power Query Unstack Data that is Separated by Bold Text: Ch...
17:11 | 697
HOW TO LOOK BETTER ON ZOOM [ How to Light & Angle Your Screen to Look Your Best] HOW TO LOOK BETTER ON ZOOM [ How to Light & Ang...
10:53 | 808,312
How To Generate A Random Password In Excel How To Generate A Random Password In Excel
05:06 | 313