Interactive
Working With Functions in Excel 2016: Use Defined Names in a Formula
Biz Library
Updated Feb 12, 2019Microsoft 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)
Related learning
