Channel: Leila Gharani

Category: Education

Tags: custom formula editor excelmicrosoft excel tutorialsnew formula editorexcel for analystsxelplusvisadvanced excel tricksxelpluslambdawriting lambdasrecursive lambdafree excel addinexcel lambdaexcel tips and tricksexcel import lambda githubmicrosoft excelleila gharaniexcel 2016excel 2019microsoft 365replace name managerexcel 2013excel online courseexcel 365importing lambdaget excel advanced formula environmentlambda function

Description: Microsoft finally 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: gist.github.com/chgrossMSFT/d172fd552cf6893bcdc7942223cb0e55 📖 This is the link to the blog post on Microsoft tech community announcing that LAMBDAs are finally available in Excel for Office 365: techcommunity.microsoft.com/t5/excel-blog/announcing-lambdas-to-production-and-advanced-formula/ba-p/3073293 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 ► xelplus.com/courses Read the blog post: xelplus.com/excel-advanced-formula-editor 🎬 LINKS to related videos: Excel Lambda Explained: youtu.be/Rm4y5UqauRw Recursive Lambdas: youtu.be/L7s6Dni1dG8 Calculate Year to Date with SCAN: youtu.be/cxw_lP_aKIo Brand New BYROW & BYCOL Functions: youtu.be/YqaEJiwJj2I 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani 👉 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