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:
Four years ago I was reading a business plan and I saw something called a sensitivity analysis table that baffled me.
It was a beautiful table that showed the profitability of a music festival at different numbers of attendees and price points.
The data table showed dozens of profit possibilities in one table, with the different price and attendee numbers laid out across the horizontal and vertical axes.
I thought to myself, “that looks complicated, maybe one day after working in Excel for years I’ll be able to do that.”
However, the reality is that these tables are quite easy to set up. By the end of this blog post you’ll be able to easily perform what-if-analysis.