In Excel, you can define names for ranges, arrays, constants, and formulas.
Most Excel users are familiar with named ranges. The ability to name a range makes our formulas easier to read and write.
However, the technique of defining names in Excel has special powers that many Excel users are unfamiliar with. You will see names being used at various points in this book to overcome Excel limitations.
This comprehensive chapter will cover all the fundamentals of defined names so that when they are used within formulas later in the book, you ...
