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

Introduction

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.


Tags


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • 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
    https://blog.google/products/search/discovering-millions-datasets-web/
    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 Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

    >