When your spreadsheet start to hit its limits, what options are open to you? Perhaps the best option is to consider the conversion of your spreadsheet to a database solution. Relational databases became viable not too long after the spreadsheet was well-entrenched as the affordable and quick means of gathering data and performing calculations.
Protection of formulae : How often have you forgotten to protect the cell contains the formula that took you hours to test and perfect. It takes one instance of honest human error, and that formula is gone.
Rather than having to go through the pain and suffering of learning a new technology and having to experience trial and error development, the best route would be to acquire the services of a consultant, who can identify your needs and create a customised solution. Obviously, the cost of such a project would depend on the size and complexity of the spreadsheet and your requirements. However, you might be surprised at how cost-effective this project would be.
You can build a reputation as an expert spreadsheet developer. This certainly doesn't hurt the resume. Using Excelville.com to sell spreadsheets allows you to set up a profile with your work, biography, and other info that certainly makes for good conversation material during interviews.
excel inventory templates
excel budget templates