0:00
hi everyone my name is Barbara welcome
0:02
back to my YouTube channel and welcome
0:04
if it's your first time watching one of
0:06
my videos today I'm going to show you
0:09
how Excel 365 has got you covered if you
0:12
need some random data generated we don't
0:15
need to do any Rand between we don't
0:18
need to use array formulas EXL 365
0:21
there's a template for it to generate up
0:23
to a thousand lines of random data for
0:26
us let's get right into it and I'll show
0:30
first of all file menu and then along
0:34
the top you should have blank workbook
0:37
tutorials and if you want to click more
0:39
templates you'll see all the templates
0:41
that are available now I've been in the
0:43
random data generator so it is there but
0:45
if you don't see it what you need to do
0:49
random and Excel and Microsoft will
0:52
search through all of the templates that
0:54
are available and it is the random data
0:57
generator you want click on it
1:02
create and you'll be taken to the
1:05
generator so I'm just going to clear
1:07
these off for now so you'll be faced
1:10
with the data generator first thing you
1:13
need to do is Select what type of data
1:16
you want and you have 10 options name
1:19
date of birth city country company job
1:21
telephone number email address and some
1:23
random text and then it'll ask you how
1:25
many rows you want to generate now you
1:27
need to input between 1 and 1,000 the
1:30
limit is a th000 on this but that should
1:32
be a lot of data if you're just using it
1:34
for testing or something like that and
1:36
then in this area here this is where
1:37
we're going to get our random data so
1:39
I'll keep it at 10 just uh for a small
1:42
sample for now and just click what you
1:45
want let's get name date of birth and
1:48
email and within a couple of seconds
1:50
excel's generated some random data for
1:53
us which is great if you want to just
1:55
use it for testing or something like
1:57
that let's go ahead and put in a
1:59
thousand and see how fast it is that's
2:04
fast let's just check it's given us a th
2:07
yeah it has that's a really good solid
2:09
random data set if you wanted to do some
2:12
testing on your Excel workbook let's put
2:17
10 and let's put in some random text see
2:22
what that looks like just to show you so
2:24
it generates 10 lines of random text
2:26
very useful if you want to do some work
2:28
with a text based functions practice or
2:33
there so Excel 365 has really got us
2:37
covered on random data generation we
2:41
don't need to put in any complex
2:42
formulas use the Rand between formulas
2:45
which is an option we could do but if
2:47
you want some fast random data Xcel 365
2:51
templates has us covered I hope you
2:53
enjoyed the video if you did give it a
2:55
thumbs up consider subscribing it is
2:57
free and it really helps the channel if
2:58
you've got any questions leave them in
3:00
the box below or leave a comment I do
3:02
read all the comments and reply to the
3:04
questions so thanks for watching I'll
3:06
see you next time for another video
