You can quickly create a named range using the currently selected range in your Excel worksheet.

Select Formulas > Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom …

Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and …

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

To name an array constant, click Formula, then Define Name. Enter a name and the constant, then you can use the constant as an array formula.

Select Formulas > Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom …

Use a 3-D reference in Excel to reference several worksheets, such as when you consolidate budget data from different departments in your organization.

A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. Use a 3-D reference to consolidate data in different worksheets.

You can create multiple page fields and assign your own item names for each source range. This lets you create partial or full consolidations; for example, one page field that consolidates …

Use a LAMBDA function to create custom, reusable functions and call them by a friendly name. The new function is available throughout the workbook and called like native Excel functions.