Pivot Table Basic to Advance in excel | What is Pivot Table in Excel Explained in Hindi

Pivot Table From Basic to Advance in excel | What is Pivot Table in Excel Explained in Hindi
Friends, Pivot Table is a very useful and important feature of Excel, which many people do not know about. Pivot Table is used a lot of data analysis in Excel or for creating reports in MIS. So that's why I have made a Full tutorial video of Pivot Table in Excel in Hindi. In this video you will learn how do you analyze the data in Pivot Table, Pivot Chart, Slicer & Slicer setting, Timeline, Pivot Table Options/Setting, Grouping, Custom Grouping, Pivot Field, Show value as etc. all this is explained in great detail.
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
#pivottable
#excelpivottable
#excelpivot
Timestamp
00:00 Introduction - 1
06:53 Excel Pivot Table - 2
22:38 Excel Pivot chart - 3
30:28 Slicer & Slicer settings - 4
48:08 Timeline in Pivot Tale Excel - 5
54:52 Grouping, Custom Grouping - 6
01:02:52 Pivot Table Options/Setting - 7
01:21:42 Show value as - 8
01:36:05 Calculated Fields - 9
01:46:14 Filter & filter reports Page - 10
01:54:30 Dynamic Pivot Table -11
02:04:34 Pivot table on Multipal sheet - 12
02:15:24 Getpivotdata Formula in Pivot Table - 13
02:24:02 Auto Refresh Pivot table -14
02:28:09 Creating Dashboard using Pivot Table. -15
All Excel Old videos Practice Files are available Inside "Skill Course" App
Follow the steps in order to download Satish sir All Videos Practice Files :
Download "Skill Course" app from Play Store - Home Tab - Study Material - KZbin Channel Practice Files - Learn More Channel Practice Files - All OLD Videos Excel Practice Files
Use Power Query in Excel 2010 & 2013 : • How to merge data in E...
------------------------------------------------------------------------------------------------------------------------------
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/
------------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our 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
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My KZbin 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

[@Learn_More_Pro]

Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

[@nil_auto]

Yes 👍

[@LOKESH_SAIN_BUNDI]

Sir aapke pass Microsoft office ka konsa version hai or Excel ka konsa version hai please mujhe bataye

[@Learn_More_Pro]

@@LOKESH_SAIN_BUNDI Excel 2021 Hai ji

[@MithleshKumar-bw2uo]

Sir mujhe aapka online class join krna chahta hu To kaise join apply kr skte hai pls suggest me sir

[@IQLEVEL108]

Yes sir jay hind sir

[@tapankumarsengupta2106]

I think Mr.Satish is great and No.1 excel expert in our country.

[@web3_gamer]

Exactly

[@vinayagamk9825]

Sir, Lots of Thanks from my bottom of the Heart. I have no word to appreciate you. You are Great Sir.

[@joanarun1]

Yes sir.... thankyou... Apki videos ke karan hi mera selection BI me ho paya he.... Bahut bahut shukriya!!!!

[@mananambani6858]

Powerful Video For Learning Powerful Concept Of Excel In Easy Way. Thank You Very Much Sir For Making This Master Piece... 🔥🙌❤️

[@NEERAJKUMAR-fz6nb]

Definitely best way to transfer knowledge and a good job that any person can do by transferring their knowledge to society ❤❤❤

[@amittailor5054]

Sir I am working in the construction industry ,your video solves my data problem .now i am playing well with data

[@avalonharps9309]

Very well made video. Thank you for your time and investment to teach us all!

[@OmprakashKumar-ze5om]

Thank you sir ji video banane ke liye 👏👏

[@prateekraj8011]

Thanks sir, really it is a value addition video in excel. Appreciate your efforts.

[@sagarrody]

Great , Thank you so much for sharing knowledge 🙏🏻

[@adityavarma461]

Guru ji aapke samjhane Ka way sabse excellent hai because aap deeply explained with logic lagake samjhate ho thanks guru ji

[@anchalrawat5482]

Mind blowing sessions , stepwise flow, clear presentation and interpretation. Great Efforts sir. I just love it.

[@abhishekpanda1920]

Sir, you teach so simple and smoothly. Continue this.

[@ashfaque7411]

I'm watching the video now, and pivot table auto width settings felt awesome and useful. I have liked and subscribed after seeing that. will continue the video.

[@baatcheet202]

