Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

Microsoft released LAMBDA: the most powerful FUNCTION in Excel ever because you can create ANY Function you want. Even recursive Excel functions can be done with Lambdas. But using LAMBDA with Name Manager was a pain.

Specially if you wanted to create a recursive lambda function. That's over now! Writing your own custom Excel functions with LAMBDA is now easier than ever! You don't have to face the pain we have with name manager which was:
1. Name manager keeps adding cell references when you move with the mouse
2. Name manager doesn't give us help about the formula arguments when we're typing the formulas in.
3. Name manger has a small box.

In this video I'll show you how to use the New Excel Formula Editor Environment to write new functions and how you can import existing LAMBDA functions. There are currently two ways. You can copy the functions to your clipboard and add them to your other workbooks. Or you can create a Github gist and use the URL to get all the lambdas.

👩‍💻 Here is the link to Chris Gross' GitHub Gist: https://gist.github.com/chgrossMSFT/d...

📖 This is the link to the blog post on Microsoft tech community announcing that LAMBDAs are finally available in Excel for Office 365: https://techcommunity.microsoft.com/t...

00:00 How to Use the New Excel Formula Editor
00:44 Install the Advanced Formula Environment Add-In
01:07 How to Use the Advanced Formula Environment
04:09 Name Manager VS Advanced Formula Editor
06:15 How to Use LAMBDA in the Advanced Formula Environment
09:39 How to Import Functions with a GitHub Gist URL
11:18 Append Rows from Different Tables
12:24 How to Edit LAMBDA Formulas
13:44 The Downside
14:58 Wrap Up

🌍 My Online Excel Courses ► https://www.xelplus.com/courses/

Read the blog post: https://www.xelplus.com/excel-advance...

🎬 LINKS to related videos:
Excel Lambda Explained:    • Excel LAMBDA - HOW & WHEN you Should ...  
Recursive Lambdas:    • Excel RECURSIVE Lambda - Create loops...  
Calculate Year to Date with SCAN:    • How to Calculate YTD (Year to Date) V...  
Brand New BYROW & BYCOL Functions:    • How You Can Actually Use the NEW Exce...  

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / xelplus  

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #Lambda