When You Should Use the New Excel LET Function

The first 1000 people who click the link will get 2 free months of Skillshare Premium: https://skl.sh/leilagharani0820

🔥 400,000+ professionals trust our courses—start your journey here 👉 https://link.xelplus.com/yt-d-all-cou...

Whether you're dealing with long formulas or seeking to enhance formula performance, this video is a game-changer for Excel users. Excel's new LET function can make your formulas easier to read and it can improve the performance of your formulas so they run faster. This applies to formulas that use the same expression (e.g. formulas, values) multiple times.

⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/let-functio...

✨ Key Highlights:
▪️ Introduction to LET Function: Discover the basics and the availability of the LET function in Excel.
▪️ Syntax and Examples: Learn the syntax and see practical examples, including IF conditions and dynamic arrays.
▪️ Performance Improvement: Explore how the LET function can speed up your Excel formulas, especially in large datasets.
▪️ Real-Life Application: Detailed walkthrough of using LET in different scenarios, enhancing readability and efficiency.

In this video you'll learn the basics of the LET function and also find out in which situation the LET function can REALLY make a difference for you. I measured the time for a full calculation on a large data set for different scenarios. You'll be surprised when you see the results!

Note: LET function is not available in Excel 2019 or Excel 2016. Only in Excel for Microsoft 365.

Link to Fast Excel from Charles Williams: http://www.decisionmodels.com/FastExc...

LINK to Excel New Features & Dynamic Arrays Playlist:    • Excel for Office 365 & Dynamic Arrays  

Advanced Excel Tips & Formulas:    • Excel Advanced Formulas & Features  

00:00 Why use Excel's LET function
01:07 Availability and Syntax of Excel LET Function
03:12 Example of LET Function with IF Conditions
06:53 Example of LET Function with Multiple IF Conditions and Symbols
08:55 Does Excel LET Function REALLY Improve Performance?
11:03 LET Function with Excel Dynamic Arrays
14:46 Performance of Excel LET Function with Dynamic Arrays

➡️ 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  

Many thanks to Skillshare for sponsoring this video!

Note: 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