My respect for you has always been very deep and I have benefited immensely from your videos for many years now. Thank you Leila for doing what you do. God bless you.
Omg.Your presentation makes easy to learn the complex functions.The thirst to learn Office skills from you keeps bringing me here anytime.Thank you so much.
Thanks Leila. With all of the "newer" dynamic array functions as well as Lambda functions, it really triggers me to evaluate my work flow and spreadsheet design. The largest obstacle preventing a shift is the inability to share files with non MS365 users. Thanks for sharing...
@@LeilaGharani … not forgetting just ‘plain availability’ of those. So far even lambda isn’t generally available, even if you are in a ‘office insider’ channel.
@@stuckcamping Or learn both. Each has pretty distinct use cases. The dynamic UI of Excel is hard work to reproduce in other environments, while the maintainability and portability of SQL are often the most important factor. Use each where they are the natural choice, and even use both together sometimes. And add some Python too for a very solid analytics tripod.
Your content is brilliant Leila, I hope to share my work with you, obviously and it is very clear that I would learn much more from you, but my experience is that you always learn when you share knowledge. Thank you for such quality!!!!!
I have used lambda in a spreadsheet with 16 sheets for different states and product lists. The key formulae were identical except for a couple of parameters. Putting those formulae into lambdas with parameters, removed all the complexity from the worksheet itself. To me, a lambda is the equivalent of what we do when programming. If we find ourself repeating code, we write a separate function for that code and call it when we need it, which is both simpler and safer.
4:13, "just keep it simple", you are great:D thank you for all the updates you made for all of us. All we knew about Excel in the past period needs to be revised.
Leila you are just amazing with your tricks on Excel. This function is surely going to be the game changer for many of the data analysts who struggle so much with different questions and aspects of their data.
Is this wonderful or what😱? I never knew what Lambda was until seeing this video! And these new functions really do simplify the process by preventing copy and pasting of the function. With just one function you can get the output from multiple rows and columns 😎
What I missing is recommendation or examples of what other options there are in Excel, and opinions which is the most practical. But as some one comment - you always up -to-date and professional!
I am watching your channel from Cebu City, Philippines. You are a wonderful teacher. Your lessons are precise, concise, and easily understood. I hope you continue as long as you can. Thank you very much!
I've only started watching your videos a few months ago and already you're one of my favorite youtubers who's taught me so much. This video in particular is exactly what I needed today to solve a complicated problem. Keep it up :)
Yes I will be using this I just opened up a kitchen and have many many different types of of spreadsheets keeping track of different types of data thank you very much
This is awesome… the thing about excel is it has so much functionality that often times you don’t need it, don’t use and forget it even exists! However, no doubt, is super awesome!
Hi, this was very intuitive and am able to process a huge amount data comprising 12,583 rows and 144 columns just in seconds. Great job and thank you so much. My MS Access application is also confirming the same results output.
Another commenter spoke of using these functions along the many other new Excel features to rethink how sheets are designed. I agree and will slowly add these functions to my repertory.
Thank you Leila - well explained with a good example. I had seen byRow and ByCol and suspected they would answer several of my calculation problems in older sheets, and this confirms it.
I can see myself using these to create filterable ranges for graphs. I know there are other ways to make this but this seems easy to make (and more importantly) to maintain.
Dear Leila, I watch all your videos and have learnt a lot of tricks. I doubt I would use these. For example, to get the sum of each column, I would sum the first and drag the result across
I can definitely see some use for them, I don't think I can see them allowing us to do anything we couldn't before but it definitely makes formulas more concise and it's often useful to get an array output rather than how I'd usually do this which is autofill the formula across then filter the information from it separately.
Hi Leila. Interesting functions. Like so many things in EXCEL, the first impression might be "what?", but then you begin to think of ways to use them that simplify what is required without them. Thanks for sharing these examples :)) Thumbs up!!
You are really an inspiration ... I have learnt alot new from your video... Thank you for sharing these kind of videos on regular basis... Great work 👍
Wish my version of Excel would keep up with all the new stuff but alas I sit and wait like a kid waiting for the candy shop to open. As I watched this video I am thinking to myself how would I approach what you did otherwise and I think I've seen you show multiple ways of getting the same result in other videos so it would have been nice to see that in this video. Just food for thought as I think often times some of us need to be able to translate or identify best approach practices. As always, awesome videos. Thanks again!
Thanks Leila, i was not much present for excel things last months (since lambda function release, i guess) and I see lot of new things well explained and very interesting to me in practice. Thank you for that.
Something that I found interesting was that BYCOL returns a range reference and not just an array as I originally expected (which means that COUNTIFS works). Nice presentation.
You can use index function if you use byrow, or just use map or reduce and put in each column as a single parameter. The new tools brought a lot of possibilities and it might take some getting used to because the whole concept of lambda is huge.
Thank u for your informative step by step tips & tricks - (1) how to share screen to do presentation over MS TEAMS and other tips How to print presentations slides within A4 size Look forward to it
Thank you so much for this detailed explanation for each function! I was wondering about this situation… I have a range of numbers that I need to sum so I highlight the whole range and then use BYROW to sum up the ranges for each row. That works like expected. However, I wanted to add an if statement that checks whether the first column is blank or not. If it is, the cell should be blank. If not, it should continue with the summing. You can’t put multiple arrays into BYROW so I didn’t know how to approach this situation. I tried wrapping the BYROW with MAP but that gives me errors. Then I tried doing an ArrayFormula and I got errors. Would you have any suggestions for how I might do this?
Most wonderful explanation. Lelia is back in her original, exceptional and excellent containt (after long time ⌛) Big thank for enhancing the knowledge. Keep it up
Thank you for great explanation. Let’s array has positive and negative numbers. What combination of functions shall I use to know max no. of consecutive positive months ?
Hi Leila, thanks for the video. I love this new Excel formulas, and having Lambda is very appreciated, considering we have it in Python too. Excel is becoming less of a spreadsheet and more of a visual programming language. Unfortunately this also means that the way we input the formulas is becoming problematic to manage this new coding-esque way of programming the sheet. We would need a real editor with beautify functions to split these long formulas in different lines and indent the inner parts for better readability. And also many of the new formulas in my opinion should mimic more the counterpart of the real programming language that inspired them. For example, trying to make an SQL SELECT choosing the desired columns using the FILTER function is a pain... and I can't understand why, as it is the way it should work normally. The VBE also needs a total refresh...
I can't wait to try and promote the lambda functions in my company. Been watching these in your videos for quite a long time, but the lambda functions are still missing in my Excel (currently on 2021-08). Is that normal? Any idea when they will "show up"? Thanks!
My head was spinning like this 🙄 haha. I get the idea behind this but the technical stuff went over my head as you can imagine. I wish you had more courses on LinkedIn learning.
Love your videos. I'm having trouble using data from one tab and pulling it into another tab in tab drop down menus that populate an area when selected.
I strive to watch every one of your videos going foward so I can get really confortable with Excel and not get intimidated by the more complex functions. Thank you Leila for all your videos. By the way, I think you are aging backwards. What is your secret? 😊
Hey. Thanks for teaching these wonderful functions. But why to put a >0 in the include parameter while using filter function? Couldn't understand that part. Kindly help
Grab the file I used in the video from here 👉 pages.xelplus.com/byrow-bycol-file
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
You are a magnificent teacher, who believes in updated technology and shares selflessly.....great stuff
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
My respect for you has always been very deep and I have benefited immensely from your videos for many years now.
Thank you Leila for doing what you do.
God bless you.
Omg.Your presentation makes easy to learn the complex functions.The thirst to learn Office skills from you keeps bringing me here anytime.Thank you so much.
I don't work with excel that much, but every time I see a new video I get so excited.
Thanks Leila. With all of the "newer" dynamic array functions as well as Lambda functions, it really triggers me to evaluate my work flow and spreadsheet design. The largest obstacle preventing a shift is the inability to share files with non MS365 users. Thanks for sharing...
True, that will remain an issue.
@@LeilaGharani … not forgetting just ‘plain availability’ of those. So far even lambda isn’t generally available, even if you are in a ‘office insider’ channel.
Learn SQL, stop using Excel as your data manipulator....
@@stuckcamping I want to, but the biggest stumbling block is configuring SQL and permissions to db, cant over come this
@@stuckcamping Or learn both. Each has pretty distinct use cases. The dynamic UI of Excel is hard work to reproduce in other environments, while the maintainability and portability of SQL are often the most important factor. Use each where they are the natural choice, and even use both together sometimes. And add some Python too for a very solid analytics tripod.
Your content is brilliant Leila, I hope to share my work with you, obviously and it is very clear that I would learn much more from you, but my experience is that you always learn when you share knowledge. Thank you for such quality!!!!!
Needed 3 years to understand the whole stuff... 😇. But Finally got it!
Thanks. Just when I think I know everything about Excel, I can learn 10 more things by watching one of your videos.
I have used lambda in a spreadsheet with 16 sheets for different states and product lists. The key formulae were identical except for a couple of parameters. Putting those formulae into lambdas with parameters, removed all the complexity from the worksheet itself. To me, a lambda is the equivalent of what we do when programming. If we find ourself repeating code, we write a separate function for that code and call it when we need it, which is both simpler and safer.
Which version of MS Office are you using?
4:13, "just keep it simple", you are great:D
thank you for all the updates you made for all of us. All we knew about Excel in the past period needs to be revised.
😁
LET is more. 👌
Leila you are just amazing with your tricks on Excel. This function is surely going to be the game changer for many of the data analysts who struggle so much with different questions and aspects of their data.
Leila, very clear explanation of the function,but most importantly a practical application.
You are gifted in the way you explain subjects. Keep soaring...
Is this wonderful or what😱? I never knew what Lambda was until seeing this video! And these new functions really do simplify the process by preventing copy and pasting of the function. With just one function you can get the output from multiple rows and columns 😎
What I missing is recommendation or examples of what other options there are in Excel, and opinions which is the most practical. But as some one comment - you always up -to-date and professional!
I am watching your channel from Cebu City, Philippines. You are a wonderful teacher. Your lessons are precise, concise, and easily understood. I hope you continue as long as you can. Thank you very much!
Thank you! 😃
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Wow! Something I'll use regularly. I've shared this video with my team. This will save us a ton of time. Thank you SO much.
I've only started watching your videos a few months ago and already you're one of my favorite youtubers who's taught me so much. This video in particular is exactly what I needed today to solve a complicated problem. Keep it up :)
Wow, thank you Tomislav!
The formula bar definitely needs an upgrade now we're writing long complex programming code!
You can manually add lines and indentation, but you're right. I can see it moving to the side soon.
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
I don't have this in my Excel yet. Looks promising. Will definitely use it when it becomes widely available. Thanks for sharing.
Yes I will be using this I just opened up a kitchen and have many many different types of of spreadsheets keeping track of different types of data thank you very much
This is awesome… the thing about excel is it has so much functionality that often times you don’t need it, don’t use and forget it even exists! However, no doubt, is super awesome!
👍
Thanks Leila, for your all effort to share knowledge. 👍👍👍
Hi, this was very intuitive and am able to process a huge amount data comprising 12,583 rows and 144 columns just in seconds. Great job and thank you so much. My MS Access application is also confirming the same results output.
Another commenter spoke of using these functions along the many other new Excel features to rethink how sheets are designed. I agree and will slowly add these functions to my repertory.
👍
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Thank you Leila - well explained with a good example. I had seen byRow and ByCol and suspected they would answer several of my calculation problems in older sheets, and this confirms it.
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Thank you so much. It solved a very tough task for me🎉🎉
Excel is evolving at lightning pace ❤
I can see myself using these to create filterable ranges for graphs. I know there are other ways to make this but this seems easy to make (and more importantly) to maintain.
I got inspired from you and started to take excel classes for school students in my small village. Thank you so much 🥰🥰🥰
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Thanks leila, Lambda is a great revolutionary Function and it saves a lot of Time to me
Dear Leila, I watch all your videos and have learnt a lot of tricks. I doubt I would use these. For example, to get the sum of each column, I would sum the first and drag the result across
We always learn new things with you... Thank you
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Thanks a lot, always your videos are useful to my work. greetings from Chile.
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
I can definitely see some use for them, I don't think I can see them allowing us to do anything we couldn't before but it definitely makes formulas more concise and it's often useful to get an array output rather than how I'd usually do this which is autofill the formula across then filter the information from it separately.
Hi Leila. Interesting functions. Like so many things in EXCEL, the first impression might be "what?", but then you begin to think of ways to use them that simplify what is required without them. Thanks for sharing these examples :)) Thumbs up!!
My pleasure, Wayne!
You are really an inspiration ... I have learnt alot new from your video... Thank you for sharing these kind of videos on regular basis... Great work 👍
I can totally see myself using these functions. Thanks for making this video about them!
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Well presented Maam.. My Fundas in these two functions abs clear now
Great 👍
This is tremendously helpful!! I was literally just trying to figure out a way to create a spreadsheet just like this!
Great! Thank you Leila for yet another helpful video! Lucky to have you as a teacher, stay blessed! 😊👍
Thank you! You too!
Really useful. Will apply wherever necessary
Nice to have you your highness
Sorry for being away that long
You're back! Happy to see your comment again!
I really liked the explanation of the aggregation, transpose however has a different meaning for sound engineering. super vid
Excellent Leila. Thanks for these tips and practical explanation,, Regards !! You are a 'superb' teacher !!
Super interesting, need to go over this a few more times to fully understand. Think this will be very useful for me. Thank you for sharing.
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
Wish my version of Excel would keep up with all the new stuff but alas I sit and wait like a kid waiting for the candy shop to open. As I watched this video I am thinking to myself how would I approach what you did otherwise and I think I've seen you show multiple ways of getting the same result in other videos so it would have been nice to see that in this video. Just food for thought as I think often times some of us need to be able to translate or identify best approach practices.
As always, awesome videos. Thanks again!
Amazing presentation as always!
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
Thanks Leila, i was not much present for excel things last months (since lambda function release, i guess) and I see lot of new things well explained and very interesting to me in practice. Thank you for that.
Hope all well at your end. Thanks for the video. Request you keep creating such informative video for our knowledge 🙏
I will try my best
@@LeilaGharani Thank you Ma'am
Something that I found interesting was that BYCOL returns a range reference and not just an array as I originally expected (which means that COUNTIFS works). Nice presentation.
You can use index function if you use byrow, or just use map or reduce and put in each column as a single parameter.
The new tools brought a lot of possibilities and it might take some getting used to because the whole concept of lambda is huge.
Excellent, clear and looking forward to using.
Thank u for your informative step by step tips & tricks -
(1) how to share screen to do presentation over MS TEAMS and other tips
How to print presentations slides within A4 size
Look forward to it
Interesting!! I don't have a need for this now but I will keep it in the back of my mind as you never know....
Definitely can see myself using these in the future.
It's great learning for me, thank you so much
Thanks Leila. It is amazing. I don’t find Bycol in excel. Is this normal ? What should I do ? Can you advise please ?
New content always.
Thank you for the upload.
We are watching keep up more...
I have 365 apps for business. I hope this version will get the lambda function.
Great video.
Excellent two new functions.
Really clever useful technique, thanks for sharing the new functionality 👍
nice!
excellent, clear demonstration.
Thanks Leila... Good to know info as always.... But ur voice is too sweet and the best
That's Amazing Liela... it's a great solution we were waiting for to sum columns and rows for any array... it's absolutely usefull.
pplpppp
lpp
ppppp
pppp
ppppppppppppppppppppppppp
ppppp
lp
plpppp
ppl
l
ppl
pppppppppppp
plpp
Wonderful. Seems very useful to my jobs. You are the best!
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
Very good explanation leila. Thank you for sharing this with us
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
Particularly useful new functions. Thank you so much Leila.
Glad it was helpful!
I can certainly see a variety of use cases to support me in my role.
Thank you so much for this detailed explanation for each function! I was wondering about this situation… I have a range of numbers that I need to sum so I highlight the whole range and then use BYROW to sum up the ranges for each row. That works like expected. However, I wanted to add an if statement that checks whether the first column is blank or not. If it is, the cell should be blank. If not, it should continue with the summing. You can’t put multiple arrays into BYROW so I didn’t know how to approach this situation. I tried wrapping the BYROW with MAP but that gives me errors. Then I tried doing an ArrayFormula and I got errors. Would you have any suggestions for how I might do this?
U R teaching new lesson to me always Thank you very much & god bless you ma.
It's my pleasure.
Nice, You are my teacher ❤
Thank you! 😃
Most wonderful explanation.
Lelia is back in her original, exceptional and excellent containt (after long time ⌛)
Big thank for enhancing the knowledge.
Keep it up
Surely using it
Thank you for your great explanation
❤❤🙏🙏
Thank you for your updates !
This is great....I see it changing the way i work
Fantastic presentation...
I use tables in excel extensively. (Thanks to you 😀) so when you discuss ranges it would help to describe how to reference the range from a table.
Thank you for great explanation. Let’s array has positive and negative numbers. What combination of functions shall I use to know max no. of consecutive positive months ?
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
remarkable tuto , thank you Leila
Hi Leila, thanks for the video. I love this new Excel formulas, and having Lambda is very appreciated, considering we have it in Python too. Excel is becoming less of a spreadsheet and more of a visual programming language. Unfortunately this also means that the way we input the formulas is becoming problematic to manage this new coding-esque way of programming the sheet. We would need a real editor with beautify functions to split these long formulas in different lines and indent the inner parts for better readability. And also many of the new formulas in my opinion should mimic more the counterpart of the real programming language that inspired them. For example, trying to make an SQL SELECT choosing the desired columns using the FILTER function is a pain... and I can't understand why, as it is the way it should work normally. The VBE also needs a total refresh...
Many thanks for your feedback!
Great work Leila, l can say it has some value here, this function. Keep it going.
I can't wait to try and promote the lambda functions in my company. Been watching these in your videos for quite a long time, but the lambda functions are still missing in my Excel (currently on 2021-08). Is that normal? Any idea when they will "show up"? Thanks!
Unfortunately yes. They’re still not generally available. Hopefully soon though.
My head was spinning like this 🙄 haha. I get the idea behind this but the technical stuff went over my head as you can imagine. I wish you had more courses on LinkedIn learning.
Wow... Nice to know this Information on first hand... 👌
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
Thank you very much for the video tutorials.
Wonderful, thanks for sharing your knowledge...
I am going to update various spreadsheets thanks to you!
Great...thank you as always. Function is surely going to be useful.
Great videos, you should do a short on copying totals of the range selected by using on the bottom bar. Not well known.
Great video. Very helpful. Will definitely use it
very good tip LEYLA thanks, greetings from Mexico
Love your videos. I'm having trouble using data from one tab and pulling it into another tab in tab drop down menus that populate an area when selected.
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
lambda and let functions are game changers
Thx Leila ! I improve my english and my excel so that perfect for me !!!!
Great innovative work
I strive to watch every one of your videos going foward so I can get really confortable with Excel and not get intimidated by the more complex functions.
Thank you Leila for all your videos. By the way, I think you are aging backwards. What is your secret? 😊
Awesome, regards from Cali-Colombia
Thanks, Great tutorial. I have many applications for these functions
Hey. Thanks for teaching these wonderful functions. But why to put a >0 in the include parameter while using filter function? Couldn't understand that part. Kindly help