Excel Tip - Precedents and Dependents

When working in complex Excel workbooks you often have to trace formulas in order to understand or even correct the data. Follow this video to learn how to trace ‘precedent’ and ‘dependent’ cells using some useful shortcut keys and the auditing tools…

 

 To watch without sound, turn captions on by clicking 'CC' then selecting 'English'.