You Don't Know ! Proper Use of PIVOT TABLE in Excel - Pivot Table Tutorial

You Don't Know ! Proper Use of PIVOT TABLE in Excel - Pivot Table Tutorial
Dosto Microsoft excel me pivot table ka basic use karna to apko aata hi hoga par kya apko pivot table ka advanced lavel pe use karna aata hai ?
Is video me maine pivot table ko detail main basic to advance explain kar diya hai. Excel me pivot table kya hai ? pivot table kaise use kare ? pivot table se awesome report kaise bnaye? Data summarize kaise kare ? slicer, groups, timeline, report filter, subtotal ka use kaise kare ? dynamic pivot chart kaise bnaye ? matlab pivot table ka complete tutorial is video me hai jo apko excel pivot table me zero se hero bna dega. Aasha hai ye video aapko jarur pasand aayega.
In this video of Microsoft excel, you will learn how to properly use pivot table. Pivot table basic to advance tutorial in Hindi 2021.
Chapters
00:00 Intro
01:20 How To Create Pivot Table
04:14 Pivot Table Report 1
08:24 Pivot Table Report 2
11:55 How To Apply Formulas in Pivot Table
12:59 Set Zero Value For Blank Cells
13:49 Show and Hide Grand Totals
14:45 Pivot Table Report 3
20:10 Pivot Table Report 4
21:26 Show and Hide Subtotal
23:54 Pivot Table Classic Layout
25:09 Report Filter
28:07 Grouping
31:57 Update Pivot Table
33:51 Slicer and Timeline
35:16 Charts
38:03 Removing Pivot Table Layout
Download Training File: bit.ly/37yARWx
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
#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
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
Thanks for watching
DEEPAK NEHRA

[@atulshah2235]

Superb, Excellent, Very good, SALUTE SIR no more ward to say. BIG BIG THANKS

[@pa2happiness13]

💞👌🏼

[@exceldictionary6340]

kzbin.info/www/bejne/mqnGo4F5f7SYm8k

[@ashmandrekar2802]

@@pa2happiness13 dď

[@aniljain2552]

Ha g

[@zaheeranwar8434]

kzbin.info/www/bejne/Zqu6ZHuuaJuVi5o

[@Aftabsain18]

You are by far the best teacher I have seen on KZbin for learning EXCEL.You explain the topic in very simple and easy format even the person is new to excel can understand.👍

[@pushpalatasuvarna5269]

Deepakji aapne bahut hi saral tarike se kaafi important aur difficult subject easily explain kiya hai iss video mein, thank you so much

[@ITSchoolBroze]

Incredible sir ji...pivot table ko ap se better koi b teacher nai teach kr sakta.... Challenge ❤

[@nitink6414]

Sir Aapka Jawab Nahi... Kitne acche tarike se aapne describe Kiya hai pivot table ko... Thanks a lot Sir

[@ajaynilu6536]

Fan ho gya mai aapka I will never forget this video and you(creater) of this video. No doubt about this topic. Everything explained very well. Thanks a lot dear Deepak sir.

[@prateek._sahu]

I'm blown away! Literally the best video on KZbin for Pivot table ❤

[@junaidmomin572]

Bhut badhiya sir maza aa gya 1 hi video me sb kuch.

[@arquamraza8949]

Bahut he helpful rahi apki video , Thanks👍

[@longhairkavita]

Very Very Nice Sir thank you sir aapne bahut ache se explain Kiya very nice. 😊

[@PINTU0808]

Pivot table ko Normal table bna diya...before this video this table too complicate for me to understand but after this video i can see full magic 🎉my stress out😅😅

[@heeralalkumawat2132]

Pivot tables aap se acha koi nhi padha sakta Excellent 👍

[@imageosm1073]

Bahot jyada helpful class hai sir... thank you 🙏

[@efalcons]

Brilliant Mr. Deepak, you make my night and day and clear the most important feature of excel.

[@nnbg8000]

YT recommended your channel, for some reason. This is great!! Thank you very much. The easiest explanation of Pivot tables. I have subscribed.

[@kaushik1991dey]

Deepak ji you are awesome. You have helped lots of candidates and students sharing your knowledge. I am one of them. Though I am not working anywhere with excel but I love doing work on excel so I try to learn new things in depth. You are my inspiration in this. Thank you so much brother. Keep going👍👌❤️

[@sujaymenon2691]

Deepakji excellent aapney bakhubi tarikey sey pivot table kaisey kiya jaata hey aapney bataya hey. Thanks

[@supriyachoubey2985]

excellent sir ,sir excel k liye aapse best teacher ho hi ni sakta hai thank you sir

[@ISMAILISMAIL-mu8vi]

