2 ms·
>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
by Nicholas_C 13y ago
>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.
- Nicholas_C 13y agoAlso: Pressing Ctrl + ~ reveals all formulas in the active sheet. A great way to see where all the formulas are quickly.