When You Should Use the New Excel LET Function

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/let-function-file

[@yash1152]

[6:17 thaattttt (breaking up using alt + entere) is new to me and what i needed for so long. thanks for including that. and glad i clicked this vid. 7:53 conditional formatting

[@howartp84a]

Hear hear! Never mind all the new functions Leila is showing us, even experienced Excel users; it’s these usability tips that are of equal if not more importance. ps, I only found Win+. for emojis this afternoon by accident, then an hour later Leila shows us!

[@CameronRex]

Thank you so much for pointing out the LET (and IFS) functions. This has drastically simplified a very complex formula we have been using. Our existing formula was 1615 characters in length, and with just the LET function it reduced the formula length to 487 characters. With a combination of the LET and IFS functions, it reduced the length of the formula to 469 characters. Here is the end result using LET & IFS: =LET(x,INDEX(TableName,MATCH([@sale],[sale],0),MATCH(Adj1_Element,TableName[#Headers],0)),a,Adj1_a,b,Adj1_b,c,Adj1_c,d,Adj1_d,e,Adj1_e, IFS( Adj1_Graph_Type="Exponential",a*EXP(b*x), Adj1_Graph_Type="Linear",a*x+b, Adj1_Graph_Type="Logarithmic",a*LN(x)+b, Adj1_Graph_Type="Polynomial (2 order)",a*x^2+b*x+c, Adj1_Graph_Type="Polynomial (3 order)",a*x^3+b*x^2+c*x+d, Adj1_Graph_Type="Polynomial (4 order)",a*x^4+b*x^3+c*x^2+d*x+e, Adj1_Graph_Type="Power",a*x^b, TRUE,"")) While I have not measured any performance improvement, since I have only run a limited test, I am sure it is there.

[@excelisfun]

Let us all have more fun efficiency now that LET has arrived! Thanks, Teammate!

[@LeilaGharani]

You bet Mike ;)

[@zubairso]

Would love to see a collaboration between you two. That’ll be like the Avengers version of excel.

[@voievod9260]

Yes please. Would be like 2 DJs mixing side by side.

[@helenasvensson6747]

What I great way to show how we can use Let! Thanks!

[@syedaneesdurez7197]

Amazing and most important is your way of explanation is so simple and easy to understand any complicated formulas... Thanks

[@healthconnect4474]

Started watching your videos for the view and then realized that I learned lot of short cuts in excel. Thanks great job

[@hemanthnani5052]

You are making my job so easy..... Thank you Leila... You are a savior

[@zodayn]

This is SO useful. I had a formula that basically consisted of pre-modifiers, the main formula, and post-modifiers. But the post modifier are dependant on the outcome of the main formula. So for each post-modifier I had to add the entire main formula again. This made the code extremely long since the main formula was a string of 20 if checks. Now it's just 3 neat sections of close split with nice breaks.

[@Leontor1234]

Leila, I'm a heavy excel user and I love your videos ! You are always clear and to the point. Greetings from Brazil !

[@cyrilmichy8925]

Thanks for sharing Leila! Awesome tuto!! 👍🏼

[@nonoobott8602]

So brilliant. The LET function is so great. You're a an amazing teacher. Thanks for sharing

[@LeilaGharani]

Thanks so much!

[@GaryJohnWalker1]

What an excellent teacher - clear explanation and meaningful yet still clear examples.

[@LeilaGharani]

Glad you think so, Gary!

[@ShaikPashaImran]

you are awesome, your explanation is out of this world, so easy to understand, nothing like this i have ever seen before. thank you Leila

[@LeilaGharani]

Wow, thanks!

[@msmith3090]

Finally got to use LET at work. Thanks for helping me understand it!

[@amoorinet..]

Understanding from one time from Mrs. Leila GHarani Videos Thanks

[@wratorres1967]

Thanks Leila! a great example of productivity.

[@felipelandim2881]

Your way of teaching is very very good and easy to follow.

[@LeilaGharani]

Thanks a lot, Felipe!

[@domxem5551]

You are a true professional... You deserve all the best in life

[@LeilaGharani]

Thank you!

[@JHatLpool]

Great demonstrations here, especially the application beginning at 07:00.

[@morganwildman5528]

First video of yours I've watched and I hit that bell at the 5:00 mark. Your depth of knowledge, ease and speed of use of Excel, and clarity of communication combines into an informative video that surpasses all other Excel videos I've ever watched by everyone, ever. Your quality and professionalism is the gartner quadrant that has been missing in the excel video community, until now.

[@LeilaGharani]

Wow, thank you Morgan! Glad to have you onboard :)

[@akyuvar8121]

quality of your videos are getting better and better. Congrats

[@LeilaGharani]

I appreciate that!

[@xyclos]

As always clear and direct. Thanks Leila

[@winter9798]

I have to admit i like the way you teach, very easy to follow. I am now going to start using LET!

[@LeilaGharani]

Great to hear!

[@Oppadu]

Indeed! LET function would be a one of the most with FILTER function to make the excel more powerful. Thank you for sharing the great knowledge

[@LeilaGharani]

You're very welcome!

[@RobertFCM]

¡Gracias!

[@LeilaGharani]

Thank you Robert!

[@Maya-sv1pz]

I don't have time to watch all your vids but whenever I did watch, I am glad I did.

[@LeilaGharani]

Great to hear, Amy.

[@Derivatives_Hunter]

Ma’am you are a great teacher... i found you just 2 days back and i have become crazy about your videos. Thank you so much🙏 from India

[@IvanCortinas_ES]

A function LET in programming mode, declaring variables. Thank you for this fantastic tutorial Leila!

[@LeilaGharani]

Glad you enjoyed it, Iván!

[@millerlite196]

A lot of the formulas i write for excel repeat sections of the formulas over and over so this will make them a lot shorter. thanks for the vid

[@pierrel.3937]

I did not see the point at the begining but it's really useful! thanks Leila!

[@carmela0119]

Thank you for sharing!! This is really useful!!

[@Pasanglecpha]

I have learnt so much from this channel ❤❤❤ it has really helped me in my work.

[@LeilaGharani]

That's awesome! Thank you.

[@nickbell6311]

I am regular watching KZbin channel, big thanks for you make lot of videos especially on excel, I think I am becoming expert on excel because of you, thanks 🙏 please continue making videos on excel and also on MS Word

[@techymarky]

Learned a lot here. Not just the LET function. Awesome video! Subbed!

[@LeilaGharani]

Thanks for the sub, Mark!

[@rahulranjan6740]

Your video lectures are excellent

[@LeilaGharani]

Glad you think so!

[@johns8903]

I appreciate living in the age free education and great teachers. Thanks Leila.

[@alainmulaire9471]

Leila, congrats on excellent videos. I like your pace, and your ability to explain this to us. All the best.

[@LeilaGharani]

Thank you very much, Alain!

[@MamounAtieh]

It was amazingly enjoyed, thanks a lot 🌹

[@amy19355]

That's one of the most useful functions I have learned! Your videos are just terrific.

[@LeilaGharani]

Glad you like them!

[@mireillecantrell4638]

Love your tutorials and the clear way you present them. I keep watching them over and over till it sinks in. Also love the Excel downloads so I can play with them..

[@LeilaGharani]

Glad you like them, Mireille!

[@jeanlamoureux7138]

Thanks Leila for your suggestions, it worked, I just added more columns to the formula

[@LeilaGharani]

Glad it helped, Jean!

[@OzduSoleilDATA]

Nice use of LET and icons. 🔥

[@LeilaGharani]

Thanks Oz 🔥

[@tasadduqmajeed68]

Please teach about formula distribute the amount proportionally on different things. Thanks

[@curlywurly2021]

Great video... as always :) When you have tables with long column names and these get repeated in formulas it can make them really hard to read, so using LET will make these much easier to read and maintain - all we have to do is look at the variable at the beginning and we'll see which columns this refers to throughout.

[@bazoo513]

A very thorough treatment of this little useful function. Speaking of performance, I remember how, about the time you were born, a 100 x 20 sheet was recalculated for several seconds (VisiCalc on Apple ][), and auto-recalc was usually turned off.

[@rocsalt5617]

I've been grumbling that Excel should have this feature for years. Now i'm super excited!

[@WordBaron]

Thanks Leila! Your explanations and use cases are awesome, but by taking the time to measure it against larger datasets, you have encouraged me to use this function without fear of it slowing down my workbooks. These sorts of above-and-beyond insights are what make your channel so useful to me. Thanks again!

[@LeilaGharani]

Glad it's appreciated, Walter!

[@yash1152]

8:32 11:51 11:53 how are u showing those keypresses?? (12:37 for explanation of what those shortcuts do)

[@alfredoluwatomi6899]

This is great.Many thanks for this tutorial quiet straightforward and impactful. I see let function working more like the variable function in powerbi.

[@wlk7318]

Great topic, awesome video and beyond perfect tutor. Thank you.

[@LeonardoGalotera]

Hi Leila, this is very timely because I am working on a project that this function will prove useful.

[@LeilaGharani]

Great! Hope it will come in handy for you.

[@jayaseelanpeter]

Nice background setup. It's very wonderful to watch your video

[@LeilaGharani]

Glad you liked it :)

[@nathanmountain23]

LET function is very useful . The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula

[@hussainakhtar1094]

Hi, I have applied this to my report for payroll and the outcome is really very effective in terms of times and efficiently.. Really love the part whn you analysed and compared the time reduction between w/wo LET... Thank you again Leila... :)

