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
@ChethanaPixel11 ай бұрын
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
@iftekharraju3189 ай бұрын
Many many thanks❤❤
@dillibabu392310 ай бұрын
These new functions are really most powerful and useful. Thanks for sharing 🤝
@ChethanaPixel10 ай бұрын
Thanks Dilli for finding it useful. So nice of you 😊
@RaghavPhani-ec8oe10 ай бұрын
Thanks a lot for sharing. Explained in very detailed about all arguments. Thanks a million again 🤝😄😄😄
@ChethanaPixel10 ай бұрын
Thanks a million ☺️
@JenitaJoel11 ай бұрын
Thanks Chethan Pixel to explain these two amazing functions in detail with Bonus as well 🤝
@ChethanaPixel11 ай бұрын
Thank you very much 😊
@Cipher6i87 ай бұрын
Excel becoming SQL overnight lol. Great tutorial.
@ChethanaPixel7 ай бұрын
Thank you very much for your valued feedback. So nice of you 😊
@k.naresh-bv4dg6 ай бұрын
Nice explanation
@ChethanaPixel6 ай бұрын
Thanks a lot. So nice of you ☺️ 💕
@gospelmoto283311 ай бұрын
That was awesome. Thanks for upgrading my knowledge in MS Excel.
@ChethanaPixel11 ай бұрын
Thanks for watching and for your kind words. Please SUBSCRIBE to our channel for more latest updates. 🤝
@erikguzik820410 ай бұрын
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.
@ChethanaPixel10 ай бұрын
Thanks a lot Erik for awesome comments. So nice of you 😊
@murugankuppusamy941110 ай бұрын
For the first time I have seen your video and very much impressed by the way you explained in simple language.❤
@ChethanaPixel10 ай бұрын
Thank you so much and so nice of you. Request you to please SUBSCRIBE and support us 🙏
@ChethanaPixel10 ай бұрын
Hi, Here is another master piece, you may be interested in kzbin.info/www/bejne/d6ndZ6yOrKZoj5Y
@ubaidillahmuhammad209 ай бұрын
Nice. Give the file in the description video
@ChethanaPixel9 ай бұрын
Ok sure. next time will upload it. Thanks for watching ☺️
@adbapatla9409 ай бұрын
wher i find this groupby funcion
@ChethanaPixel9 ай бұрын
If you have office 365, you can find it. Thanks for watching ☺️
@k.naresh-bv4dg6 ай бұрын
How to get groupby pivotby formula in Excel
@ChethanaPixel6 ай бұрын
You need to enable Beta version in Office 365. Thanks a lot for watching and keep watching ☺️
@soundaryasuresh184511 ай бұрын
It is only available in beta version sir. When will it be available in normal version 365 sir
@ChethanaPixel11 ай бұрын
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 🤝
@soundaryasuresh184511 ай бұрын
@ChethanaPixel thank you sir for the video 🙏
@adbapatla9409 ай бұрын
where i found it office 365
@ChethanaPixel9 ай бұрын
You have to upgrade the MS Office to Office 365. Thanks a lot for watching ☺️