Below is a link to download some Excel sample data to play around with.
The data set is 2,350 rows, and 10 columns wide, for a total of 23,500 records. Here is a screenshot of the data in the file.
The data set is entirely made up, but mirrors the type of data that reflects the operations of a normal company. We have geographic data, product data, shipping data, and financial data.
In the file, there are 10 different columns of sample data:
This data set would be great for filtering and sorting, creating basic visualizations, dual axis charts, or using in an Excel Pivot Table.
Creating the Excel sample data
Just for fun, I wrote some formulas to create the random Excel sample data set. Creating randomized data is actually quite easy. I often do it if I cannot find free data online that matches my needs.
Here is the link to download the Excel sample data set with functions included:
The only functions I used were:
For example, the formula I used for the first column of sample data (Category) is:
RANDBETWEEN is pretty simple. You provide a maximum and minimum number, and the function will return a random number in between your inputs.
I use the ROUND function with RANDBETWEEN so that I can get a whole number.
With the IF function, I created a tree of IF-THEN statements which will return one of three possible options:
So, if the ROUND(RANDBETWEEN(1,4),0) produces a 1, then the output is a “Table”.
If the output is not a 1, the function starts over. If we get a 2, then the second IF-THEN statement gives us a “Chair”.
If we get anything else (a 1, 3, or 4), the second IF-THEN statement will produce a “Couch”.
So, we have basically 5 possibilities, and 3 of them will give us a “Couch”. So we should see couch about 3/5 or 60% of the time.
The rest of the data I built the same way, using very similar formulas.
If this post was helpful, let me know in the comments!