Deepak sir you are gr8 teacher... May God bless you... All concepts are very much clear.... thank you so much sir

[@mr.ravikumar2378]

Bahot badiya samjhaya sir 😊

[@darshitchavda8264]

Nice one sirjee... 😄😄😄😄😄

[@shivsinghranawat1493]

Very super boss great video nice👌👌 aapke समझाने का तरीका बहुत अच्छा है🙏🙏

[@surakshahm236]

Thanks you for sharing wonderful knowledge and the accurate use of pivort table. I was abvo to quit the job because of lake of excel knowledge but after seeing this constant presentation I’m filled with confidence, thanks for fill huge confidence on me❤️

[@AhsanAli-zk7ld]

Again hats off, your knowledge and way of teaching is exceptional. and your anticipation power as a teacher is mind blowing.

[@kusumdevi7953]

Very very nice and very very special explanation by Deepak sir . A lot of thanks Deepak sir.

[@voiceofsoul7865]

You video training is awesome bro. Thank you. I'm from Pakistan.

[@harshaddafda1778]

Awesome explanation Sir...Dil Se maza aa gya...

[@AnimalsCasa]

I am working with one of the top most Corporate as a Squad Leader. Your videos are really very helpful and learning a lot from your videos and also using in day to day activities.

[@DeepakEduWorld]

Glad to help! 😊

[@rainbommannavar1695]

Thank God. From last 2 years I had lost too many time to create summary via pivot table. Your video solve my entire question about pivot table, summary making.. love you Deepak sir..

[@VISHALSHIRALKAR]

Hats off to you deepak ji, Excellent. I don't have words to express my gratitude. Once again superb work

[@yawarbakht7215]

Superb, Excellent, Very good. Thank you Deepak bhai, for expaining the content in such a beautiful way that all my doubts got cleared. Appreciate the way of teaching. God bless you sir

[@savitapawaskar2230]

superb superb superb..... simply great sir.. u have made it very easy to understand .... sir... ty so much.. sir.....

[@neetukumari6731]

Thank you so much sir itne video dekhe par samajh apke hi video se aya hai

[@richakhare699]

Thanku sir bohot sare doubt clear hue

[@abbasnaqvi6419]

Thank you Deepak bhai, for expaining the content in such a beautiful way that all my doubts got cleared. I really appreciate your hard work and dedication in making such insightful videos.

[@promotionalcomedy6072]

The way of teaching is really fantiastic.

[@rohitjain2126]

Excellent teaching cleared most of my doubts Thanks sir

[@PAWAN_SAINI613]

क्या बात है सर बिल्कुल आसान भाषा मे समझा दिया love you sir ☝️🫡🚩

[@Santosh2Yadav]

Gr8, very informative and easy way to explain...

[@jitendrajoshi1499]

आपसे बड़ा genius कोई नहीं 🙏🙏🙏🙏गुरुजी धन्यबाद

[@tanukoshti6152]

Thank you thank you sir you are just awesome for our all excel problems there's solution and features, function.. 😊the way of u explain us pivot table no other can explain like this sir, thank you sir once again... 😊

[@raghavkalra1156]

Hatts off to you sir Apse acha koi EXCEL k concepts clear ni krva sakta Thank u ☺️

[@nandansharma5053]

Wow भैया जी ❣️ मैं पूरा आप ही क्लास में सिख लिया हु प्रैक्टिस के लिए कोचिंग जाता hu ❣️

[@zaheeranwar8434]

kzbin.info/www/bejne/bJuqaYp8n9N6iKM

[@moinuddinansari5539]

Thank you so much sir apki hi baat samjh me aaai pivot table ki or traning example k liyh bht bht shukriya @deepak edu world

[@zaheeranwar8434]

kzbin.info/www/bejne/bJuqaYp8n9N6iKM

[@Gobu0806]

The way you explain makes excel really easy for me...Thank you.

[@DeveshGaur-ek4ic]

Excellent tutorial...ty deepak ji. ❤️✨🔥

[@dibyaprakashsamantaray252]

Very good job brother.. You solve all my problem regarding Excel. Which help in my Professional Life

[@adeelbhatti2507]

very helpful...watching you from Pakistan and learnt alot of knowledge in excel from you. GOD Bless you.

[@parthivhunter9485]

Sir you are legend

[@Toolooa]

Thank you, dost. You are the best teacher on youtube.

[@muhammadzeeshankhan004]

I am from Pakistan and I can't describe the way you put effort wow....amazing...just love you.

[@shivamkr04]

Koi class jaane ki jarurat nahi hai... Sir ki videos dekho aur saare doubts clear.... Thank you for this video sir... ❤🙌🏼

