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

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