Worksheet troubleshooting

This chapter shows you how to use Excel s wide range of worksheet functions to construct sophisticated worksheet formulas. In addition, you ll learn how to use named references in formulas, which makes constructing complicated formulas an easier and more error-free task. You ll also learn techniques of formula editing and worksheet troubleshooting. 

These same positive trees are very useful feeder documents for many types of hazard analysis. For example, the item layout for failure mode and effects analysis worksheets can be taken directly from the positive tree for the project. Positive trees can easily be converted into negative trees for troubleshooting or accident analysis. 

---