I appreciate sir!!!!!!, even such solid content we are not getting in paid classes

[@sunnypandit8033]

Sir hats off to you...bhot hi badhiya tarike se ap sub kuch padhate aur sikhate ho... Sir main to apka fan hogaya...🙏🙏🙏

[@falamswati]

Thank you for your dedication and hardwork. Very appreciated 👍☺️ easy to understand

[@nsrdpatel8048]

Superb 👏👏👏👏👏👏👏👏👏👏👏 thank u thank u so much sir... Very very veryyyy valuable informations..... Sikh ke dill khush ho gaya

[@robinkkoshy1]

Thanks a lot for making such a useful videos 👍

[@naveedanjum4762]

THANK YOU SO MUCH AP KA GUID KRNY KA TREEKA BOHAT ACHA HY

[@kanchankumarimishra3738]

u truly deserve sir..... whenever i feel to know about any topic i just come to Ur channel

[@arjunjadhav3639]

Highly appreciated work Good presentation skill

[@biplobkumar5728]

This vedio is so good for learning pivot table- Thanks Satish sir.

[@balancemyself]

sir ap bhohut achaa video banate ho mai ap se excel sikha hu basic advance sikh raha hu . ap ko dill se dhanyabad.

[@vikasgawaria5330]

Very very logical and magical video sir thankyou

[@UsmanGhani-vf3ow]

Sir, we love of your teaching method

[@Avni_Alisha_Avantika]

Just simply superb and very useful, very descriptive way of explaining...

[@meenakshiqueenrasoi]

Bahot kuch sikha hai aap se aap ka bahot bahot Dhanyawad hai 👌👌👌👌👌👌👌👌👌 beautiful 👍👍👍👍👍👍👍👍

[@pawantembhurne6828]

Fabulous sir. very nice dashboard and report. Thanks for sharing such valuable information.🙏🙏🙏🙏

[@MehwishfishingClub]

Thank you very soo much ❤🎉 bohot zabardast sir

[@RajeshKumar-ve1dm]

Thank you sir apke video se bahut kuch sikh rahe hai

[@DHAMALONKARSHANKAR]

Thanks a lot sir for proper guidance!!

[@muhammadariffiaz9260]

very good lecture. God Bless you

[@UsmanGhani-vf3ow]

Sir, we are hardly waiting of your video on Power Pivot. Thank for happy news in advance you give to us about Power Pivot

[@kabirsahib1552]

👏 Sir aap ka dhanyawad

[@Hiren859]

Bohut badiya sir I love your every content

[@md.taifuranam7904]

Thanks Dada! Your teaching method is awesome.

[@sumitsingh7775]

Very very good sir ye video dekh kar mujha bhut profit hua ka Apna company ko data dekhana ma

[@sapnapurigoswami6946]

Sir aap bahut accha sikhate ho . excellent sir

[@pawantembhurne6828]

Great Video and superb explanation Hats off you 💯💯💯

[@meenakshiqueenrasoi]

Sir ji Namaskar aap ke sare video's mene dekhe hai 👌👌👌👌👌👌👌👌👌👌 beautiful 👍👍👍👍👍👍👍👍👍 bahot badhiya video banaye hai 👌👌👌👌👌👌 beautiful super duper 👍👍👍👍👍👍

[@arifurrahman7353]

An awesome course that is helpful for the learners.

[@sagarinsa7419]

Thankyou so much for giving me knowledge ,, pivot table ❤

[@user-qg1cp7fu5e]

Bro bahut sweet video banate ho acha lagta hai ap ki video aur nic shikhate ho best video

[@tanhatanha1970]

Satish very well explained. xtra ordinary work. dhanyawaad bro.

[@ankitmenariya7600]

Very informative video thank you so much.

[@narayanlakhotia3832]

You are genius Sir. Very easy teaching.

[@perceptionpics05]

Your way of teaching is excellent. God bless you...

[@sonnath2863]

Thank you so MUCH Sir 👌😊🙏

[@nickbell6311]

One of best tutorial on excel on KZbin channel

[@sharmamohit1910]

Really Appreciate your efforts 💯

[@jaisramyadav2802]

BAHUT ACCHA HAI SIR MAJA AA GYA

[@sharmafaqirchand8240]

Very knowledgeable video. You are genius.

[@IbteshamAhmad]

Thank you sir for this valuable video.

[@itsvinitsingh]

