Avoid common spreadsheet problems
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
|
There are quite a few spreadsheet problems that can be avoided by following sound data entering and formula editing principles. A few of the more general spreadsheet problems and ways to avoid them are shared below.
Mixing formulas with data entry areas
Keep data entry areas and formula areas in separate worksheets to ensure well organized Excel worksheets. If you for instance, make the data entry areas a specific colour to indicate where the users should enter data and will be allowed to make changes, you will prevent unnecessary entry mistakes by users. |
|
Not protecting formula areas
If there are several users that need to enter data, make sure that the formulas are protected. You don’t want someone to change a formula without you knowing and thus changing the outcomes. Accidental overwriting of a formula can easily happen. If you have Spreadsheet Professional, make use of the map tool to identify possible spreadsheet problems related to the formula areas.
Placing values directly in formulas
Avoid this error by ensuring that the values used by the formulas are placed in other cells. This will ensure that when updating is done that the formulas will also be updated correctly.
Spreadsheet Professional makes it easier to identify and correct spreadsheet problems which would otherwise have taken up a lot of time and resources to locate and correct. Three main categories ensure that this software is the best tool to identify mistakes namely; The Mapping, Comparison, and Testing tools. Visit the Spreadsheet Professional category to learn more about this advanced and useful tool.
|
