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

Рет қаралды 21,876

Күн бұрын

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

Пікірлер: 39

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

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

@karanthapa71176 19 күн бұрын

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

@nandu837 18 күн бұрын

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

@muhammadhanifsoomro3166 19 күн бұрын

Sir this video excellent ۔۔

@KamleshYadav-vs4yw 19 күн бұрын

Very useful

@aqeelawan8634 19 күн бұрын

Sir you are very very intelligent man ❤❤

@bijaytanty8434 18 күн бұрын

Thanks Sir

@SMuralidhar 5 күн бұрын

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

@pandharinathjoshi6565 19 күн бұрын

Excellent sir

@Mamamadhu24 18 күн бұрын

❤

@Adityasshenoy-rw4ox 19 күн бұрын

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

@PritamPaul717 18 күн бұрын

Thank you so much sir

@JainudinAnsari-zv4wo 19 күн бұрын

very good❤

@pandharinathjoshi6565 19 күн бұрын

Sir how can use slicer for using groupby function sir

@Jkdkol 18 күн бұрын

Ur process is meant for experts

@sunilnaturebeautyhealthfit7144 4 күн бұрын

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

@rajumanm 7 күн бұрын

sir namaskaar. please make a video of MS Project

@gajendrasingh9486 Күн бұрын

Sir excel ke konse version me lagega

@bharatbhushan7772 12 күн бұрын

I think it is available in office 2021 or Office 365

@actionmoviez3405 10 күн бұрын

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

@arnabjanacreation8583 13 күн бұрын

sir its available in office 2021

@muhammadtariqmayo1630 19 күн бұрын

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

@NaveenKumar-ic1ky 16 күн бұрын

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

@rajkumarjain3697 19 күн бұрын

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

@user-hx8ub1eu6t 17 күн бұрын

This function available in which ms office

@muhammadhanifsoomro3166 19 күн бұрын

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

@sandeshkadam7937 16 күн бұрын

multiple filter kaise karenge

@GauravSharma-iu5mr Күн бұрын

Group by function is not showing in office 365

@rizwanamin3129 18 күн бұрын

Group by formula not available in online excel 365

@rajkumarjain3697 19 күн бұрын

Unable to locate this function in my office 365

@goluchouksey2794 17 күн бұрын

Sir, acha hai per itna formula kon yad rakhega

@hotbreakseries8326 18 күн бұрын

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

@ravichandra5763 18 күн бұрын

Pivot table is very simple than this

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

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