Excel 2019: Use Range Names

Course description

This course explains how range names make Excel worksheets clearer, more reliable, and easier to maintain. It begins by defining range names and showing how naming cells or ranges improves readability, reduces errors, and replaces fragile cell references as workbooks become more complex. You’ll explore common uses such as identifying key inputs, lookup tables, and results so formulas are easier to understand and maintain. The course also explains how names function as absolute references, helping preserve formula logic when copying or moving calculations. You’ll learn naming rules and conventions, including valid characters, length restrictions, disallowed patterns, and practical guidelines for creating short, meaningful names that remain consistent across a workbook. Several methods for creating names are covered, including the Name Box for quick labels, Define Name for greater control, and Name Manager for reviewing, editing, deleting, and auditing existing names. The course also demonstrates Create from Selection, allowing multiple names to be generated from row or column labels while maintaining clarity and consistency. Additional topics include using names as navigation tools to quickly move between important worksheet areas, along with scope options, documentation practices, and maintenance strategies. By the end, you’ll understand how to plan, create, and manage range names that improve formula readability, simplify auditing, and support safer updates in growing spreadsheets.

Course outline