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
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.
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!
Many thanks to Skillshare for sponsoring this video!
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/FastExcelV4.htm
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-let-function
★ My Online Excel Courses ► https://www.xelplus.com/courses/
LINK to Excel New Features & Dynamic Arrays Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
Advanced Excel Tips & Formulas: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Time Stamps
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
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel
Видео When You Should Use the New Excel LET Function канала Leila Gharani
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.
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!
Many thanks to Skillshare for sponsoring this video!
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/FastExcelV4.htm
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-let-function
★ My Online Excel Courses ► https://www.xelplus.com/courses/
LINK to Excel New Features & Dynamic Arrays Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
Advanced Excel Tips & Formulas: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Time Stamps
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
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel
Видео When You Should Use the New Excel LET Function канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
When Should you Use the Hash Sign (#) in Excel Formulas?Exciting New Excel LET Function - Comprehensive Guide10 Amazing (Less Known) Excel Tricks You Should KnowFREE Windows Apps You Should be Using (who thought these are ACTUALLY FREE?!)Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)Excel DGET Function Solves 2 of Your VLOOKUP ProblemsExcel LAMBDA - HOW & WHEN you Should use itExcel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Return Multiple Match Results in Excel (2 methods)Excel VBA Beginner TutorialCreate INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons5 Excel Functions YOU NEED in 2021Excel LAMBDA Function6 FREE Add-Ins for Excel to Start Using NowExcel shortcut keys you SHOULD know!4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1How to easily automate boring Excel tasks with Power Query!