Dependencies

The UK's most regular instructor-led training courses.
Training information: excel+course · Excel/courses/london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Dependencies

Jenna has attended:
Excel Intermediate course

by - delegate Jenna [1 post] (2008 May 20 Tue, 16:35) Reply

How do you do dependencies?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: dependencies

by - trainer Simon silver contributer [73 posts] (2008 Jun 4 Wed, 10:14) Reply

Hi Jenna,

Thank you for question.

To show the dependencies, you need to go to Tools - Formula Auditing - Show the formula auditing toolbar.

If you then select a cell that contains a formula, click on the second button on the toolbar which is Trace precedents. This will show you the cells that are used in the formula.

The second option is useful if you have something like an interest rate that is used in formulas throughout your spreadsheet. Select the cell that contains the interest rate and click on the fourth button on the toolbar Trace dependents. This will then show you all the cells that are dependent(cells that will change) upon the interest rate changing.

I hope this answers your question.

Regards

Simon

· Advanced Excel Training - takes you to the next level
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How to check for and reduce errors in Microsoft Excel
· Do You Really Need Excel VBA Training?
· Features of Microsoft Excel that assist in Analysis of Financial Data

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips