Excel me pivot table kya hai? | Complete excel pivot table tutorial in Hindi

Рет қаралды 1,366,899

Күн бұрын

दोस्तों, Pivot Table Excel का बहुत ही उपयोगी और जरूरी फीचर होता है जिसके बारे बहुत सारे लोग नहीं जानते। Pivot Table का इस्तेमाल Excel मे Data Analyze करने या MIS मे रिपोर्ट बनाने के लिए काफी ज्यादा होता है।
तो इसीलिए मैंने Pivot Table in Excel in Hindi का 40 मिनट Tutorial विडिओ बनाया है। इसमे आप Pivot Table, Pivot Field, Pivot Chart, Slicer, Timeline, Pivot मे Data को कैसे Analyze करते है ये सब काफी डीटेल मे बताया है।
Excel me pivot table kya hai? | Complete excel pivot table tutorial in Hindi
What is Pivot Table in Excel?
How to add Row, Column, Value, and Filter in Pivot Table Field?
How to insert Slicer in Pivot Table in Excel?
How to add Pivot Chart using Pivot Table in Excel?
How to Connect Two Pivot Tables/Chart with Slicer using Report Connection?
How to use Timeline in Pivot Table in excel?
-*Timespane*-
00:00 Introduction
01:47 Understanding Data
03:40 Adding Pivot Table
06:30 Understanding Pivot Field
8:30 Adding Data to Pivot Field
10:30 Changing Value Field Setting
12:30 Exploring Pivot Table with Different Field
19:30 Learn Insert Slicer
23:50 Slicer Styles
27:00 Insert Pivot Chart
29:00 Connect two Pivot with Slicer using Report Connection
33:30 Filter in Pivot
34:30 Show Report Filter Pages
36:05 Timeline in Pivot Table
#pivottable
#exceltutorialinhindi
#pivotchart
Excel file for practice:-drive.google.com/file/d/1Lxfa...
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Exce Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My KZfaq Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Watch other Videos :
Excel Basic to Advance Series: • Excel tutorial || Exce...
Excel Amazing Features - • समय बचाना है तो सीखो य...
Excel Advanced 100 Videos - • Excel Introduction In ...
Excel VBA Series in Hindi- • What is VBA in Excel? ...
Excel MIS Videos - • ये सीखने के बाद एक्सेल...
AUTOCAD SERIES: • ऑटोकैड सीरीज अब हिंदी ...
Technology Videos - • Interview Preparation ...
Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
Tags - Learn More, Learn More Channel, Technology Tricks, Computer Tricks,

Пікірлер: 3 000

@Learn_More_Pro 2 жыл бұрын

Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Courses Website :bit.ly/skill_course Course Features : ✅ सभी Videos सरल हिंदी भाषा में ⬇ Download Video in APP ✅ Basic to Advance Courses ✅ Practice Files (Yes) ✅ PDF Shortcuts ✅ Course Completion Certificate ✅ Instant Access ✅ Watch on Desktop : skillcourse.in/

@englishiseasy9226 Жыл бұрын

SIR Kya timeline slicer back year me kam nahi karta hai

@amritathakur2036 Жыл бұрын

sir aapki partice file mene download ki is video ki to mere download Excel mai Row and column highlighted or bold show ho re ye aapne kese Kiya plz bta skte hai kya aap is bare mai.

@Jay-hi8we Жыл бұрын

Useful video

@Jay-hi8we Жыл бұрын

Thank you it a was a great learning for me

@suraiyabano9316 Жыл бұрын

Bhaiya ji ap ko bahut knowledge ha

@gummy1453 4 жыл бұрын

The best video on Pivot Tables. I have been in IT since 1973 and in Excel since 1990. Excellent refresher for me and explained very well.

@sanvivaishy8150 21 күн бұрын

Bahut bahut acha video hai sir 🙏🙏ache se samjh aa gya sir jo ki mere computer center par nhi sikhaya gya mai apke videos dekhti hu aur smj bhi aatahai thnk u sir

@nikhilrao9741 2 жыл бұрын

Thanks bhaiya Bhot hi useful video he..👍👍☺️

@surendrakukkala2868 4 жыл бұрын

A model teaching design. An ideal presentation. Thousand salutes to you sir. I felt as if you are chatting with us live. It is not looking like a recorded tutorial. The best presentation on Excel on KZfaq.

@faisal892 4 жыл бұрын

Wonderful. No need to watch another video on pivot table. This one is enough

@SarfarazKhan-td3hg 2 жыл бұрын

