Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training - formula

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - FORMULA

excel training - FORMULA

ResolvedVersion Standard

Paul has attended:
Excel Advanced course

FORMULA

How to use formula audit?

RE: FORMULA

Hi Paul,
There is a formula auditing toolbar, which shows where the values in your formula orginate from and which cells are affected by them. (Trace Dependants, Trace Precedence). There is also a Watch window where you can view the contents, formula and value of one cell by scrolling through others.

I hope that answers your question, if there was anything more specific please let me know.

Tracy

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.