excel vba courses london - Tracing precedents

Resolved · Low Priority · Version Standard

Tracing precedents

Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

by - delegate Tim [14 posts] (2007 Aug 15 Wed, 13:46) Reply

When formula auditing, Is it possible to trace precedents onto different pages of a workbook.

When you go to trace precedents for a particular cell, it just has a line to a little excel sheet sign. How do you follow the line on to the page where the referred to cell is?

Is there a command to show the different pages to which a cell refers concurrently?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Tracing precedents

by - trainer Amanda diamond contributer [1199 posts] (2007 Aug 15 Wed, 14:14) Reply

Hi Tim

Thank you for your question.

What will happen when you use Trace Error where the cell in question refers to cell/s on other sheets, you will get a dashed line and a little spreadsheet icon appear on the spreadsheet. If you double-click at any point along the dashed line, the Go To dialogue box will appear on your screen listing the cells that are referred to in the formula so that you can select a cell reference from the Go To dialogue box and click OK to go to that cell and investigate what the problem might be.

This also gives you a way of being able to see what cells a particular formula refers to.

I hope this helps.
Amanda

· Microsoft Excel Features and Functions for Accountants
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Basic Excel Training

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips