This article is focused on giving insight in the power of range names in Excel. Starting off with simply naming a range of cells, continued with the powerful option to put a formula in a name and topped off with showing how to put XLM macro functions to use in defined names, enabling you to do things you can normally only achieve using VBA.
By making proper use of defined names, you can build powerful and easy to maintain Excel solutions.
Creating and editing Range Names in Excel is much easier if you start using the Name Manager!
There are various sites that have extensive information about Excel's capability to define a name that refers to a range of cells or a formula. An instructive one is:
Chip Pearson (English)