You Don't Know ! Proper Use of PIVOT TABLE in Excel - Pivot Table Tutorial
HTML-код
- Опубликовано: 14 июл 2024
- 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
Superb, Excellent, Very good, SALUTE SIR no more ward to say. BIG BIG THANKS
💞👌🏼
ruclips.net/video/dxcrNCJOeeg/видео.html
@@pa2happiness13 dď
Ha g
ruclips.net/video/0zW3Hx36bU8/видео.html
You are by far the best teacher I have seen on RUclips for learning EXCEL.You explain the topic in very simple and easy format even the person is new to excel can understand.👍
Incredible sir ji...pivot table ko ap se better koi b teacher nai teach kr sakta.... Challenge ❤
Deepakji aapne bahut hi saral tarike se kaafi important aur difficult subject easily explain kiya hai iss video mein, thank you so much
Sir Aapka Jawab Nahi...
Kitne acche tarike se aapne describe Kiya hai pivot table ko...
Thanks a lot Sir
I'm blown away!
Literally the best video on RUclips for Pivot table ❤
Very Very Nice Sir thank you sir aapne bahut ache se explain Kiya very nice. 😊
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.
Bhut badhiya sir maza aa gya 1 hi video me sb kuch.
Super sir🎉 Thank you, You are serving the country.
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😅😅
Pivot tables aap se acha koi nhi padha sakta
Excellent
👍
Very super boss great video nice👌👌 aapke समझाने का तरीका बहुत अच्छा है🙏🙏
Deepakji excellent aapney bakhubi tarikey sey pivot table kaisey kiya jaata hey aapney bataya hey. Thanks
Bahot badiya samjhaya sir 😊
excellent sir ,sir excel k liye aapse best teacher ho hi ni sakta hai thank you sir
Nice one sirjee... 😄😄😄😄😄
Wow भैया जी ❣️ मैं पूरा आप ही क्लास में सिख लिया हु प्रैक्टिस के लिए कोचिंग जाता hu ❣️
ruclips.net/video/6jG8WFjnGRA/видео.html
Sir you are legend
YT recommended your channel, for some reason. This is great!! Thank you very much. The easiest explanation of Pivot tables. I have subscribed.
Brilliant Mr. Deepak, you make my night and day and clear the most important feature of excel.
Bahot jyada helpful class hai sir... thank you 🙏
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❤️
You video training is awesome bro. Thank you. I'm from Pakistan.
Excellent tutorial...ty deepak ji. ❤️✨🔥
Thank you so much sir itne video dekhe par samajh apke hi video se aya hai
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..
Awesome explanation Sir...Dil Se maza aa gya...
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👍👌❤️
क्या बात है सर बिल्कुल आसान भाषा मे समझा दिया love you sir ☝️🫡🚩
आपसे बड़ा genius कोई नहीं 🙏🙏🙏🙏गुरुजी धन्यबाद
Very good job brother.. You solve all my problem regarding Excel. Which help in my Professional Life
hi, king of Excel all of your too much information for new and advanced users.
Excellent video sir
Great video
Deepak sir you are gr8 teacher... May God bless you... All concepts are very much clear.... thank you so much sir
Best video bhai thanks from video
Hats off to you deepak ji,
Excellent.
I don't have words to express my gratitude.
Once again superb work
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.
Very very nice and very very special explanation by Deepak sir . A lot of thanks Deepak sir.
very helpful. Thank You
Again hats off, your knowledge and way of teaching is exceptional. and your anticipation power as a teacher is mind blowing.
Thanks a lot of for your guidance sir
Isse badhiya pivot table par mene koi video aaj tak nahi dekha, superb
Gr8, very informative and easy way to explain...
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
ruclips.net/video/6jG8WFjnGRA/видео.html
Very nice
Very nice sir ❤❤
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.
Glad to help! 😊
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
Very helpful video on pivot table
Bahut he helpful rahi apki video , Thanks👍
Hatts off to you sir
Apse acha koi EXCEL k concepts clear ni krva sakta
Thank u ☺️
Great sir bahut helpful video
Thank you soo much sir.
You have explained it in a very easy and understandable way
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.
Nice vedio🙏
बहुत ही अच्छी तरह से बताया है आपने super
very helpful...watching you from Pakistan and learnt alot of knowledge in excel from you. GOD Bless you.
Excellent teaching cleared most of my doubts Thanks sir
Thank you, dost. You are the best teacher on youtube.
Koi class jaane ki jarurat nahi hai... Sir ki videos dekho aur saare doubts clear.... Thank you for this video sir... ❤🙌🏼
Excellent,👍👍👍
After watching this video I guess no need to watch any other video, thanks a lot for such a wonderful video.
extraordinary bro
Very helpful video
I am from Pakistan and I can't describe the way you put effort wow....amazing...just love you.
Bhot bhot hi accha h video ek ek step with clear concept ..wwww❣️❣️
EXCELLENT & TRIFFIC VEDEO BY YOU
Thanks for wonderful video
Love from Pakistan
very well explained sir g. Thank you sir. God bless you.
Excellent explanation thanks
The way you explain makes excel really easy for me...Thank you.
superb superb superb..... simply great sir.. u have made it very easy to understand .... sir... ty so much.. sir.....
Thanks a lot Sir . Your videos helps a lot me in every stage of my job
Tq so much sir ...sir Excel ka bhi word ki tarah pura tutorial bnana🙏🥰
Bhai aapko practice file dena chahie tha,,,,
By the way bahut achcha video banaya,, thank you bro,,, from Bangladesh ❤❤❤❤❤
Supperrrbbbbbb concept
Excellent and worth it
Very informative video, Thank Sir
Thank you so much for this wonderful vedio keep up the good work the way you explained it was very easily understandable
ruclips.net/video/0zW3Hx36bU8/видео.html
Sach me upka video dekh kar na ekdam all concept crystal clear ho jata h
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... 😊
Best video 👏
Superb Excellent sir..🙏👌 Thank u
The way of teaching is really fantiastic.
Mind blowing🤯🤯🤯🤯
Hats off you sir
Outstanding sir
Both video on same topic are excellent and interesting.
THANK YOU SO MUCH
Excellent detailed video. Thank you so much.
Superb
You are so great in Ms Excel I have never thought we can use pivot table like this
Sir,
Thank you so much for making us easy to understand.
Superb sir. The last point was. Super. Before I unaware about this. Thanks for this👏🙏🙏🙏
ruclips.net/video/dxcrNCJOeeg/видео.html
Thank you so much from the core of my heart.❤
Thanks for sharing extended knowledge,
Super dupdr hit salute sir ji very good teaching
Excellent Video Sir, Thank You Very Much
Thank you so much Sir 🙏