Microsoft Excel Tutorial – Easiest Way to Create a Lambda function in Excel.

A new version of the Advanced Formula Environment from Excel Labs has been released. It has an amazing new functionality called Import from Grid.

There are many times where I will build a complicated Excel formula in sub-formulas. I finally combine all the sub-formulas into one mega-formula by scooping the subformulas out of the formula bar and pasting in to the final formula.

The new Advanced Formula Envionment, found in the Excel Labs add-in, offers to create a LAMBDA function from existing worksheet logic in the grid.

Table of Contents
(0:00) Welcome
(0:11) Build sub-formulas in Excel
(0:29) Scooping sub-formulas into mega-formula
(0:55) Advanced Formula Environment replaced by Excel Labs
(1:27) Getting the Excel Labs add-in
(1:45) Two apps in the Pane
(2:01) Import from Grid
(2:47) Named the Lambda & use in grid
(3:14) Headings in grid used in LET function
(3:58) Wrap-up
(4:21) Outtake: TEXTBEFORE and TEXTAFTER