10 Pivot Table CRAZY Tips and Tricks ! Pivot Table in Excel | Pivot Table Tutorial in Hindi
in this microsoft excel tutorial you will learn, 10 most useful & time saving pivot table tips and tricks to increase your productivity. if you use these pivot tables tricks in excel, trust me you can create pivot reports very smartly and effortlessly. how to use pivot table in excel in hindi
excel ke is video me pivot table ki 10 amazing tips and tricks maine share ki hain dosto jinko dekhne ke baad aap smartly pivot table ka use karna seekh jaoge. ye pivot table tutorial sabhi excel users ke liye bahut kaam ka hai...
if you don't know how to use pivot tables in excel please watch this pivot table tutorial • You Don't Know ! Prope...
Download training file : bit.ly/400hYG9
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
00:00 intro
00:32 create reports using excel AI
01:47 filter hack
02:52 quickly insert slicer
03:28 reorder labels by re-typing
05:16 summarize reports using % of column total
06:22 filter top and bottom items in report
07:57 report filter real use
09:47 report layout, grand total & subtotal
11:35 unpivot pivot tables
12:36 extract data from pivot table using double click
13:32 bonus trick
#pivottable
#excel
#DeepakEduWorld
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 ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
Thanks for watching
DEEPAK NEHRA