In today's video, I'll show you how to supercharge your Excel formulas using the powerful LET function!
I'll start with simple examples and then dive into practical applications like name formatting, grade calculations, amortization schedules, and even show you how to create a dynamic calendar using LET formulas.
LET function is available in Excel 2021, Excel 2024, Excel with Microsoft 365, and Excel on the Web.
➡️ Download Example file - https://www.dropbox.com/scl/fi/q35qbrsz4cm0fu9g5d0zo/LET-Function-Examples.xlsx?rlkey=4dulolfikwswidk23cqfqd6qe&dl=1
00:00 Intro
00:51 LET Function Basics
03:29 Reusing Calculation Result in LET Function
07:09 Using LET function with NESTED IF Formula
09:20 Getting LET Formula result in multiple columns
12:09 Amortization Schedule Using LET Function
14:56 Creating Dynamic Calendar with One LET Formula
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial #SumitBansal