In this video I’ll show you how you can easily create sample data in Microsoft Excel. Generating Random data is often needed for testing or if you need to share a file with someone who shouldn’t see your actual data. I’ll cover different methods to create random numbers including a solution that creates random data without repeats.

Timestamps

• 00:00 How to Generate Random Numbers in Excel
• 00:29 How to Use the RAND Function
• 01:15 How to Use the RANDBETWEEN Function
• 02:05 How to Use the RANDARRAY Function
• 02:47 How to Create Random Numbers WITHOUT Repeats
• 06:44 Wrap Up

#excel #microsoft