Working With Functions in Excel 2016: Use Defined Names in a Formula
Interactive

Working With Functions in Excel 2016: Use Defined Names in a Formula

Biz Library
Updated Feb 12, 2019
Microsoft Office Excel 2016: Part 2 (Intermediate) - Although it's certainly helpful to be able to name a range or a cell for easy navigation, the real power of this feature lies in the ability to easily identify references in formulas and to quickly and accurately insert references into multiple formulas. (Cell and Range Names in Formulas, Manually Entering Cell or Range Names, The Use in Formula Command Method, The Formula AutoComplete Method)