The best channel for Excel the each n every concept about piot table is covered

@debasishsahoo5066 2 жыл бұрын

Bhai ---.." MAZZA AGEYA"🔥🔥🔥🔥❤️🔥🔥🔥🔥

@vismaynayak972 4 жыл бұрын

Sir, This is the finest video on pivot table. I like the way you explained it. Thanks for making this video.

@ashiqsourov8504 3 жыл бұрын

I always watch this channel and try to learn every day. Lots of love from Bangladesh. keep going sir and pray for us so that we can be an excel expert in future like you.

@dANURAG Күн бұрын

❤❤❤ thanks a lot Sir for making this video itna details mein koi nhi batata yha tk offline coaching mein bhi nhi batate

@sabiralone9576 2 жыл бұрын

You are my best sir of the world

@kaushalmailbox 4 жыл бұрын

Sir, great Video, I know pivot table but in this vidoe learn lot of things... Aur thanks bahut chhota word hai aapke liye jitna dhanyawad bolu utna kam hai sir...

@anandkumarkanodia6239 4 жыл бұрын

An honest effort to share your knowledge

@soniyagupta3397 2 жыл бұрын

i wanted full viedo at once ......very useful viedo thank soooooooooooooooooooooo much

@mrperfect6472 2 жыл бұрын

MUJZHE BOHT HELP MILI AAPKI ISS VDO SE... THANK YOU

@msluckylips498 5 жыл бұрын

I watched full video at once...it's really very interesting...so many tricks you explained easily thanks for the video Sir👍nice sir Awosome

@Learn_More_Pro 5 жыл бұрын

THANKS FOR WATCHING BROTHER

@sheetalkukreja2744 4 жыл бұрын

Educating someone is a great deed. God bless you. 🙏🏻

@Learn_More_Pro 4 жыл бұрын

Thanks for submitting your feedback. Stay tuned

@ankurbhutani396 2 жыл бұрын

Aap kalakar hein.... Vidhya daan mahadaan... Jabardast guruji!!

@SHEKHAR064 2 жыл бұрын

Best of best explanation. Behtarin sir ji

@ketankothadia135 3 жыл бұрын

Really great job sir. I have been teaching Statistics and Computer applications with various software to UG and PG students for a long. I must say that I am highly impressed with your clarity of thought and presentation. I rarely comment on the KZfaq videos but I must say that.... Superb.... Congratulations.... Keep it up.

@nagalalitakompalli1813 5 жыл бұрын

If we get this kind of Teachers in Schools toh samjho Students ka "Beda Par Ho Jayega" . No need to take Private Tuition... Good Luck Mr. Guruji......

@Learn_More_Pro 5 жыл бұрын

Your comment is pinned by learn more due to it some +ve energy to go ahead thanks a lot for watching

@jeewaneksangharshkkt232 4 жыл бұрын

Bhai ji windows 7 mein kaun sa excel use karna chahie

@krishnamongia5063 4 жыл бұрын

Advance filter bahut achha se dikhane ke liye thanks

@monajatgazi2098 4 жыл бұрын

Hi May I have ur contact number.. pls..

@mrturboautomobiledesigneng1716 Жыл бұрын

School college wale in teachers ko hire krne ki fee nahi pay kr skte

@rahulsinha8330 Жыл бұрын

Mind Blowing sir..itne simple language me aaj tk kisi ne nhi smjhaya

@rohitshenoy4222 2 жыл бұрын

👍 Very useful video. Simplified the entire pivot table concept. Even a person who has not worked on pivot table b4 will understand.

@manojchakerwarti5420 3 жыл бұрын

Excellent Efforts you put in for others - Good

@vinaygupta1363 4 жыл бұрын

Satish, Simply Amazing and with super clarity.. 👍👍👍👍👍👍

@yuvikhodse6313 3 жыл бұрын

👍 helping for us

@vinayshah6927 2 жыл бұрын

Excellent ! Combining all pivot table potential options in one shot👌

@SeemaSingh-bj7qd Жыл бұрын

Thanq sir for making this video. It helped me a lot. 🙏

@niraajangupta3186 4 жыл бұрын

Your explanation is just amazing ! I am a CA student and your videos are really helping me. Great work, keep it up !

@narottammanihal8463 3 жыл бұрын

अति सुन्दर, सतीश जी बेहतरीन तरीके से समझाते है आप ....

@mohdamir9666 Жыл бұрын

Sir aapki jitni Tareef ki jaae kam hai. In fact, aapki Quality ko batane ke liye kisi dictionary me shabd hi nahi hai. You are Baahubali in Excel, Rajnikant in Excel .

