Early databases available for the PC market were simple two-dimensional solutions and were essentially designed as a record-keeping system. However, when computing power increased, the advent of the relational database became an affordable option. Applying the rules proposed by Edgar Codd, the Database Management System (DBMS) became a reality, with products such as dBase being widely implemented in the desktop market.
For pure data analysis, the spreadsheet is, indeed, king. To a point...Despite all of these extremely powerful features, the spreadsheet has limitations, which tend to manifest when you least expect it. Often, Murphy's Law applies and the spreadsheet falls over when you are right in the middle of a major undertaking, like month-end or meeting a tight deadline.
Many spreadsheet applications nowadays have functionality above and beyond the traditional, offering a variety of charts, look-up tables, databases and more functionality than can be mentioned here.
Size limitation : When a spreadsheet is first constructed and tested, the size tends to be small. However, as the spreadsheet grows with more and more data, it start slowing down, until it reaches that point where your feet go to sleep while you waiting for the re-calculation to finish.
excel budget templates
excel spreadsheet examples