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.
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.
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!!!!!
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.
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 😎
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.
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 :)
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.
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
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!
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.
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
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.
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.
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 👍
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!!
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 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.
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
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
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!
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.
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? 😊
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.
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.
Great video!! Great Functions!!✌ Also these : =TRANSPOSE(FILTER(B4:M4,BYCOL(B5:M11,LAMBDA(a,OR(a>1500))))) =FILTER(A5:A11,BYROW(B5:M11,LAMBDA(a,OR(a>1500))))
Thank you. Your videos are brief and to the point hence I find them very useful. I got a question on a different topic. How can I plot more than 255 lines on same chart? Grateful if you could help here please. Thank you.
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...
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.
This could be quite useful. I work in a manufacturing facility where we have instruments that return large amounts of instrument-generated data in either CSV or XLS format. One of my jobs is to take the data and extract useful performance and/or analytical information from it. I could see using these functions in some of my reports.
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
that is awesome, soooo useful. Can't wait to share this video with my work colleagues. I may never get used to the function being called "BYROW" .... too similar to my name! 🤣
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.
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?
Needed 3 years to understand the whole stuff... 😇. But Finally got it!
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. 👌
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 don't work with excel that much, but every time I see a new video I get so excited.
Thanks. Just when I think I know everything about Excel, I can learn 10 more things by watching one of your videos.
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.
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 😎
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.
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
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'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!
You are gifted in the way you explain subjects. Keep soaring...
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.
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
Leila, very clear explanation of the function,but most importantly a practical application.
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!
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, Lambda is a great revolutionary Function and it saves a lot of Time to me
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.
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.
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
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.
Thanks Leila, for your all effort to share knowledge. 👍👍👍
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
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 don't have this in my Excel yet. Looks promising. Will definitely use it when it becomes widely available. Thanks for sharing.
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!
Thank you so much. It solved a very tough task for me🎉🎉
Thanks!
Thank you!
@@LeilaGharani i always get to learn something new from your video, so special thanks to you for sharing knowledge
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
Thanks a lot, always your videos are useful to my work. greetings from Chile.
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
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
Well presented Maam.. My Fundas in these two functions abs clear now
Great 👍
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.
Excellent Leila. Thanks for these tips and practical explanation,, Regards !! You are a 'superb' teacher !!
Nice to have you your highness
Sorry for being away that long
You're back! Happy to see your comment again!
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
15 M wow congratulations
I am following you when 2k followers you have
I am a big fan
And you are our Superwoman
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
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
Excel is evolving at lightning pace ❤
We always learn new things with you... Thank you
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
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....
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
U R teaching new lesson to me always Thank you very much & god bless you ma.
It's my pleasure.
Thanks Leila... Good to know info as always.... But ur voice is too sweet and the best
Very good explanation leila. Thank you for sharing this with us
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
I can totally see myself using these functions. Thanks for making this video about them!
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=QmCZIYf9APabszKC
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
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.
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!
This is tremendously helpful!! I was literally just trying to figure out a way to create a spreadsheet just like this!
I really liked the explanation of the aggregation, transpose however has a different meaning for sound engineering. super vid
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.
Amazing presentation as always!
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
Thanks
Thank you!
It's great learning for me, thank you so much
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? 😊
Great! Thank you Leila for yet another helpful video! Lucky to have you as a teacher, stay blessed! 😊👍
Thank you! You too!
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.
Excellent, clear and looking forward to using.
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
Really useful. Will apply wherever necessary
Great video!! Great Functions!!✌ Also these :
=TRANSPOSE(FILTER(B4:M4,BYCOL(B5:M11,LAMBDA(a,OR(a>1500)))))
=FILTER(A5:A11,BYROW(B5:M11,LAMBDA(a,OR(a>1500))))
LOVE IT! Thanks 👍
Thx Leila ! I improve my english and my excel so that perfect for me !!!!
Nice, You are my teacher ❤
Thank you! 😃
Great work Leila, l can say it has some value here, this function. Keep it going.
Thanks Leila your videos are great; but you know how can I paste formula only in visible cells?? A lot of thanks for your comment!!
nice!
excellent, clear demonstration.
Definitely can see myself using these in the future.
very good tip LEYLA thanks, greetings from Mexico
Wonderful. Seems very useful to my jobs. You are the best!
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
Thank you. Your videos are brief and to the point hence I find them very useful.
I got a question on a different topic. How can I plot more than 255 lines on same chart? Grateful if you could help here please. Thank you.
Thank you for your great explanation
❤❤🙏🙏
Mind blown, came back to this vid today as opportunity to use this came up. So ggod
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
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.
Wow... Nice to know this Information on first hand... 👌
ua-cam.com/video/Rp1BkCIb3o0/v-deo.htmlsi=vArhiR0iShJK6oxI
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!
Particularly useful new functions. Thank you so much Leila.
Glad it was helpful!
Wonderful, thanks for sharing your knowledge...
Great...thank you as always. Function is surely going to be useful.
Really clever useful technique, thanks for sharing the new functionality 👍
This is great....I see it changing the way i work
Great video. Very helpful. Will definitely use it
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.
I can certainly see a variety of use cases to support me in my role.
I am going to update various spreadsheets thanks to you!
This could be quite useful. I work in a manufacturing facility where we have instruments that return large amounts of instrument-generated data in either CSV or XLS format. One of my jobs is to take the data and extract useful performance and/or analytical information from it. I could see using these functions in some of my reports.
Definitely something I'd use but like INDEX & MATCH it will just take a bit of practice!!
Thanks Leila. It's really helpful function
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
Great info. I will definitely be using these new functions. Thank you Leila!
Glad it was helpful!
that is awesome, soooo useful. Can't wait to share this video with my work colleagues.
I may never get used to the function being called "BYROW" .... too similar to my name! 🤣
Hope your colleagues will find it useful.
Great videos, you should do a short on copying totals of the range selected by using on the bottom bar. Not well known.