How to use Excel's Formula Audit -tools

Sometimes it is hard to understand the logic of complex Excel formulas - Especially when there are lots of references to different cells or ranges. Excel has (of course :-) ) great helper tools for this. There is set of Audit Formulas -tools in Ribbon bar's Formulas tab.

• Trace Precedents: Shows with arrows from where the selected formula takes it's parameters
• Trace Dependents: Shows with arrows the formulas that contains reference to the selected cell
• Check for Errors: Tool for analysing possible errors in formula
• Remove Arrows: Clears arrows from the screen

Following video demonstrates this:

Tip: If you have difficulties to see the video, try to maximise it from lower right corner: