Overview

Excel provides the ability to give a cell (or a range of cells) an independent name:

We can then use that name is calculations, pivot tables, etc.

We must never give a cell or a range a name that matches an Excel or Velixo function name. This can result in Excel errors and/or inconsistent/incorrect results in our wookbooks.