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

Подписаться 1,2 млн

Просмотров 1,4 млн

50% 1

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

Опубликовано:

14 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 626

@atulshah2235 2 года назад

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

@pa2happiness13 2 года назад

💞👌🏼

@exceldictionary6340 2 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dxcrNCJOeeg.html

@ashmandrekar2802 2 года назад

@@pa2happiness13 dď

@aniljain2552 2 года назад

Ha g

@zaheeranwar8434 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0zW3Hx36bU8.html

@Aftabsain18 3 месяца назад

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

@PINTU0808 9 месяцев назад

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😅😅

@prateek._sahu Год назад

I'm blown away! Literally the best video on RU-vid for Pivot table ❤

@ITSchoolBroze 5 месяцев назад

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

@pushpalatasuvarna5269 5 месяцев назад

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

@DeepakEduWorld 2 года назад

My Channels : Learn A to Z Pro Excel : bit.ly/3hQCRiw Excel Shorts on Deepak Techworld : bit.ly/3qFrbl5 Deepak EduWorld : bit.ly/3zWWtIS

@ajaynilu6536 2 года назад

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.

@longhairkavita 9 месяцев назад

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

@junaidmomin572 Год назад

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

@nitink6414 Год назад

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

@mr.ravikumar2378 3 месяца назад

Bahot badiya samjhaya sir 😊

@efalcons 2 года назад

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

@nnbg8000 2 года назад

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

@imageosm1073 9 месяцев назад

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

@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👍👌❤️

@parthivhunter9485 Год назад

Sir you are legend

@RahulSingh-fm5zk 11 часов назад

Super sir🎉 Thank you, You are serving the country.

@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.

@AhsanAli-zk7ld Год назад

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

@voiceofsoul7865 Год назад

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

@heeralalkumawat2132 2 года назад

Pivot tables aap se acha koi nhi padha sakta Excellent 👍

@sujaymenon2691 Год назад

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

@surakshahm236 2 года назад

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❤️

@harshaddafda1778 Год назад

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

@aseemsingh.1548 2 года назад

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

@neelkamal5274 2 года назад

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

@supriyachoubey2985 2 года назад

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

@ISMAILISMAIL-mu8vi 11 месяцев назад

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

@sureshchandrajena9134 2 года назад

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.

@erprashantjoshi1034 Год назад

Thanks a lot of for your guidance sir

@shivsinghranawat1493 2 года назад

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

@savitapawaskar2230 Год назад

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

@neetukumari6731 2 года назад

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

@monikachhugani6003 4 месяца назад

Great sir bahut helpful video

@Gobu0806 Год назад

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

@arquamraza8949 Месяц назад

Bahut he helpful rahi apki video , Thanks👍

@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... 😊

@zahidqamar2143 2 года назад

Video is a good source of learning, thank u Deepak

@dibyaprakashsamantaray252 2 года назад

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

@Mr.K_Artist Год назад

Really very good, you covered almost everything, nice work man 👍

@VISHALSHIRALKAR 7 месяцев назад

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

@saumyadeepbanerjee2180 2 года назад

This is an awesome tutorial 😍 Thanks for sharing this valuable information's with us.

@kusumdevi7953 3 месяца назад

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

@nalandaconventsr.sec.schoo3978 2 года назад

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.

@prakashadhikari7193 2 года назад

Thanks for this vedio. Easy to understand.

@DeveshGaur-ek4ic 2 года назад

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

@Himanshu-rh9zd 2 года назад

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

@subhasis2206 Год назад

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

@rainbommannavar1695 5 месяцев назад

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..

@asimsiddiq475 2 года назад

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

@deependramishra2110 Год назад

Excellent detailed video. Thank you so much.

@Bhise.Entertainment 2 года назад

Excellent, Superb sir Salam apko

@shikhachaturvedi313 Год назад

Thank you for making it so simple and easy for us👍

@shafqatullah9068 2 года назад

I really admire your work so easy to understand most advance formulas and excel tools. Great work keep it up.

@raghavkalra1156 Год назад

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

@Prabhukalyandhal 2 года назад

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

@pramodsh2129 2 года назад

U r the inspiration of life thaks a lot deepak bhai ❤️❤️❤️

@muzhganh6242 Год назад

🙂😊very very nice information and explaining it with fun and interest totally wonderful, thank you sir I learned a lot of new things

@Rainbow-ll2oi Год назад

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

@darshitchavda8264 Год назад

Nice one sirjee... 😄😄😄😄😄

@adi.sriv21 5 месяцев назад

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

@yawarbakht7215 8 месяцев назад

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

@Toolooa 11 месяцев назад

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

@rohitjain2126 8 месяцев назад

Excellent teaching cleared most of my doubts Thanks sir

@worldoflaughter7259 4 месяца назад

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

@bhagavathis4961 2 года назад

Thank you so much. Very nicely explained.

@stocksforever4200 Год назад

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

@iam.Ravi24 2 года назад

You are an god gift to us. Amazing 👍

@jaiminipatel8261 Год назад

You are genius.I learnt lots of tricks from your videos.Thank you so much 🙏

@GamingCrazy-vh4vn Год назад

Thank you so much everything that you explained was so easy to understand. Now I am clear with pivot tables

@vikashmourya8964 2 года назад

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

@shafik4845 2 года назад

Very nicely explained. Thanks☺

@neelakanthdhamannavar3227 11 месяцев назад

Superb Excellent sir..🙏👌 Thank u

@sandeepsingh-jf5qb 2 года назад

Thanku Sir For This Information 💯💯💯💯

@saurabdeshmukh 2 года назад

Your tutorials are excellent.

@surajnath9929 2 года назад

Excellent Video Sir, Thank You Very Much

@chintamanikulkarni1787 2 года назад

Beautifully explained Deepak Sir

@adeelbhatti2507 2 года назад

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

@user-jn1ev2cf8h 2 года назад

Excellent explanation thanks

@sunithap1189 2 года назад

Fantastic sir,tq so much 🙏🙏🙏🙏🙏

@swapnilshinde9090 7 месяцев назад

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

@shabaamankhan9889 2 года назад

Excellent video sir

@ajayrohilla1500 2 года назад

Best video bhai thanks from video

@Maajagatjanani 6 месяцев назад

Super. Excellent. Perfect teaching

@priyanshdaga8499 2 года назад

Very helpful video on pivot table

@vijayjaiswal6470 Год назад

Excellent Sir, very big thanks to you

@mohdarbi4064 2 месяца назад

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

@shamikghoshal1619 2 месяца назад

very helpful. Thank You

@skdanishbadar3248 Год назад

Thanks Depak Bhai great job .love from Pakistan

@ashishrawat2919 11 месяцев назад

Thanks for sharing extended knowledge,

@shivrana2090 2 года назад

outstanding method of teaching 👍

@promotionalcomedy6072 11 месяцев назад

The way of teaching is really fantiastic.

@liyaqatshaikh6094 Год назад

Ek number Explaination 😇😇

@aanchalkashyap9391 2 года назад

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

@AnujKumar-ot5vi Год назад

Excellent Video Sir. This is really very useful and easy to understand. Thanks for it.

@rakeshmahakud9151 2 года назад

Jabardast explained

@jitendrajoshi1499 Год назад

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

@aryachandan8780 Год назад

Excellent sir, Thank you 😍😍😍🙏🙏🙏🙏🙏🙏

@guruchahal1990 8 месяцев назад

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