NEW Excel Functions - GROUPBY and PIVOTBY [with a Complete Guide]

[@ChethanaPixel]

Glance of this video with Time Stamps: Click on the time to directly go to specific topic 🙋‍♂ Comment your favourite function. 00:00 Introduction to #GROUPBY and #PIVOTBY 00:41 #GROUPBY with all arguments/parameters 05:00 #PIVOTBY with all arguments/parameters 08:36 Bonus trick for #PIVOTBY 09:44 Wrap-Up

[@ChethanaPixel]

XLOOKUP with 8 Amazing Scenarios: kzbin.info/www/bejne/anKooGmcfbOmetk Hand Drawn Charts in Excel: kzbin.info/www/bejne/o2S8mJaAZdJ7fJY Python in Excel Part 1: kzbin.info/www/bejne/eKq0hauebbJknKc Python in Excel Part 2: kzbin.info/www/bejne/e4mWk6Z3Ytejg9k Power Query Series: kzbin.info/aero/PLAJojq_HX3tYVVd0bT42Qsu0GwFa9z5-9

[@iftekharraju318]

Many many thanks❤❤

[@dillibabu3923]

These new functions are really most powerful and useful. Thanks for sharing 🤝

[@ChethanaPixel]

Thanks Dilli for finding it useful. So nice of you 😊

[@RaghavPhani-ec8oe]

Thanks a lot for sharing. Explained in very detailed about all arguments. Thanks a million again 🤝😄😄😄

[@ChethanaPixel]

Thanks a million ☺️

[@JenitaJoel]

Thanks Chethan Pixel to explain these two amazing functions in detail with Bonus as well 🤝

[@ChethanaPixel]

Thank you very much 😊

[@Cipher6i8]

Excel becoming SQL overnight lol. Great tutorial.

[@ChethanaPixel]

Thank you very much for your valued feedback. So nice of you 😊

[@k.naresh-bv4dg]

Nice explanation

[@ChethanaPixel]

Thanks a lot. So nice of you ☺️ 💕

[@gospelmoto2833]

That was awesome. Thanks for upgrading my knowledge in MS Excel.

[@ChethanaPixel]

Thanks for watching and for your kind words. Please SUBSCRIBE to our channel for more latest updates. 🤝

[@erikguzik8204]

Thank you for the great video. When the FILTER() function came out, it was my go-to function to solve many things in excel. I think GROUPBY() is now going to be my new favorite very soon. These functions are awesome, as is your bonus tip.

[@ChethanaPixel]

Thanks a lot Erik for awesome comments. So nice of you 😊

[@murugankuppusamy9411]

For the first time I have seen your video and very much impressed by the way you explained in simple language.❤

[@ChethanaPixel]

Thank you so much and so nice of you. Request you to please SUBSCRIBE and support us 🙏

[@ChethanaPixel]

Hi, Here is another master piece, you may be interested in kzbin.info/www/bejne/d6ndZ6yOrKZoj5Y

[@ubaidillahmuhammad20]

Nice. Give the file in the description video

[@ChethanaPixel]

Ok sure. next time will upload it. Thanks for watching ☺️

[@adbapatla940]

wher i find this groupby funcion

[@ChethanaPixel]

If you have office 365, you can find it. Thanks for watching ☺️

[@k.naresh-bv4dg]

How to get groupby pivotby formula in Excel

[@ChethanaPixel]

You need to enable Beta version in Office 365. Thanks a lot for watching and keep watching ☺️

[@soundaryasuresh1845]

It is only available in beta version sir. When will it be available in normal version 365 sir

[@ChethanaPixel]

You are right. It is in testing version in Beta channel and will be available soon. Thanks for watching. Please stay tune to our channel 🤝

[@soundaryasuresh1845]

@ChethanaPixel thank you sir for the video 🙏

[@adbapatla940]

where i found it office 365

[@ChethanaPixel]

You have to upgrade the MS Office to Office 365. Thanks a lot for watching ☺️