Oz’s Excel Tip: Keep a Workbook for Random Data in Excel


Welcome back to another episode of Excel.TV where Oz du Soleil shares his Excel tip. Here it is: always have a workbook with random data.  With this workbook, you’ll have a ready made resource to test your dashboards, workbooks, and financial models. 

In this video, Oz goes through his many worksheets showing off fake data. I actually don’t have a workbook like this. (It’s a good idea to create one, I must admit.)  didn’t want to leave you empty handed, since at the end, Oz says to “Go make your own,” random data workbook. And I need to create a workbook like this too! 

Resources you can use to generate fake and random data

So I figured as I went out to make my own random data worksheet, I’d share my resources with you so that you can make your own. Below I’ve collected a list of resources to help you get started.

How do you generate random data? 

Let us know in the comments.

Jordan Goldmeier
Latest posts by Jordan Goldmeier (see all)


You may also like

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

October 26, 2014

Monte Carlo Simulation Formula in Excel – Tutorial and Download

September 17, 2012

The Excel Rollover Mini FAQ
  • Numbers are easy, but names are a bit of a puzzle for me. I’m wondering if they have links to some sort of census site. I’m hoping someone will do the work and share a workbook in the comments.

  • Here is another possible source

    Discovering millions of datasets on the web 2020 01 23
    Across the web, there are millions of datasets about nearly any subject that interests you. If you’re looking to buy a puppy, you could find datasets compiling complaints of puppy buyers or studies on puppy cognition. Or if you like skiing, you could find data on revenue of ski resorts or injury rates and participation numbers. Dataset Search has indexed almost 25 million of these datasets, giving you a single place to search for datasets and find links to where the data is. Over the past year, people have tried it out and provided feedback, and now Dataset Search is officially out of beta.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free 24 Excel Tips Guide

    Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'

    A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!