Try This New Formula Instead of Pivot Tables | You DON'T Need Pivot Tables Anymore

Рет қаралды 40,895

Күн бұрын

Try This New Formula Instead of Pivot Tables | You DON'T Need Pivot Tables Anymore
#exceltips #msexcel #pivottables #computergyanguruji
Our second channel
@ComputerGurujiTechnical
@GurujiComputerCourse
Time line
00:00 Intro
01:13 Pivot Tabel Vs Groupby function
03:09 Add percentof in Pivot table and groupby function
04:59 Item wise quantity sold
05:46 Region wise quantity sold
06:20 Month wise total items quantity sold
07:03 Month wise total region quantity sold with column distance using choose function
08:23 Month wise total items quantity sold with filter_array parameter like pivot table
10:39 Total_depth parameter in groupby formula
12:35 feild_headers parameter in groupby function
15:30 sort_order parameter in groupby function
Follow us on
Telegram
t.me/computergurujitechnical
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
Excel Conditional formatting
• Excel Conditional form...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
JAVA
• JAVA Script
PHP
• PHP
Python
• Python
Photoshop
• Photoshop
Full Tutorial
• Full Tutorial
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Google Sheet
• google sheet
Invoice in Excel
• Invoice In excel
Reasoning
• Reasoning
Airthmatics
• Airthmetic

Пікірлер: 48

@foziasharifmalik6657 15 сағат бұрын

Great 👍

@karanthapa71176 Ай бұрын

Bahut Bahut Aabhar Sir 🙏 aapse bahut kuch sikhne ko mil rha hai. Aapke explain karne ka trika bhi bahut saral aur aasan hota hai.

@2211sdm 28 күн бұрын

@computer gyan Guruji यह function बहोत useful लग रहा है…thank you आपने इसका video post किया 🙏🙏🙏🙏

@KamleshYadav-vs4yw Ай бұрын

Very useful

@muhammadhanifsoomro3166 Ай бұрын

Sir this video excellent ۔۔

@pandharinathjoshi6565 Ай бұрын

Excellent sir

@bijaytanty8434 Ай бұрын

Thanks Sir

@PritamPaul717 Ай бұрын

Thank you so much sir

@JainudinAnsari-zv4wo Ай бұрын

very good❤

@aqeelawan8634 Ай бұрын

Sir you are very very intelligent man ❤❤

@anilshirashyad 12 күн бұрын

awesome

@pandharinathjoshi6565 Ай бұрын

Sir how can use slicer for using groupby function sir

@Adityasshenoy-rw4ox Ай бұрын

Hi sir pls upload remaining chapter's of dsta analysis using excel ❤

@Mamamadhu24 Ай бұрын

❤

@Jkdkol Ай бұрын

Ur process is meant for experts

@SMuralidhar 19 күн бұрын

Hi Sir this is really very help full but kindly let us know how to use this formula in excel 2010

@rajumanm 22 күн бұрын

sir namaskaar. please make a video of MS Project

@sunilnaturebeautyhealthfit7144 19 күн бұрын

Sir ji sample file ka link bhi provide krdiya kro bht useful hoga..

@arnabjanacreation8583 28 күн бұрын

sir its available in office 2021

@NaveenKumar-ic1ky Ай бұрын

Sir function acha hai par aap ne qty se run karaye price wala colum select nahi kya pls detail kar , thx

@muhammadtariqmayo1630 Ай бұрын

Sir 2 data source ko pivot table me 1 timeline se control karna chata hon

@chandrasekhardindukurthi 7 күн бұрын

Very nice; however, Pivot tables are made to use at easy and single mouce click help; this formulas are meant to professionals

@actionmoviez3405 25 күн бұрын

Funcatin se accha to hum slicer use kar wo best hoga aur view bhi accha lagta hai

@gajendrasingh9486 16 күн бұрын

Sir excel ke konse version me lagega

@user-hx8ub1eu6t Ай бұрын

This function available in which ms office

@uchil2007 10 күн бұрын

No use of studing a function which is not available in office 365. Not available till july 24?

@rajkumarjain3697 Ай бұрын

I'm updating it from time to time but don't find this functions

@muhammadhanifsoomro3166 Ай бұрын

Sir koi bhi data PDF karna ho aur lastrow change hota rahey to isko PDF VBA mein kaisy generate karen۔۔

@sandeshkadam7937 Ай бұрын

multiple filter kaise karenge

@nandu837 Ай бұрын

Sir, Groupby function not found in XL how to install ? Pl suggest.

@adila1435 Күн бұрын

mere bhi excel me nahi aa raha hai

@rizwanamin3129 Ай бұрын

Group by formula not available in online excel 365

@rajkumarjain3697 Ай бұрын

Unable to locate this function in my office 365

@GauravSharma-iu5mr 16 күн бұрын

Group by function is not showing in office 365

@hotbreakseries8326 Ай бұрын

Hi sir mere me group by formula nhi aa rha hai window 365 chala rha hu

@adila1435 Күн бұрын

ye function mere excel per nahi aa raha hai

@goluchouksey2794 Ай бұрын

Sir, acha hai per itna formula kon yad rakhega

@bharatbhushan7772 27 күн бұрын

I think it is available in office 2021 or Office 365

@sakenderali1415 14 күн бұрын

Only Office 365

@ravichandra5763 Ай бұрын

Pivot table is very simple than this

@2211sdm 28 күн бұрын

Agreed Sir, but pivot table has its limitation. Probably why are we thinking the ease of pivot is because we are using this since ages. Let’s explore more of this GroupBy function. But I agree with your point as well