|
Featured Tutorial
Featured Macro
Excel Name Trick #9: Create Name Formulas
See how to create name formulas that can be then used in cells.
1) See how to create a dynamic range using a named formula that uses the OFFSET function.
2) See how to create a named formula that will randomly create sales figures between an upper and lower value.
3) See how to store a tax rate constant in a name.
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).
1) See how to create a dynamic range using a named formula that uses the OFFSET function.
2) See how to create a named formula that will randomly create sales figures between an upper and lower value.
3) See how to store a tax rate constant in a name.
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).