[@swapnilshinde9090]

Thank you soo much sir. You have explained it in a very easy and understandable way

[@stocksforever4200]

You are so great in Ms Excel I have never thought we can use pivot table like this

[@gouravgupta8895]

Sach me upka video dekh kar na ekdam all concept crystal clear ho jata h

[@sureshchandrajena9134]

Good morning, We are speechless. How did you learn all the things in computer. You have vast knowledge in the field of computer applications. Thank you so much for your brilliant knowledge. God bless you.

[@worldoflaughter7259]

I think there are no words to praise and appreciate you. Thank you

[@erprashantjoshi1034]

Thanks a lot of for your guidance sir

[@guruchahal1990]

Really sir... Great 👍🏽 Salute to your efforts.....

[@shamikghoshal1619]

very helpful. Thank You

[@MUKESHGUPTA-wb1fx]

बहुत ही अच्छी तरह से बताया है आपने super

[@monikachhugani6003]

Great sir bahut helpful video

[@neelkamal5274]

Sir, Thank you so much for making us easy to understand.

[@subhasis2206]

One of the best vdo ever seen on pivot table....everything z there in one vdo...

[@pragatipatankar4913]

Both video on same topic are excellent and interesting.

[@pragatipatankar4913]

THANK YOU SO MUCH

[@Himanshu-rh9zd]

very well explained sir g. Thank you sir. God bless you.

[@jaihind_jaisanatan]

Isse badhiya pivot table par mene koi video aaj tak nahi dekha, superb

[@aseemsingh.1548]

Thank you so much from the core of my heart.❤

[@mohammadjamil8738]

Excellent way of teaching

[@aanchalkashyap9391]

Ap bhot easy way me bta te ho sab excellent sir👍👍👍👍👍👍👍👍👌👌

[@Rainbow-ll2oi]

Bhot bhot hi accha h video ek ek step with clear concept ..wwww❣️❣️

[@Prabhukalyandhal]

Best ,easiest way that you make and explain your vedios. I like the most. Never seen crystal clear vedio like yours

[@priyanshdaga8499]

Very helpful video on pivot table

[@rahiljasnak1072]

Good explanation in simple language

[@neelakanthdhamannavar3227]

Superb Excellent sir..🙏👌 Thank u

[@dmanasmba]

Superb sir. The last point was. Super. Before I unaware about this. Thanks for this👏🙏🙏🙏

[@exceldictionary6340]

kzbin.info/www/bejne/mqnGo4F5f7SYm8k

[@riddhipatel7563]

It's explained in very well. Thank you for making it simple and easy to understood.

[@himansupanda4216]

superb sir, the way you teach its realy nice

[@SyedMuhammadAhmed-jt8sz]

Highly appreciated for a wonderful explanation

[@DeepakEduWorld]

Glad it was helpful!

[@yaminkumar4111]

Very informative video, Thank Sir

[@skdanishbadar3248]

Thanks Depak Bhai great job .love from Pakistan

[@user-jn1ev2cf8h]

Excellent explanation thanks

[@surajnath9929]

Excellent Video Sir, Thank You Very Much

[@Patrioticgamer123]

Excellent explanation sir, this video help me to clear my all doubts

[@fayazsheikh698]

After watching this video I guess no need to watch any other video, thanks a lot for such a wonderful video.

[@ashishrawat2919]

Thanks for sharing extended knowledge,

[@mohdarbi4064]

Very useful video. Complex topic explained in an easy manner.

[@nalandaconventsr.sec.schoo3978]

Thanks Deepak ji. Maine Apke videos ke madyam se hi excel seekha hai. Thank you sir for sharing your deep knowledge of excel in excel way.

[@shabaamankhan9889]

Excellent video sir

[@shantilalrajput8708]

V.nice &V.Useful Sir Thank You Sir 🇮🇳🇮🇳🇮🇳

[@chetanrawat5428]

sir aapne bahut hi shandar tareeke se Samjhaya

[@omprakashprajapat3384]

Super dupdr hit salute sir ji very good teaching

[@deependramishra2110]

Excellent detailed video. Thank you so much.

[@bhushanthakur5953]

Thank you Sir for explaining in simple language.

[@adi.sriv21]

What a great way of teaching! Loved it... Thank you so much

[@ajayrohilla1500]

Best video bhai thanks from video

[@vikashmourya8964]

Thanks genius sir for making this vedio.....love you

[@asimsiddiq475]

hi, king of Excel all of your too much information for new and advanced users.

[@mmaworld7384]

Thanks a lot Sir . Your videos helps a lot me in every stage of my job

[@liaquatali6437]

Thanks for wonderful video Love from Pakistan