[@LeilaGharani]

Great to hear!

[@clalgbarros]

Congratulations from Rio. Your videos help a lot and you explain the concepts very well.

[@LeilaGharani]

Awesome, thank you!

[@qiaorongchang8605]

Thanks Leila for this tutorial of LET function ! You are simply ahead of everyone! 💛💛💛🧡🧡🧡

[@yvon8488]

Since I watched this video a few months ago and learned about the "LET" function, I'm using it every day since. Thank you. 🙂

[@LeilaGharani]

Excellent! Glad the video was helpful.

[@yvon8488]

Hi@@LeilaGharani , I forgot to mention that using the LET function allowed me to add comments easier in the formula by adding a comment line at the start and then change line for the rest of the formula: = LET( COMMENT; N("......"); .....)

[@peteglews6601]

Im very late to the party in trying to learn this function but this is very well explained and delivered. Thank you... subscribed!

[@LeilaGharani]

Happy to have you aboard!

[@berndeckenfels]

That # for value lists is good to know.

[@goksi5883]

Fantastic function I learned from you today! Thank you!

[@LeilaGharani]

You're very welcome!

[@jevvandegrift3862]

I can use this A LOT. Thanks!

[@PradeepKumar-ng5oy]

Mam you're fabulous Excel tutor I had ever seen.👌👌

