The use of good spreadsheet techniques is critical to an efficient spreadsheet. Nothing kills analysis, scenario checking or error checking faster than "hard-coded" data and the lack of cell naming. Avoid spending significant time reviewing each and every formula in your sheet by:
1. Set up the variables assumed in your spreadsheet in their own cells (even on their own sheet - I like to utilize a 'Data' sheet in all my spreadsheets).
2. Name pertinent cells or ranges (click in the "Name Box" to the left of the formula bar and enter a name).
3. Use the Name that you created to build your formulas.
The result is that you can change the calculated values of multiple formulas easily with the change of one cell containing your variable.
