• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Generate Fake Data in Excel

September 27, 2021 by Andrew Childress
Generate fake data in Excel

When you work in Excel, you may find yourself wanting to run experimental analysis tasks on data. Let’s learn how to generate fake data in Microsoft Excel.

When you work in Excel, you may find yourself wanting to run experimental analysis tasks on data. It’s a good way to practice with formulas and functions that you might not have used before. But for many of these formulas to work, you’ll need a dataset to work with. Fortunately, Excel makes it easy to generate random data that you can work with. Let’s learn how to generate fake data in Microsoft Excel.

How to Generate Fake Data in Excel

Imagine that you need fifty separate numerical values to use in a formula. But you may not have an existing dataset to work with. You have two options. First, of course, you could simply type in fifty numbers. But this is time-consuming, and doesn’t work well if you need truly random data. Your other, better option is to use an Excel function to generate random values.

This is the perfect time to use Excel’s RANDBETWEEN function. In essence, it delivers random values in a range that you specify. It’s a great way to quickly generate fake data in Excel.

To generate random data, click into any empty cell in your workbook. Type an = sign inside, then input the RANDBETWEEN function. Your formula now reads:

=RANDBETWEEN(

Fake data in Excel

Now, Excel simply asks for the range for the fake data to generate. For example, you can use 1 and 5,000 as the upper and lower limits:

=RANDBETWEEN(1,5000)

Generate fake data in Excel

Hit Enter, and Excel will return a randomized, fake data value. To generate more fake data, simply click and drag the lower right corner of your formula cell to expand it across additional cells.

How to generate fake data in Excel

As you can see, it’s easy to generate fake data in Excel. It’s a great solution if you need to have random, fake data to work with to try out formulas or functions.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to make graph background transparent in ExcelHow to Make Graph Background Transparent in Excel
Next Post:Calculate FDR in ExcelFalse discovery rate in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top