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

microsoft-excel-courses - formula

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Formula

microsoft-excel-courses - Formula

ResolvedVersion Standard

Renu has attended:
Excel Advanced course

Formula

How to use formula audit

RE: Formula

Hi Renu,

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

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.