|
Featured Tutorial
Featured Macro
Excel Name Trick #1: Names in Excel 2003 & 2007
Learn the basics of how to create and use an Excel Name in Excel 2003 & 2007. See how some names from Excel 2003 are not allowed in 2007! See the new cell: Sex 1, Sex 2, Sex 3.
See how to name a cell or cell range.
See how to create and use a name in a formula and function.
See how the Excel name ROA2000 must be changed to _ROA2000 for Excel 2003.
Advantages of Excel Names: fewer range selection errors & formulas can be easier to understand.
This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).
See how to name a cell or cell range.
See how to create and use a name in a formula and function.
See how the Excel name ROA2000 must be changed to _ROA2000 for Excel 2003.
Advantages of Excel Names: fewer range selection errors & formulas can be easier to understand.
This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).