[@LeilaGharani]

Thanks a lot 😊

[@andrewmoss6449]

The addition of the LET function means that Excel formulas are basically becoming like a programming language where declaring variables is the norm.

[@gabrieleminniti7031]

EXACTLY

[@iiiiii-w8h]

Still no loops tho

[@TheElementFive]

Python is making Excel increasingly archaic and I love it

[@homejonny9326]

@@iiiiii-w8h because it is functional programming where there is no loops. Instead, you use an call to the previous value. And repeat It through the desirable range. There is your loop.

[@stin11111]

you could use VB to code them pretty much the same. it's just inline instead of function now.

[@zeazevedo]

Great and valuable vid. Thanks and stay safe. Greetings from Portugal

[@LeilaGharani]

Thank you!

[@JanWeigangMusic]

YESSSSS!!! Finally. I have benn LONGING for this feature! Awesome showcase/vid as ever!

[@LeilaGharani]

Thanks Jan! 😁

[@wayneedmondson1065]

Hi Leila.. great in-depth summary of the advantages of the LET function. The timing comparisons were particularly interesting. Thanks for sharing your insights. Thumbs up!!

[@TheNabob57]

I have found that most speed improvements are negligible unless dealing with large datasets. The kind of datasets not typically seen in small businesses. BUT, I have always been a fan of making formulas readable understandable at a glance by someone that did not wite the code. I am frustrated sometimes when analyzing someone else's code when they do not use common conventions or make use of named ranges. Most people can understand Assets=Capital - Liabilities easier to read than some combination of summed cells - other summed cells.

