Range Names

$29.00 for 1 year

Course Overview:

This course covers how to use Named Ranges in Excel.

Key Topics:

  • Learn how to name a range in Excel.
  • How to lock a named range to a specific worksheet or workbook.
  • How to apply a named range to an existing formula
  • How to use named ranges in formulas such as a VLOOKUP
  • How to create Range Names based on Formulas
  • How to use range names to refer to data residing in the first worksheet of a workbook, when you are in any other part of the workbook.

Who Will Benefit?

Any professional that uses Microsoft Excel and wants to save time by being able to name their cells or arrays and then using those names in their calculations.

Category: