Naming constants


show more Naming constants provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Naming constants

Another thing that can be very useful when you're talking about naming cells and ranges is a variation on that theme. This is a little advanced for this stage of the training, but it's an important time to mention it and this is probably where you'd be looking for it. So if I go up to the Insert menu and down to Name and Define. This is the long way around to define a range of cells with a name. So I can click on that and the dialog box that opens shows me all of the named ranges that I have in here. Here's my mistake. I'll delete that and we have our Third Quarter and the EmptyCell example that I put in earlier.

So let's add a new one. Let's go ahead and call this InterestRate and down here where it shows you what it refers to, let's clear that and put an interest-rate in of 10%. We'll say OK. Now the advantage of doing that is when you're using the interest rate in your formulas, you can say ThirdQuarter results times InterestRate, a very high ...

Naming constants
Video duration: 1m 51s 4h 8m Beginner

Viewers:

Naming constants provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...