In Excel, you can create names that refer to a single cell, a group
of cells on the worksheet, a specific value, or a formula. After you
define Excel names, you can use the names in a formula, instead of
using a constant value or cell references. For example, a cell that
contains the tax rate could be named SalesTax. Then, other cells could
multiply sales amounts by the named range, SalesTax.

For Excel names that refer to a cell or a range of cells, you can
use the names to quickly select the named range, and that makes navigation
easier. Just select a range name from a drop down list, and you'll
immediately go to that range.

For written instructions for this Excel tutorial, see: Naming
a Range

Create a Dynamic Named Range
in Excel

When you create a named range in Excel, it doesn't automatically
include new items. If you plan to add new items to a list, you can
use a dynamic formula to define an Excel named range. Then, as new
items are added to the list, the named range will automatically expand
to include them.

If you open an Excel file, you might see a message that asks if you
want to "Enable or Disable a Macro". However, you might be confident
that there are no Excel macros in this workbook.

This message appears if an Excel macro has been added and then removed,
leaving an empty module. An empty module will trigger the macro warning,
even though all the macros have been removed from the module..

In this video you'll see how to find the cause of the problem message,
and remove the problem modules.

For written instructions for this Excel tutorial, see: Macro
Warning

Convert Text Numbers to Real
Numbers

When you copy data from another program, such as Microsoft Access,
or from a text file, Excel may treat the numbers as text. If you perform
calculations with these numbers, the calculations will be incorrect,
such as a column of "numbers" that adds up to zero.

This video shows one of the methods that you can use to convert the
text "numbers" to real numbers. You'll use the Paste Special command
to multiply the text numbers by zero. That will change them to real
numbers, that you can use in calculations.

For written instructions for this Excel tutorial, and other methods
for converting text numbers to real numbers, see: Convert
Numbers