Using Excel for Databases
Excel for Databases. It is not at all uncommon for people to use Excel when working with databases. They often just put the data in a column of cells. This has its advantages and disadvantages.
Some Reasons Users Prefer Using Excel
Some Reasons Why Using a DBMS is Better
Microsoft has made it fairly easy to move data between Access and Excel, particularly once one has learned about these features.
These lists will develop more over time.
SFd Forecaster. Years ago, I started working on a database system that would also do demand forecasting. I developed the system to track and rely purely on inventory data over time. This data could then be used to forecast future demand. While this is definitely not a forecasting course, we had the models look for several underlying factors in the forecast.
So the predictions would generally do quite well.
I developed the prototype in Access for demos with the sense that we could often sell the prototype directly "off the shelf" to smaller businesses.
One of the very first larger businesses we interacted with was a well known Japanese auto manufacturer. They were tracking hundreds of thousands of parts. In addition, they needed to have replacement parts for models and parts that they had stopped selling years ago. Even in this setting they had all of their data in Excel spreadsheets. Doing the calculations required hours considering the huge number of parts.
There is much more I could say about this.