Name a Range
To name a selected range, click in the "Name box" (far left on the formula bar) and type a one word name.

Go To a Named Range
To go to a named range select it from the "Name box" (far left of the formula bar). Or push F5.

Edit a Named Range
To delete or edit a named range go to Insert>Name>Define or Push Ctrl+F3.

Headings as Range Names
Highlight your range including the headings and go to Insert>Name>Create or push Ctrl+Shift+F3.

Named Formula
To make a Name refer to a constant formula e.g. "TaxRate", go to Insert>Name>Define and type TaxRate in the "Names in Workbook" box and 36% in the "Refers To". Now enter =(10*TaxRate) anywhere on the Worksheet.

Named Range List
To obtain a list of all Named Ranges and where they refer, select any blank cell (make sure you have no data underneath or 1 column over) and go to Insert>Name>Paste then Paste List.