@afzalkhan139 2 жыл бұрын

Thanku sir bahut accha lgta hai dil khus ho jaata hai aapka vide dekh k

@ravim49 3 жыл бұрын

Excellent my dear boy .keep it up. you are outstanding. your concept on the subject matter is just superb. God bless you .M Ravi

@aliakberpoonawala 5 жыл бұрын

thanks for the info...

@tariqhameed38 2 жыл бұрын

Such a great & really informative video. Thanks 🙏🏻

@Moviesshortviodeos Жыл бұрын

Amazing maza aa gya ye Sikh k ❤️

@rajshree4635 2 жыл бұрын

21:48 slicer options 26:50 report connection (pivot feature) 30:10 one slicer for 2 pivot table chart 34:49 separate report month wise auto generated 36:05 timeline

@sudeep246 Жыл бұрын

thnks

@brajesh9787 4 жыл бұрын

I was always thought to understand pivot table. During lockdown I used to see many videos but urs is the best video I have seen where you have given me complete knowledge of using pivot table that too through such a simple way. The way you explain is really cool. Keep posting like this.. Thanks U So Much. & All the best... 👍👍

@sarmistharath1216 3 жыл бұрын

Thanks you so much and all the best

@Sahubrother999 2 жыл бұрын

Thanks Sir helpful video

@comparativestudy8607 Жыл бұрын

Best teacher in the world 🌍

@chandansingh-om5uq Жыл бұрын

Bahot achha laga.kafi kuch sikhne ko mila hai.thanks sir

@snehajangam1222 4 жыл бұрын

I am starting my career in the MIS field, learned a lot of things in detail and I think this is the best channel to learn everything that we want. Thank you so much Sir. Please keep posting.

@Learn_More_Pro 4 жыл бұрын

Thanks for appreciating my work

@sanjuindian9878 3 жыл бұрын

hi me bhi mis hu. friend banogi 9711435771

@thecognition2589 3 жыл бұрын

@@sanjuindian9878 MIS ho ? Konse data ka MIS.

@PinkiKumari-kw6ro 3 жыл бұрын

Please mor vedio in ms office 2019

@ProsPectiveAMIT 2 жыл бұрын

Sneha ♥️♥️♥️

@rushikadam4827 5 жыл бұрын

I am CA student. During our articleship we are depend upon Excel. And this video is helpful to me

@trilokawasthi3839 2 жыл бұрын

Sir....your explanation is amazing....

@xtremetech8890 2 жыл бұрын

YOU ARE THE BEST TEACHER IN COMPUTER SOFTWARES SUPER EXPLAIN

@trilokbisht3385 4 жыл бұрын

Awesome video, I have one query about the pivot table, shall we insert multiple sheet with existing formulas ? If yes , kindly share your thoughts for the same Thank you

@manoranjandas7509 5 жыл бұрын

Am doing pivot every day

@subhojitdhar6856 Жыл бұрын

aisa teacher har kisiko mile❣❣

@JayantaRai Жыл бұрын

The best video on Pivot Tables........ Great......

@patelvishal_vd 4 жыл бұрын

17:53 nepal hamara state hai😂 Btw nice teaching

@sharadkhattar8220 4 жыл бұрын

Highly informative video! Should i desire to learn more, how can i contact you for one to one learning based on my work.

@Mahakal-8094 2 жыл бұрын

बहुत ही अच्छा तरीका ह सर जी आप का पहली बार इतना अच्छा और सरल तरीका देखा पहली बार में ही सिख जाते ह आप की वीडियो देख कर । बहुत बहुत धन्यवाद सर आप का।।❣️❣️❣️ 🙏

@cute-princeyadav 2 жыл бұрын

Super Sir mind blowing aap bahut achhe tarah se explain karte ho

@AnkitSingh-mh7ee Жыл бұрын

Thanks Sir. Finally i got the best Video for Pivot Table.

@sivaramkrishnan8022 Жыл бұрын

Fantastic. In short time very much detailed explanation. Great.. Thanks

@mannatulmowla6834 Жыл бұрын

Thank you, Satish ji. Everything explained very well.

@raitarforces5282 2 жыл бұрын

Bahut shandaar sir

@sudhirtripta 2 жыл бұрын

Dear Satish ji I m retired person n 68 years old man. With this video I learnt pivot table nicely.thanks dear.

@brijendraray9478 Жыл бұрын

You are the best teacher for Excel 🙏🙏🙏

