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.
At present, some of the most requested types of spreadsheet packages in the market are: 'Spreadsheets for Small Businesses' and a subset of that: 'Spreadsheets for Actors'.
When VisiCalc hit the scene back in the eighties (in the last century), the relatively small group of Apple II users went crazy. It was like manna from heaven for the poor accountants, scientists and engineers who were used to filling in enormous analysis sheets with a pencil. Now, they could use VisiCalc to do the same task, AND calculate the result automatically.
Inconsistent data : This becomes most apparent when trying to find a particular record or cell, based on the contents. If a space is incorrectly added in the wrong place, the search or filter fails.
what is a spreadsheet used for
types of spreadsheet
examples of spreadsheet packages