Sir we love you sir 🙏🙏 Thank you so much ❣️

[@LearnEasyway17]

Bht acha sir sikhta ha

[@arvindkumartiwari9793]

वास्तव में आपका वीडियो हमारे लिए बहुत काम आता है

[@Bachchaparty2023]

Thanks a Lot Sir For this Video

[@ejazhaq1160]

Satish Bahi, bohat baddiya, aap jaisa gyan kahin kahin milta hai

[@rajeevgosavi4514]

Too good. Very professionally explained.

[@SantoshKumar-ff5nf]

Khatarnak sir ji👌🔥

[@hannoosinghuikey7573]

Great hai aap sir

[@ManeeshKumar-bq1by]

इतनी मेहनत लगी है तो आपको लाख लाख शुक्रिया

[@syedmuzammilzainvi4777]

Dear Satish, This video is wonderful, everything in a single shot. Your way of teaching is marvelous and an old man like me understands in one go. I am a retired Engineer from UP Power Corp. aged about 72. I am learning through your videos from long and could do work for my deptt. after learning from your vides. Thanks and Jio

[@FreesoulRavin]

uncle jee salute to your dedication

[@sumantdungdung2636]

Very nice video I got clear idea and I was really wandering to get this type of video. Thanks a lot

[@kuldeeppoorwa8914]

thanks sir ....keep making these types of videos

[@mahimashetty8332]

Thank you Sir, very helpfull video

[@hemalsinhumedsinhpadhiyar8477]

Appreciate your efforts.

[@harindrasingh5343]

Most important topics.thank you

[@utpalnath6437]

sir ur classes are awesome.. very helpful

[@Officialgranth]

Thankyou so much sir 🙏

[@akashkaundal2373]

you explained very well.😍

[@Techandcool]

Jabardast Sir jee

[@Anjali-pp7uh]

The best teacher 🙏🏻🙇‍♂️

[@saurabhdabas4440]

Sir , Thanks YOU so much , Your all vedios are so quality vedios, YOU are so hard working and gentleman person.❤❤👌👌👍👍

[@Learn_More_Pro]

Thanks a lot saurabh ji

[@SangitaSingh-mv7rc]

Satish Sir, your teaching style is very nice.......👌🏻👌🏻👌🏻

[@harshsonara6854]

Thank you so much sir I am a CA article This was incredibly helpful

[@akashgodave3967]

Superb Sathish sir thank you so much

[@sumansharma9585]

Thank you sir, I learned this last year from you and did really used at my accounting job, now using Power BI, you really did a great job to teach millions of students who cannot afford real-time classes for all these techniques of modern world. Stay happy, healthy and blessed always keep it up 🙏🙏

[@educationmathsphysicst.k]

Bsc students sikh skte hai mam

[@sheetalyadav3367]

Sir thanks so much Aapne is video ke madhyam se bohot accha samjhaya plz or video Banaiye Aapki video ke liye 1 Nahi 1000 like diya Meri or se thanks so much again

[@krishnatamrakar2524]

Superb ! Keep Uploading Such A Wonderful Tutorials 👍

[@sharmamohit1910]

We really love your efforts keep growing

[@sanjibanworld]

Many many thanks..

[@aaliyakhan7647]

thnku so much its helpful

[@ShahidAli-tg1qj]

Downloaded your vedio.. Very useful topic

[@kumarmunna8236]

Bahut badhiya

[@shortvideo3485]

Thank you sir😊🙏

[@muhammadzubairkhan3136]

Thanks a lot Satish Sir

[@crazycartoonstories122]

This video deserves more likes 👍 👌 👏 👍

[@gouravarora4289]

Too much useful 😊❤️

[@KhanKhan-xo9tb]

you are great sir very informative video sir

[@indiasanichem491]

Very effective ., Thanks

[@aarifakhan4192]

Great Satish ji. Really appreciate 😊

[@arsunny100]

Salute you sir... From Pakistan

[@KrishnaSharma-lf5jl]

simply amazing 🔥🔥❤‍🔥❤‍🔥

[@barun4095]

Salute u sir.....

[@adityabhadange9514]

Very Good Sir...❤ I am going to download

[@AyushmanThakur-mo3ee]

Thanks a lot sir ji ❤❤

[@india_tour2238]

Kbhi sochta hu ki agar aapne channel nhi chalu kiya hota to hme itna acche se kon samjaya 💯❤️