Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Chapter 10

Using names, LET, LAMBDA, and Data Types in Excel

Using names in Excel

Storing intermediate formula results using LET

Storing logic in LAMBDA functions

Using Data Types in Excel

Names have always played a role in Excel. You could name a range in order to create easier-to-read formulas. For instance, =SUM(MyExpenses) makes formulas more self-documenting than =SUM(Sheet5!AB2:AB99).

But names have been chosen as the place to store a new class of powerful formulas called LAMBDA functions. You can define your own logic in a LAMBDA function, store it in the Name Manager, and then re-use that logic in the workbook.

This chapter also covers the new LET function and Data Types.

Using names in Excel

Names have a variety of uses in a workbook. ...