One user at a time : In the instance where there are a number of people required to work on a spreadsheet, they can only access it when no-one else is working on it.
They are the ideal tools for companies who lack the financial resources and / or the staff required for generating spreadsheet solutions with specific programs. At present, the most requested types of ready-made spreadsheet solutions are "Spreadsheets for Small Business" and the subcategory "Spreadsheets for Actors".
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.
Spreadsheet templates are used for many reasons and each template vary according to the purpose it is used for. Spreadsheets are designed with different calculations depending on various needs.