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...

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? -    • Excel Dynamic Arrays and How to use t...  
2. FILTER() function changes how you work with data in Excel -    • I don’t use filters in Excel anymore....  
3. XLOOKUP() function changes how you lookup in Excel    • STOP using INDEX MATCH in Excel, use ...  
4. Power Query changes how you work with data in Excel (simple example) -    • Powerful trick to combine all Excel f...  
5. Data model changes how you pivot data in Excel -    • Make Pivot Tables from more than one ...  

Other important features of Excel reviewed -    • Top 5 Excel skills you should focus o...  


#WhatsnewinExcel #lambda

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