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.
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.
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.
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'.
spreadsheet templates for business
examples of spreadsheet packages