[@jwstanley2645]

Thanks for the video. Interesting.

[@arufuponics8415]

Seems to provide the same advantage that naming a separate cell with the % variants and simply referencing it in the formula. The advantage is that you can chance the one cell to another % at will and all calc will happen accordingly.

[@pavangupta2696]

Best channel to learn excel

[@JeremyMcMahan]

I think through some of the crazy 10-line formulas I've written over the years and my mind is blown at how much easier this would/will be!! Thanks for the great work and video Leila!

[@LeilaGharani]

It really can make a difference for these complex formulas.

[@xalidmlikov7322]

@@LeilaGharani How to import live data excel to spreadsheet? Please help me. My e-mail adress is [e-mail]

[@brightlight2860]

Always shining. Thanks 👍

[@LeilaGharani]

Thank you 😊

[@KuchBhiKabhiBhigaming]

are you from India...if yes than its awesome, now we have someone who is compatible with international standards...good job.

[@reddrift3022]

That second example is crazy, I'm guessing because it can grab the complex function from the variable established, instead of reading it each time it is faster; however, when doing small calculations the time to set the variable initially ever so slightly outways the benefit in cost of time. REALLY awesome stuff, can't wait for that official launch.

[@mebanet]

I have a question for you about the LET function and IF/AND function in excel. Unfortunately QuickBooks Online’s invoice options aren’t customizable enough for what I need, so I had to make my own invoice in excel to send to my customers. Recently I have started automating my processes with Power Query and other tips and tricks that I’ve learned from your KZbin channel. The one thing I’m having trouble with is bill rates and holidays. I have 3 bill rates based on the tech level: Tech Level 1 is $65/Hour Tech Level 2 is $75/Hour Tech Level 3 is $85/Hour But if it’s a holiday: Tech Level 1 is $90Hour Tech Level 2 is $100/Hour Tech Level 3 is $110/Hour I have 5 Tech Level 1s, 2 Tech Level 2s and 2 Tech Level 3s On the invoice I have: Date Task Tech Name Hours Rate Sub-Total I’m trying to make the Rate automatically populate with the correct rate based on the date and tech name. I know I can use an If(And, but I have 15 dates throughout the year that are holidays and 9 Techs, that would be a huge formula. Not to mention updates from year to year and as techs come, go or get promoted. I have learned a lot from your channel. It has saved me countless hours a week on backend data entry and allowed me to focus more on jobs that bring money into my company. THANK YOU!!!

[@XDario91]

@leilagharani 12:40 ctrl+backspace to jump back up? for me it selects the whole column instead. And shift+backspace selects the rows. How can I go back up while keeping the selection active as you did? If I use ctrl+up, my selection disappears

[@davidmontague9125]

Excellent video; it had me using LET, with enthusiasm, in no time. I have one issue though. Not to do with LET but you have the VAT rate embedded in a formula; I consider this to be bad practice. VAT can, in theory, change at very short notice. Ideally it would be stored as a global somewhere but more realistically it should be in a cell where it's visible. The same applies to values like income tax rates and thresholds: any constant that isn't constant.

[@ketandave3273]

Very good one. Thanks. This can help on mobile, as apps doesn't give access to Name manager menu.

[@sleepfuzzy]

Thank you for this. This is such a game-changer for me.

[@vida1719]

Great comparison of performance

[@chrism9037]

Awesome video Leila!

[@LeilaGharani]

Thank you! 😁

[@Excelambda]

Great to see speed tests on LET function!!! Think it's the first one out here. Many thanks for that!!. A great advantage of LET is it's kind of portability. We can write a complex formula in one workbook, copying it as a string, pasting it in other workbook , changing only the variables reference addresses , and good to go. No VBA😉

[@LeilaGharani]

Thank you! That's right. It'll make managing workbooks easier.

[@sahilsinghal9472]

👏🏻👏🏻👏🏻👏🏻 this is going to be very useful for complex financial models. Thanks Leila

[@LeilaGharani]

You're so welcome!

[@aimendondo]

Great video tutorial as always! I have been learning a lot from you, Leila! Keep up the great work.

[@LeilaGharani]

Thank you! Will do!

[@jensjohannesandersen1634]

Thank you for another great video! You inspire me

[@gurmeetsingh-cq6br]

Thanks for increasing my interest immensely in learning more

[@s.y.daniel2137]

definitely need this LET in my big data files and long repeated formula elements

[@rarellan0506]

Thank you for your vids! I apply some of your tutorials to the work I do. It’s been a major help!

[@vijayarjunwadkar]

...and then God said, "LET" there be "Leila" and our Excel problems are solved! :-) Thank you for another great video!

