Defined names (known as "range names" in Lotus 1-2-3) are a long-standing feature in spreadsheets. If we use defined names in lieu of traditional row-and-column addresses, we can create formulas more quickly and easily, while simultaneously creating documentation for our formulas. Yet many Excel users do not use defined names, perhaps because of the time it takes to create them. In this tip, you will learn how to create defined names with just a few clicks of the mouse, thereby removing virtually any reason not to use this great feature of Excel.
Ещё видео!