From this point on, I will refer to only one of the above mentioned applications, because it is my preferred work environment. That is Microsoft Excel. I believe users of other spreadsheet applications will be able to adapt whatever I say from here for use in their own peculiar environments.
The intelligent use of spreadsheets, combined with the application of the 80ᚼ rule will help to achieve the foregoing and more. One does not need any expert to start doing these things today. Just take the decision to start keeping daily, accurate records and commit to analysing them. You'll be surprised to find that you will soon become much more aware of how you're doing and what aspects of your business you should focus on more to get better returns for your efforts _ and you will be able to confidently supply verifiable/authentic financial data to back up any claims you make about your business performance to bankers or prospective investors.
In effect what I am saying is that companies which get the most value from spreadsheet automation(including using it to avoid expenditure on less adaptable commercial off the shelf applications) will be those which empower their users to routinely generate "in house" solutions. In such companies, you will find that only when the requirement becomes considerably specialised or complex, does the IT department get called upon to develop or purchase software solutions for user departments or functions with significant data recording and analysis needs.
For instance if a company had five drink brands in the market but notices that Brand A, which has a profit margin of at least twice the others is in greatest demand, they could (a) focus production efforts on that brand, so that more bottles go out to trade (b) Apply Best Practice/Continuous Improvement initiatives that would result in lower costs of producing each bottle of Brand A so that even though the market price remains fixed, the company is able to earn increasing profit margins per bottle.
spreadsheet templates for business
examples of spreadsheet packages
excel spreadsheet examples