Range Names Syllabus

Range Names

This course covers Range Names and consists of 9 topics.

Name Box – This video shows how to create range names using the Name Box.
Create From Selection – This video shows how to create range names based on spreadsheet text using Create from Selection and using the Name Manager to edit and delete range names.
F3 Trick – This video shows how to use the F3 key to paste a range name into a formula.
Name Entire Row or Column – This video shows how to name an entire row or column.
Apply Names – This video shows how to ensure that if you create range names, they will show up in previously created formulas.
Worksheet and Workbook Names – This video shows how you can create range names that apply to only a single worksheet or the entire workbook.
Range Name Tricks – This video shows how to use a named row in a formula and create ranges based on Excel formulas.
Implicit Intersection – This video shows how to pick off an entry in an array by simply typing the row and column headings.
Vertical Lookup With Range Names – This video shows how to use Range names in VLOOKUP formulas.
Learn More