Microsoft Excel: LET & LAMBDA Functions

Wishlist Share

About Course

Make long Excel formulas shorter, faster and easier to read. This course explains how LET names values inside a formula, how LAMBDA turns a formula into your own reusable function, and how helper functions such as BYROW apply a LAMBDA across a range.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.

What Will You Learn?

  • Use LET to name parts of a formula so it is calculated once and easy to read Build and test a LAMBDA, then save it as a named custom function Apply a LAMBDA to each row of a range with BYROW Recognise the #CALC!, #VALUE! and #NAME? errors these functions can produce

Course Content

Course Lessons

  • Why LET and LAMBDA exist
  • Naming values with LET
  • Building your own function with LAMBDA
  • Helper functions and good practice

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