Don't use Pivot in Excel‼️Instead Use Amazing function #excel #exceltricks #exceltutorial #shorts

In this video, you will learn how to use groupby function instead of pivot tables in excel.

This function is available only in Excel 365.

#exceltech #exceltips #exceltutorial #excel #exceltricks #excelhacks #excelformulas #excelfunctions #excelseries #day1excel #excellearn #learnexcel #excelforbeginners #microsoftexcel #msexcel #shortvideo #shorts #excelshorts #excelcourse #dataanalysis #analytics #dataanalyticscourse #analysis #excelhacks #excelshortcuts #pivot #pivottables #groupby #excel365

[DavidBTB]

😮 Ctl-Backspace is the real star here. Thank you!

[jaythevitaminjay]

Great tutorial but can we please don't say "Don't use Pivot table", pivot table is a powerful feature that offers deeper analysis in excel and it is incomparable to other excel functions.

[as]

Group by function available in a advance updated Excel only

[kamalshrestha]

You got me with don't use pivot table. You are talking David vs Goliath.😊

[AdityaPatel-dnof]

I'm sharing this link for my friends

[ChopLancer]

I like this, nice solition when a pivot table is overkill. Ctrl+Backspace though!?!? Ima use that!

[drog]

Pivot tables give you way more of a breakdown with just 1 click. But this is a good alternative.

[vikasprajapat]

Great but pivot another option include so best pivot table always

[mojar]

now make a video "dont use function, instead use pivot table"

[sundarraj]

Good formula, But in Pivot I can bring no of staffs - Dept wise in same table. How to do it in this ???

[pervaizakhter]

it is good but what is version Excel to do.

[anshunath]

Y not use pivot table?
Does it cost extra to use?

[mtc-ji]

Does it update automatically when you change values in tables? That’s the one thing about pivot tables that I hate - you have to go in and refresh data.

[hustlinhitch]

I take it groupby is a newer function?

[Ribeye]

If there is a change in data, can I refresh this group by function table?

[salmanurjuwita]

Sir, if my laptop do not support =groupby
Then, how i doing this? Just pivot table?

[damionc]

Can I use slicers with this. What happens when I want to build a dashboard?

[Annavajjhula]

Is there a way in menu option to click on group by option instead of writing formula?

[rgl]

Clickbait. This video's title is at most "an alternative to pivot table". But calling this "don't use"? Absolutely not. Pivot table can do a lot more that GROUPBY.

[kashu]

does it work in "office 2024 ltsc"