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'.

Share:

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)