Excel LAMBDA() Function - What is it and when to use it?

PREPARE TO BE AMAZED!!!

LAMBDA() function will change how you use & work in Excel. In this video, let me demonstrate the LAMBDA and its practical applications.

We can use LAMBDA() to create any type of functions in Excel. This revolutionizes the way we work with Excel.

Download the sample file from here 🟩
================================

You need Excel 365 to use LAMBDA. Currently, you also need to enable the "insider" program option, but very soon, you don't need that for LAMBDA.

Learn more about LAMBDA & Get the workbook from here - https://chandoo.org/wp/what-is-lambda-function/

In this video ⏱👇
==============
0:00 - What is LAMBDA in Excel?
1:19 - Creating our first LAMBDA
2:27 - Adding LAMBDA functions to Excel
3:53 - Using LAMBDA in real life with 4 examples
4:13 - toEuro() LAMBDA to convert $ values to Euro
6:21 - Weighted Averages with a LAMBDA
9:12 - Word Count LAMBDA
11:13 - Tomorrow() LAMBDA

🤷‍♂️What else is NEW in Excel? 🎁
===========================

It is not your grandpa's Excel any more. There are many POWERFUL & fun new features in Excel now. Check out these videos to learn what else is new in Excel.

1. The # operator in Excel - What is it and how to use it? - https://youtu.be/kR6czKY4FEw
2. FILTER() function changes how you work with data in Excel - https://youtu.be/JuTdj2j-9Kg
3. XLOOKUP() function changes how you lookup in Excel https://youtu.be/gpwqUc3y7ZA
4. Power Query changes how you work with data in Excel (simple example) - https://youtu.be/SGzegma9bdY
5. Data model changes how you pivot data in Excel - https://youtu.be/NVve19gQGbw

Other important features of Excel reviewed - https://youtu.be/cEuq_9CsHIY


#WhatsnewinExcel #lambda

~
What does a young sheep 🐑 call his dad?
Lamb Da Da.. 😂