Excel LET & LAMBDA: Readable Formulas, Custom Functions & MAP/REDUCE
Name intermediate results with LET, build your own functions with LAMBDA, use named LAMBDAs like built-ins, summarise rows and columns with BYROW/BYCOL, apply custom logic with MAP, run totals and compounding with SCAN and REDUCE, generate grids with MAKEARRAY and refactor a nested formula: 8 hands-on labs, graded instantly.
The first lesson is free — no account needed.
About this course
An Excel LAMBDA and LET course that turns long formulas into readable ones and your own rules into custom functions for one fictional furniture retailer, Alder & Finch, for Excel power users, analysts and modellers on Microsoft 365. You name intermediate results with LET so a value is calculated only once, write LAMBDA functions with one and two parameters and call them inline, use named LAMBDAs such as TaxPrice and MarginPct like built-in functions and nest them, summarise every row and column with BYROW and BYCOL, apply your own logic to each element with MAP, build running totals and compounding with SCAN and a final balance with REDUCE, generate tables, rotas and an instalment plan with MAKEARRAY, and refactor a nested commission formula into LET and LAMBDA with identical results. LAMBDA needs Microsoft 365 or Excel 2024. The first lab is free.
Lessons
- LET: Name Your Intermediate Results for Readable, Faster FormulasFree
- LAMBDA Basics: Parameters, a Calculation and Calling It Inline Pro
- Named LAMBDAs: TaxPrice, MarginPct and Your Own Workbook Functions Pro
- BYROW and BYCOL: One Formula for Every Row or Column Pro
- MAP: Your Own Logic for Every Element, Even with AND and OR Pro
- REDUCE and SCAN: Running Totals, Compounding and Final Balances Pro
- MAKEARRAY: Multiplication Tables, Rotas and Payment Schedules Pro
- Capstone: Refactor a Nested Commission Formula into LET and LAMBDA Pro