Naming a range or cells for long and complex formulas

[Edgarvelez]

Hi all,
Long time ago I went to an excel training and the trainer showed a way where if you had long and complex formulas
that would get confusing by looking at them, he would Name the column, range or single cell.

Example on formula bar:
Normal Example with a name
=SUM(A5:C30) =SUM(InventoryTotal)

Looking to find out what the name of this function is and some guidance to a tutorial would be appreciated.

 

[BigBeachBananas]

Named range

A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box.

exceljet.net

 

[Edgarvelez]

Named range

A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box.

exceljet.net

Thank you for the prompt reply, this is what I was looking for.