6 hours 3 minutes
Now that you have learned about the data types and custom how to write your custom data types, let's talk about giving names to cells and ranges and excel. So, uh, let's again go to excel
and let's talk about names. So here we have, for example,
a cell that says that the currency or exchange rate for currency that is euro is in Book One and in Selby, too.
And let's delete this for a moment
and gold here.
And we have this cell here which represents the exchange rate for euro between your and dollar.
And here you have a name of this so we can go here
and we can type here euro rate.
now, when you click on this cell, it's called your rate.
And, uh, when you go back to this sheet, you can click here equals
and you get it
back here. So you get to the exact value that is in that cell.
Why is this important? Because you can have this Ah, some of the important cells on some sheets and you can have
I don't know, 20 sheets or 30 sheets in the Orem in your Excel file, and you can have a situation in which you have to put in one formula four or five standardized the cells that you frequently use. Ah,
and they're all in different sheets. So,
uh, you can make the life was much simpler for you if you give the names to these cells. For example, if you have your a rate you give If you have ah, pound rate,
or you can have Canadian dollar rate or Australian dollar rate.
You can make it much simpler because then you know how you name these cells and you don't have to say, Okay, let's go to this sheet and so like to sell. You just type its name.
Now if you give too much
names to to your, um,
to your two too many cells, you might get in
in in some kind of problem because you have to remember them all.
So in that case, you go to Formulas Tab
and you have here a name manager
and you click unnamed manager, and it lists you all the names you have given in the cheat. So we have just one here. It's called your eight
and it's ah It's simple, so it gives you the value of that cell, and it gives you the reference in in standard format. So it gives you a reference to book one,
and then the door sign bead are signed to meaning that whatever you do with this formula, it will always refer to this cell. And what actually excellent does is when it makes Ric electives formula. It looks for this name.
It goes for its reference and put
there before recalculation. You don't see it. Your formula always stays with the name in it. But when Excel calculates, it does it
in that way.
So let's just keep this and let's just use one more way to define a name. So except except clicking in these books
and, for example, hearing picking dollar Well, you can go to define name
and now you can
you see that excel automatically copies
from the header of that sells says, Well, you it didn't put dollar value because you cannot have dollar signing in
in your name. But you What you can put here is, for example,
dollar well, you
Ah, and remember that this is not a case sensitive, so you don't have to put capital or uppercase letters wherever. Then you have here a scope. So it means that this name can be used in entire world Brooke or Entitle file.
Or it can be used just in this sheet or that sheet or whatever. So we leave. It'd
workbook. And then we have a reference here, and we can do it like this as well, and we click here. And so this is it. And now if you make formula and we say this cell is equal
you see gives you from the list of the names and you click and you get this
if let's go to the name manager
and let's click in your rate s So you have this reference here, which is book one. String the string,
too. Let's copy it is,
and you don't want to use the
name. You just want to refer to the cell as well.
You get the same results. So by naming a cell, you didn't exclude its reference in the standard XL way of referencing cells from the possibility when when you want to use that cell. So if you want to use the name, you're right, you can use it or you can use
actual reference of that cell.
It doesn't matter.
So let's get back now to our fuel sheet.
And let's say that we have entered
a couple of more off these purchases and I've been to enter all of the data, just
se Cupp more or three more. And now we have all these purchases
and I want to
named this range as volume
purchased and percenter.
And I want to calculate with some of these cells No, I can do it like in the standard of a quick note, the sam and get this. But this is not what I want to dio. I want to say son off. Let's let's say I want to do it here so I can adjust.
So to sum it, or I can type summoned in select sales. But I can also say
and I get here automatically. When I take a couple of characters, I get the name because it's not on the list off defined names, custom names, some bullion purchased. Let's close it
and we get this amount here, which is equal. If you see when start, their cells will get automatically. Here at the bottom
the sum of these cells. It says 102 to 3.69 which is exactly the same here. So we are. Instead of typing this range or selecting this range whenever type of cell, we can just
type of volume purchased or just type B A well, and then it will give us the list of names that begin with you. Well, if you don't have any other will, just select this and do this. And if we go to the name manager, we now see that William purchased is on the list off.
Uh, do you find names or custom names that we have created an XL?
So this is all about naming cells and rangers in Excel.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered