How You Can Actually Use the NEW Excel BYROW & BYCOL Functions
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Have you used the new Excel BYROW and BYCOL functions? Microsoft released new Excel Lambda Helper Functions. In this video I'll introduce 2 of these functions and how you can use them with a practical example: BYROW and BYCOL.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/byrow-bycol...
These functions are great if your analysis is based on entire rows and columns. For example if you'd like to count how many times you went over target value and the target value is in rows or columns. Or you'd like to sum the values in a row or column if the value is over a certain threshold. For these cases you can use BYROW and BYCOL. They're actually easy Excel functions to use. The last argument for lambda can seem confusing but it's basically any function you want to use on the entire row or column. This video will give you some ideas.
Availability & announcement from Microsoft: techcommunity.microsoft.com/t...
★★★ My Online Excel Courses ► www.xelplus.com/courses/
00:00 New LAMBDA functions available in Microsoft Excel
00:53 How to Use Excel BYCOL Function
05:55 How to Use Excel BYROW Function
07:24 Wrap Up
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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!
#excel
Пікірлер: 459
Grab the file I used in the video from here 👉 pages.xelplus.com/byrow-bycol-file
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
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.
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!!!!!
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.
You are a magnificent teacher, who believes in updated technology and shares selflessly.....great stuff
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
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.
This is tremendously helpful!! I was literally just trying to figure out a way to create a spreadsheet just like this!
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.
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 :)
@LeilaGharani
2 жыл бұрын
Wow, thank you Tomislav!
Thank you for your updates !
You are gifted in the way you explain subjects. Keep soaring...
Excellent, clear and looking forward to using.
Really useful. Will apply wherever necessary
I don't work with excel that much, but every time I see a new video I get so excited.
nice! excellent, clear demonstration.
Thanks Leila, for your all effort to share knowledge. 👍👍👍
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.
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 😎
Leila, very clear explanation of the function,but most importantly a practical application.
Thank you very much for the video tutorials.
This is insanely good! Thank you Leila!!!
Excellent two new functions.
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.
@LeilaGharani
2 жыл бұрын
😁
@spilledgraphics
2 жыл бұрын
LET is more. 👌
Great video. Very helpful. Will definitely use it
remarkable tuto , thank you Leila
It's great learning for me, thank you so much
Thanks Leila, so great!
I don't have this in my Excel yet. Looks promising. Will definitely use it when it becomes widely available. Thanks for sharing.
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.
@akyadav080yadav8
26 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=QmCZIYf9APabszKC
great functions ... muchas gracias Leila!!
Thanks. Just when I think I know everything about Excel, I can learn 10 more things by watching one of your videos.
Excellent Leila. Thanks for these tips and practical explanation,, Regards !! You are a 'superb' teacher !!
Thank you for your great explanation ❤❤🙏🙏
Great innovative work
Fantastic presentation...
Thanks leila, Lambda is a great revolutionary Function and it saves a lot of Time to me
I really liked the explanation of the aggregation, transpose however has a different meaning for sound engineering. super vid
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
Particularly useful new functions. Thank you so much Leila.
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
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 👍
Thanks for sharing! 👍
This is great....I see it changing the way i work
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.
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!
Thanks Leila, I will definitely be using these functions.
Thanks Leila. It's really helpful function
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.
@jscomputergenius3834
Жыл бұрын
Which version of MS Office are you using?
Excellent video and yes I will definitely use it.
Great! Thank you Leila for yet another helpful video! Lucky to have you as a teacher, stay blessed! 😊👍
@LeilaGharani
2 жыл бұрын
Thank you! You too!
Great. Thank you.
Great work Leila, l can say it has some value here, this function. Keep it going.
Great...thank you as always. Function is surely going to be useful.
Wonderful, thanks for sharing your knowledge...
New content always. Thank you for the upload. We are watching keep up more...
Extremely new function. Thanks.
Awesome, regards from Cali-Colombia
Excellent video, i think I'll use this functions
Extra work setting up, great results.
very good tip LEYLA thanks, greetings from Mexico
good function and great explation
Really clever useful technique, thanks for sharing the new functionality 👍
Very useful information
brilliant, I can't wait to try this
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.
@akyadav080yadav8
26 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=QmCZIYf9APabszKC
Thank you so much!
Thanks, Great tutorial. I have many applications for these functions
Definitely will be using them,
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.
Very good explanation leila. Thank you for sharing this with us
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
Awesome 👌, thanks 😊
Excel is evolving at lightning pace ❤
Definitely can see myself using these in the future.
We always learn new things with you... Thank you
@akyadav080yadav8
26 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=QmCZIYf9APabszKC
Thanks a lot, always your videos are useful to my work. greetings from Chile.
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
I am going to update various spreadsheets thanks to you!
Your are an ANGEL Leila. I need this function like this for an array. thank you
Thank you very helpful Maybe in the near future
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.
i definitely would use this soon....that was cool!!
Wonderful. Seems very useful to my jobs. You are the best!
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
awesome stuff...
Amazing presentation as always!
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
Great info. I will definitely be using these new functions. Thank you Leila!
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
Mind blown, came back to this vid today as opportunity to use this came up. So ggod
Amazing 😃, really appreciate the idea 😉 I'm sure I'm gonna use it a lot 😎 thank you Leila you're my best 🤗
@LeilaGharani
2 жыл бұрын
I'm glad you like it.
Well presented Maam.. My Fundas in these two functions abs clear now
@LeilaGharani
Ай бұрын
Great 👍
🤯 Thanks, Leila!
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
2 жыл бұрын
True, that will remain an issue.
@forgetittube5882
2 жыл бұрын
@@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
2 жыл бұрын
Learn SQL, stop using Excel as your data manipulator....
@medasbabu
2 жыл бұрын
@@stuckcamping I want to, but the biggest stumbling block is configuring SQL and permissions to db, cant over come this
@LeoLopesLL
2 жыл бұрын
@@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 can totally see myself using these functions. Thanks for making this video about them!
@akyadav080yadav8
26 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.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....
Thanks Leila... Good to know info as always.... But ur voice is too sweet and the best
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!!
@LeilaGharani
2 жыл бұрын
My pleasure, Wayne!
Hope all well at your end. Thanks for the video. Request you keep creating such informative video for our knowledge 🙏
@LeilaGharani
2 жыл бұрын
I will try my best
@taizoondean689
2 жыл бұрын
@@LeilaGharani Thank you Ma'am
The formula bar definitely needs an upgrade now we're writing long complex programming code!
@GustavoSoares
Жыл бұрын
You can manually add lines and indentation, but you're right. I can see it moving to the side soon.
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
U R teaching new lesson to me always Thank you very much & god bless you ma.
@LeilaGharani
2 жыл бұрын
It's my pleasure.
Very helpful ممنون 🙏
Wow... Nice to know this Information on first hand... 👌
@ramkishoryadav9087
27 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=vArhiR0iShJK6oxI
Pretty cool. Can't immediately think of a use case though. Maybe one day 😎
Super and thanks for the detailed explanation
@LeilaGharani
2 жыл бұрын
Welcome 😊
@akyadav080yadav8
26 күн бұрын
kzread.info/dash/bejne/hKRlpM18ecWZn5M.htmlsi=QmCZIYf9APabszKC