Enhancing readability with range names

- In Excel, you can name a cell or name a range of cells.…And then you can use those names in formulas.…And sometimes it's really helpful to clarify…what a formula is doing.…In other words, a cell address, although fine…and appropriate, is nearly as clear as a name,…provided it's a sensible name.…I'm about to write a formula in Cell I2…to calculate a new salary.…And everybody on the list here, moving down Column I,…is going to get a 2.91% increase, so that's in Cell K1.…

All these cells will be referring to that,…and I'll start off with just a simple formula.…We could do this in two or three different ways, certainly.…One way to write this formula =G2*K1.…We want this to be an absolute address,…so I'll press the function key F4 and +G2.…We have our answer.…We can copy it down the column.…However, what if we were to name that cell?…Then we could use the name in the formula.…It's going to be a little bit clearer, and the cell,…by the way, if it's farther away,…possibly this cell might be moved off to the right…or maybe it's way off to the right to begin with.…