[@sanjaysrivastava1100]

That is true !!!😊

[@arindamdutta9371]

😀

[@wasimsuperb]

Thanks for giving such a great opportunity to learn on skillshare..I have no words except you are great and nice as always ...Thanks

[@theedspage]

The LET function reminds me of the LET (L) function for the HP 17BII+ financial calculator.

[@unkchaos2007]

Wow, I just saw a way with your video how I can already improve lots of formulas. I have formulas that is repeated way too often. LET looks like the solution to those sheets of mines, thank you!!!

[@LeilaGharani]

You're so welcome!

[@TheBoxyBear]

Coming from a programming background and only now learning Excel, this is a huge deal.

[@mohammadashiq9996]

thank you leila like let function its simple,

[@khairulidzham3646]

Thanks Leila for the knowledge.

[@krn14242]

Great job as always, thanks Leila.

[@LeilaGharani]

Thank you too!

[@jeanlamoureux7138]

Hi Leila, I have a good excel twister for you, I work in the government and manager can have multiple cost center which is a six digit number that contain funds, in my excel spreadsheet each cost centre is in a separate cell but in the same row as the cost center manager, a cost center manager can have up to 10 cost centres assigned to him, I want to create a vlookup or other function that will allow me to return the name once I input the cost centre number, I have 6500 cost center rows, can you help me? Thanks Jean

[@LeilaGharani]

If you can have multiple managers responsible for a cost center, you can try out the filter function. If it's one to one, an option is to use index and match. Something like: =INDEX(B1:B3,MATCH(1,(C1:C3=G1)+(D1:D3=G1),0)) where G1 is the cost center you're looking up, the C and D columns have cost center #1 and cost center #2 and B column has the names of the managers. If you don't have the new Microsoft 365 version, you might need to use control + shift + enter. You can also add more cost centers. An alternative is to use Power Query.

[@jeanlamoureux7138]

Leila Gharani hi Leila it’s one to 10 cost center for one cost center manager

[@SelvAnPlay]

Why you make my live easier Ms Leila you rock😊

[@ydrexcel-andreasmarinis6569]

Very interesting video!!

[@mohammedhassan2808]

Great finding dear Gharani, Appreciate your dedication to us