Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...

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: https://pages.xelplus.com/byrowbycol...

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: https://techcommunity.microsoft.com/t...

★★★ My Online Excel Courses ► https://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: https://xelplus.creatorspring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/

RESOURCES I recommend: https://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