@user-oz6ni1jt4p 8 ай бұрын

Really I, m so much happy when I watch your videos your video and your teaching clear understand ❤❤❤

@aamayneema 2 жыл бұрын

accha hai video...ekk no.

@anandapandit1350 Жыл бұрын

Osm sir lajwab...

@dnyaneshwarkavale4428 2 жыл бұрын

very very nice lecture sir.thanks lot off

@raghunathhial5558 Жыл бұрын

Lo sir like kardiya and coment vi

@arnavaggrawal7114 2 жыл бұрын

Wonder Pivot tables Class.. Thanks A lot

@lataramchandani856 2 жыл бұрын

Your teaching is far more better than the classes that I had attended. Thank You.

@ediary4996 2 жыл бұрын

Incredible ❤️,, love you sir

@shweta2171 Жыл бұрын

Grateful to have such KZfaq mentors like you.

@anilkumardas3591 Жыл бұрын

As you have high confidence, nobody can measure it. Your knowledge on computer is unmeasurable. Go ahead with confidence. Thanks a lot for this video.

@amazingvideo1198 Жыл бұрын

Very nice video. Bahut achhi jankari diya hai apne.

@sumandasgupta3029 2 жыл бұрын

Wonderful insight on Pivot chart n Table...

@maheshrsd 2 жыл бұрын

Very KNOWLEDGABLE video.. thanks

@dmnohan 2 жыл бұрын

Your training is superb and anyone can understand easily (Thank You Sooo much)

@hershmehra4017 2 жыл бұрын

nice and easy to follow ..great work

@durgeshrathod236 Жыл бұрын

amazing video for pivot table almost all basic things covered and few intermediate topics as well

@sarthakgupta6455 2 жыл бұрын

mast sir majja agya samjh aya sabh

@mansurAli-sh3ob Жыл бұрын

Hats off Sir, very clear description

@RajKumar-ln4zf 2 жыл бұрын

Gjb bahut khub sir

@KuldeepSingh-ok9vu 2 жыл бұрын

Jabardast. Maja aa jata hai bhai aapke videos dekh kar. Very interesting.

@rameshchauhanisr Жыл бұрын

Bhai aap kmaal ho... Gajab

@ramthapa8454 Жыл бұрын

Very impressive... Its more than just learning... Thanks 👍

@daniyalashar4884 Жыл бұрын

Excellent video. Thank you for your hard work.

@alkaranjan436 Жыл бұрын

Really Amazing Video sir for learning Pivot table in Excel, well explained in this video very clear. Thank you so much 👍👏👏👏👏👏👏👏👏👏👏👏

@swapnilsarve3885 3 жыл бұрын

Thanks for resolving all problems... Thank you soo much

@sankarprasadnayak3947 Жыл бұрын

Love you sir. Nice learning video

@Ganesharajun Жыл бұрын

Wow Thanks Sir, For the Complete Clarity on PIVOT

@subhendupradhan1907 3 жыл бұрын

I learned... Thank you so much for this video boss

@SunnySingh-pt5oq Жыл бұрын

bhaut acha se samjaye sir .i like it.nice sir thank sir clear kar diye ap .

@amankumarsingh1972 3 жыл бұрын

अद्भुत 👌

@indranilchatt12 3 жыл бұрын

Amazing vdo.. Thank you very much. No match with your vdo sir.. I am fond of your vdo..

@gvganeshv001 Жыл бұрын

WOW Satish sir. You are uniquely styled.

@sarfealam5364 2 жыл бұрын

Sir aap bohat Achha excel sikhate ho Thanks share information

@kaushikvalangar9823 2 жыл бұрын

One of the most interested and knowledgeable video 👍

@shivamnishad2509 Жыл бұрын

mast lga sir aapka video ..

@mamunhossain6706 Жыл бұрын

You are my favourat teacher from Bangladesh

@successmaharjan2906 2 жыл бұрын

i have watched the complete video. well explained in detail. thank you sir.

@shivammakwana6852 2 жыл бұрын

Your teaching techniques is tremendous sir. Thankyou sir.

@UmeshYadav-hv8jk 2 жыл бұрын

Very informative video.. Thanku sir

@mssiddiqui5546 2 жыл бұрын

Itna best teacher mujhe meri life me kabhi nhi mila bahut achchha tarika ka teach krne ka... God bless you sir

@shamimahmadshah8305 2 жыл бұрын

appreciable, all the best

@NareshKumar-zz4jq Жыл бұрын

A better learning video than other Thanks a lot