Re:In defense of Excel
by Nicholas_C on Friday September 20, 2013 @01:34PM
(#6419199)
>My problem with excel is that it is not conducive to making well-documented systems. The formulas are hidden and there's no way to comment them.
You can leave notes in cells as documentation. I also have an instructions tab in just about every model I have that walks the user through the process.
The hidden formula thing can also be partially overcome by using certain colored cells to denote formulas, making the user aware that there are formulas.
You can leave notes in cells as documentation. I also have an instructions tab in just about every model I have that walks the user through the process. The hidden formula thing can also be partially overcome by using certain colored cells to denote formulas, making the user aware that there are formulas.