Excel me pivot table kya hai? | Complete excel pivot table tutorial in Hindi
HTML-код
- Опубликовано: 18 авг 2024
- दोस्तों, 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
Attend Satish sir's Online Webinar Free: courses.skillc...
#pivottable
#exceltutorialinhindi
#pivotchart
Excel file for practice:-drive.google.c...
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_c...
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/le...
Check our latest blogs: learnmoreindia...
------------------------------------------------------------------------------------------------------------------------------
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 RUclips 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,
![EST Gee - NEVER NEED (Feat. Selfpaid Savage) [Official Video]](http://i.ytimg.com/vi/f2cRtr52HXI/mqdefault.jpg)
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
SIR Kya timeline slicer back year me kam nahi karta hai
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.
Useful video
Thank you it a was a great learning for me
Bhaiya ji ap ko bahut knowledge ha
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.
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
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 .
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
thnks
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.
Thanks for appreciating my work
hi me bhi mis hu.
friend banogi 9711435771
@@sanjuindian9878 MIS ho ?
Konse data ka MIS.
Please mor vedio in ms office 2019
Sneha ♥️♥️♥️
Mind Blowing sir..itne simple language me aaj tk kisi ne nhi smjhaya
Thanku sir bahut accha lgta hai dil khus ho jaata hai aapka vide dekh k
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......
Your comment is pinned by learn more due to it some +ve energy to go ahead thanks a lot for watching
Bhai ji windows 7 mein kaun sa excel use karna chahie
Advance filter bahut achha se dikhane ke liye thanks
Hi May I have ur contact number.. pls..
School college wale in teachers ko hire krne ki fee nahi pay kr skte
Wonderful. No need to watch another video on pivot table. This one is enough
i wanted full viedo at once ......very useful viedo thank soooooooooooooooooooooo much
You are my best sir of the world
अति सुन्दर, सतीश जी बेहतरीन तरीके से समझाते है आप ....
I am CA student. During our articleship we are depend upon Excel. And this video is helpful to me
Aap kalakar hein.... Vidhya daan mahadaan... Jabardast guruji!!
Itna best teacher mujhe meri life me kabhi nhi mila bahut achchha tarika ka teach krne ka... God bless you sir
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
THANKS FOR WATCHING BROTHER
Educating someone is a great deed. God bless you. 🙏🏻
Thanks for submitting your feedback. Stay tuned
Sir maine pivot chart aur vlookup ke bahut sare video dekhe lekin apne jo video m bnaya h wo kamal ka h ek dum perfect aur ab mujhe koi video dekhne ki jarurat nahi hai . maine ab achi tarah se sikh liya h
Bahut bahut dhanyawad aapka
Thanks Sir. Finally i got the best Video for Pivot Table.
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.
An honest effort to share your knowledge
Super Sir mind blowing aap bahut achhe tarah se explain karte ho
MUJZHE BOHT HELP MILI AAPKI ISS VDO SE... THANK YOU
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...
Your explanation is just amazing ! I am a CA student and your videos are really helping me.
Great work, keep it up !
Bahot achha laga.kafi kuch sikhne ko mila hai.thanks sir
❤❤❤ thanks a lot Sir for making this video itna details mein koi nhi batata yha tk offline coaching mein bhi nhi batate
Excellent my dear boy .keep it up. you are outstanding. your concept on the subject matter is just superb. God bless you .M Ravi
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 RUclips videos but I must say that....
Superb....
Congratulations....
Keep it up.
YOU ARE THE BEST TEACHER IN COMPUTER SOFTWARES SUPER EXPLAIN
Sir....your explanation is amazing....
Sir, This is the finest video on pivot table. I like the way you explained it. Thanks for making this video.
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 RUclips.
Thanq sir for making this video. It helped me a lot. 🙏
Best teacher in the world 🌍
Excellent Efforts you put in for others - Good
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... 👍👍
Thanks you so much and all the best
Thanks Sir helpful video
aisa teacher har kisiko mile❣❣
very very nice lecture sir.thanks lot off
Satish, Simply Amazing and with super clarity.. 👍👍👍👍👍👍
👍 helping for us
thanks for the info...
You are the best teacher for Excel 🙏🙏🙏
Thank you so much Sir for giving us such informative video....Main toh iske bareh me pura zero tha....Ap ki tarah koi nehi sikhata....You are great sir ❤️
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
17:53 nepal hamara state hai😂
Btw nice teaching
Really I, m so much happy when I watch your videos your video and your teaching clear understand ❤❤❤
Sir aap bohat Achha excel sikhate ho
Thanks share information
Am doing pivot every day
Highly informative video! Should i desire to learn more, how can i contact you for one to one learning based on my work.
bhaut acha se samjaye sir .i like it.nice sir thank sir clear kar diye ap .
Maje aagaye sir Sara samaj me aa gaya you better explanation provide
Thank you!
Such a great & really informative video. Thanks 🙏🏻
sir aapka teaching ka method mujhe abtak saare teachers se best laga.keep up the good work.
amazing video for pivot table almost all basic things covered and few intermediate topics as well
Pura dekha, sir. It is very useful for working men as like me. Thank u sir
Very nice video. Bahut achhi jankari diya hai apne.
Best of best explanation.
Behtarin sir ji
The best video on Pivot Tables........ Great......
One of the most interested and knowledgeable video 👍
Aapko bahot bahot dhanyawad
Aapke videos se bahot sare logo ko bhala ho raha h
Your teaching techniques is tremendous sir. Thankyou sir.
Very good sir Thank you so much Jitna Dhanybad Kre Kam Hai
Thanks for resolving all problems... Thank you soo much
Thank you, Satish ji. Everything explained very well.
Bhai ---.." MAZZA AGEYA"🔥🔥🔥🔥❤️🔥🔥🔥🔥
Thank you sir PIVOT TABLE ko batane k liye
थैंक्स सर,, इस वीडियो से काफी सिखा है
Well done sir.... Very informative and crystal clear class. Thank you so much.
Excellent ! Combining all pivot table potential options in one shot👌
Fantastic. In short time very much detailed explanation. Great.. Thanks
Thanks bhaiya Bhot hi useful video he..👍👍☺️
Wonder Pivot tables Class.. Thanks A lot
Jabardast. Maja aa jata hai bhai aapke videos dekh kar.
Very interesting.
Sab kuchh samajh aaya hai sir. Aur aapaka teaching way kaafi interesting hota hai jisase ham bina bore bhi nahi hote. Thanks for this tutorial....
Best video on RUclips Sir thank you so much
nice and easy to follow ..great work
Thank u for tutorial of pivot table love you ho gya
From Pakistan
Aap jo samjate ho ek hi bar me samaj aa jata he
Very good tutorial, Slicer Report Connection is classic
You are awsome sir
Aap ka sikhane ka andaj sabse alga
Sabse jabrdst h👌🏻👌🏻
Thank you so much
Aapko wajh se sikhne me b mja ata h
Warna to borring hi ho jata h insan
Very KNOWLEDGABLE video.. thanks
Excellent presentation 😊
Wonderful insight on Pivot chart n Table...
i have watched the complete video. well explained in detail. thank you sir.
Half time tak moja a gaya guru G.. Thnq
A better learning video than other
Thanks a lot
Pehli bar me hi sikh gya hu sir, thanks Sir 🙏
Thnks sir ...i always learn something new from your video's with your funny style. 🙏🏻🙏🏻
You are my favourat teacher from Bangladesh
Sir kbhi kbhi koi movie dekh ke bhi bore ho jate h but........
apki video dekh ke kbhi bore nhi hote 😀
Apki sari videos bohot helpful hoti h humare liye.
THANK YOU SO MUCH 💯
Amazing maza aa gya ye Sikh k ❤️
Sir, Really I don't have the words to describe about your teaching, really it's unbelievable and amazing. The way you explain, it's like Maska. I am getting lot of things to learn from your channel, that too without paying a single penny to anyone. I don't think so that in private class also they will teach like this. Your teaching style is amazing, "BOLE TO EKDAM HATKE" I am really thankful to you sir.
Keep going sir and God Bless you sir.
One of the easiest and well defined video on PIVOT TABLE. Thanks for uploading.
Sir the way you teach it's a simple and unique way of teaching hats off to you sir for this video .
very useful video for me I know about pivot table but don't know how to use ...Thank you so much sir for making this video....
Hats off Sir, very clear description
Wounderfull Explaination Sir, Thank-You
This video for beginners absolutely great thanks and I like your teaching...
Very precious video for excel student thanks for this video