Lists and Arrays: Excel Just Got Bigger. So Did the Job.
Excel cells can now hold lists and arrays. That opens up new possibilities, and makes it matter more than ever who designs your spreadsheet.
Encoding and Decoding Data with LET
How do you get several values out of one formula? LET encodes them together, so a real estate valuation model can decode and reuse them anywhere.
Lambda – For Flexible Formulas
One custom LAMBDA brought structure and flexibility to a multi-leg scheduling workflow.
Why Lambda is Central to the New Excel
What is a LAMBDA function, and why does it matter? LAMBDA encapsulates your unique logic, turning your workbook from a static document into a self-contained application.