You DON'T Need Pivot Tables Anymore... Try GroupBy and PivotBy Instead!

Рет қаралды 12,361

Ай бұрын

Tired of struggling with Pivot Tables in Excel? Discover a better way to analyze your data using the powerful GroupBy and PivotBy formulas! In this video, we'll show you how to easily replace Pivot Tables with these efficient formulas, simplifying your workflow and saving you time. Whether you're a beginner or an experienced Excel user, this tutorial will help you take your data analysis skills to the next level. Don't miss out these game-changing new groupby and pivotby formulas in excel 💡📊 #ExcelTips #DataAnalysis #GroupBy #PivotBy #ExcelFormulas #ProductivityHacks #ExcelTutorial
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Download Training File : bit.ly/4eeHwGx
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld

Пікірлер: 49

@arunkumarsinghark3024 Ай бұрын

बहुत सुन्दर जानकारी मिला l 🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹 सीखते रहो, सिखाते रहो l हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

@rahulamesar5387 Ай бұрын

Underrated channel with best and simple but useful knowledge. Thank you sir

@amitrelan3795 Ай бұрын

Deepak ji , great formula , maja aa gaya learn karne m❤❤❤

@sanjayparihar641 Ай бұрын

You always rocking sir ji 🙏🏻

@manojkulkarni6749 Ай бұрын

Thank you sir

@ajayshivpuje3797 Ай бұрын

Always nice 💯

@sharmaanita687 24 күн бұрын

You are just awsome

@VIPIN4261 Ай бұрын

Thanks

@ehsason_ki_diary_se Ай бұрын

Excel ka mahasagar ❤

@user-kp5po1wp1l Ай бұрын

Nice 👍👍

@devidaskulkarni6997 Ай бұрын

Super

@radhekrsna007 Ай бұрын

Genius

@mukundraverkar4009 Ай бұрын

Sir is this function available in office 365

@nandu837 Ай бұрын

Sir, the Function (Groupby) is showing in exl. Any option?

@kawmalmustafa1537 Ай бұрын

Good morning

@vishaldhuri9334 Ай бұрын

Is it release by microaoft or still in beta version

@jamaateislamiadofficial Ай бұрын

Auto generated invoice number kaise lock kare, lock ke number generate hote rahe.

@dreamparadise1520 17 күн бұрын

Hi Deepak. Sir, mujhay aik problem aa rahi hai "Pivot Table" mai, mai nai aik accounts data banaya magar jab mai "Pivot Table" mai "Debit / Credit" ko values mai drag & drop karta ho to "Pivot Table" wahan "Sum" ki jagah "Count" show karta hai mai nai vidoes youtube pai dekh kai woh empty cell mai "0" bhee laga kai dekha par problem solve nahin ho raha hai, can you help me please. -B. Regards.

@AnkitKumar-uq9gj Ай бұрын

Hello sir

@Abhishek951989 Ай бұрын

will ot work on excel 2016

@AnkitKumar-uq9gj Ай бұрын

Sir ye Jo लिंक है इसको अपनी आसान भाषा में वीडियो बनाओ न plz 🙏 full tutorial

@amitrelan3795 Ай бұрын

❤❤❤❤

@bhavinminaxi3339 Ай бұрын

Sir, Meri company me Excel 365 hi he lekin ye formula nahi aa raha he Kai bar update Kiya but nahi aa raha

@bijaykumardhal3581 Ай бұрын

This formula is available in Microsoft beta version so that it's not showing in MS365

@user-yk5jw6qy6t Ай бұрын

I am from Pakistan but I love you bro ❤

@radhekrsna007 Ай бұрын

The function not showing in my online onedrive account

@asharamnishad1527 Ай бұрын

kis office me support krta h guru ji

@as8401 Ай бұрын

Aflatuuuuuuuun...... Sir ji....

@ICTNuggets Ай бұрын

Deepak G, I am using latest version of office 365 but my excel does not have these two formulas. What could be the reason?

@Office-Monk Ай бұрын

Update your Ms Office

@vishaldhuri9334 Ай бұрын

It is release only in MS beta version...yet to release

@Radhakrishna58202 Ай бұрын

Groupby and pivotby is not showing in my MS excel

@ramnaslai2980 Ай бұрын

Great video sir, but still I feel Pivot table is the easy one

@vishaldhuri9334 Ай бұрын

But in pivote table if you add any data in source then you have to refresh pivote table....in groupby and pivoteby the table is automatic update

@ramnaslai2980 Ай бұрын

@@vishaldhuri9334 Small process - right click and refresh.

@vishaldhuri9334 Ай бұрын

@@ramnaslai2980 that I know....but sometimes due to workload or multitasking that small task we forget

@aurangzebkhan6542 Ай бұрын

Yar Excel tutorial kab ah raha hai

@pubglover6784 20 күн бұрын

Sir ye formula excel ke har version me mil jayega ya nahi

@chandanpradhan8613 18 күн бұрын

Only 365 office

@Aptitude360 Ай бұрын

Good not bad sir but Pivot Table is still best to use Practically.

@rajkumarjain3697 Ай бұрын

Unable to locate these functions

@rajsahu1029 Ай бұрын

My Office 365 family have no these formulas

@as8401 Ай бұрын

Sir This formula are not found in my Excel sheet why??????

@AftabAhmed-uw4ki Ай бұрын

Because you're not updating version in excel 🙋🙋🙋🙋

@AftabAhmed-uw4ki Ай бұрын

Because you're not updating version in excel 🙋🙋🙋🙋

@as8401 Ай бұрын

@@AftabAhmed-uw4ki sir how to update it

@kceonline23 Ай бұрын

Are baba copy paste me itna late !!! Pehele se koi banaya Hey

@aurangzebkhan6542 Ай бұрын

Yar Excel tutorial kab ah raha hai