Pivot Table Excel in 28 Minutes - Pivot Table Excel in Hindi

In this tutorial, we will learn about in-depth tricks of Excel Pivot Table in 30 minutes for Beginners to Advanced users. Learn everything about Excel Pivot Table in 30 minutes.
Check out our 21 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We Covered the following topics:
00:11 Introduction Pivot Table in Excel
00:17 Pivot Table Basics to Advanced Tricks
00:44 Pre-requisite - Data Set Format, Headings
01:24 How to Create Pivot Table
01:46 Why activate Classic Layout?
02:51 Understanding the 4 Layouts
04:21 Mathematical Calculations in Pivot Table
06:30 Pivot Chart using F11
07:04 Grouping (Numbers) in Pivot Table
08:54 Drill-Down in Pivot Table
09:20 Pivot Table Setting: Fill empty cells with 0
10:21 Grouping (Dates) in Pivot Table
11:24 Pivot Table Setting: Show Items with No Data
12:00 How to use Filter in Pivot Table
13:45 How to Move & Rename Headings in Pivot Table
14:39 Grouping (Text) Pivot Table
15:49 Slicers & related Pivot Table Settings
17:15 How to use Timeline in Pivot Table
18:17 Applying Basic Conditional Formatting
18:34 Pivot Table Design & Formatting
20:07 Subtotals in Pivot Table
20:32 Expand Collapse
21:13 Pivot Table Setting: Report Layout
21:43 How to Refresh & Change Data Source in Pivot Table
23:49 Pivot Table Setting: Disable Autofit Column widths
24:28 Creating 100s of Pivot Table reports in less than 1m
26:20 Pivot Table Setting: Disable =GETPIVOTDATA() for formula writing
Check out our 19 hrs. Full Excel Course in Hindi - bit.ly/3hGGsPg
MS Excel - Pivot Table (A-Z) | Pivot Table Tutorials
#Excel #pivottable #excelinhindi
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org/
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

[@ExcelSuperstar]

Check out our 19 hrs. Full Excel Course in Hindi - bit.ly/31UflrO

[@ArifuddinMohammed]

Not just 28 minutes every second I learned from you. Few of them I know before. Last trick is the main event. Now I can dominate my seniors in work. Don't think about the time duration I even watch Advertisement without skip only for your video because you don't give us entertainment you give us knowledge. Thank you

[@nikhilmathur7265]

Thank you bhai, it could save my career

[@itsofficialsaini]

Sir can you please provide tally course basic to advanced 🙏🙏🙏

[@tanveerdar13]

Can you send the employee list file?

[@mihirrpatel7770]

00:00 Intro & Basic info 1:22 Insert Pivot table & its Layout 4:19 Select/Arrange data for pivot table 7:02 Making Groups ( Numbers ) 10:19 Grouping ( Dates ) & Drill down 13:45 Grouping ( Text ) & Rename/Move heading 15:22 Slicer & Timeline 18:00 Design/Formatting/Subtotal 21:45 Refresh & Change data source 23:49 Report Filter Pages

[@virendrahardiya2797]

मैने पहले इतने बेहतरीन ढंग से पिवोट सिखाते नहीं देखा किसी के द्वारा, बहुत बहुत धन्यवाद Sir,

[@vinay103]

Bahut achchha laga. Very helpful video. Thanks

[@vikaasb2016]

Never have I even seen any learning class being so comprehensive and organized ...blessing for every learner ..Thank you so much for this !!Hats off !!!!

[@user-jc6te1vm8v]

this is amazing sir...... today felt like i knew nothing abt pivot table..... thnku so much

[@ShubhamSharma-ls6hj]

Very well explained looking forward for more content like this on pivot table itself. THANKS ✌️

[@rahmanzafar]

You are a real teacher, the way you explain this in a few minutes I really want to Siluet to you sir. I have learned almost all the 26 steps same as ABC, Thank you very much for your dedication.

[@rajeshsingh4394]

Hey hi, God bless you for your great work. You have a excellent knowledge and communication skills. Thank you so much from the bottom of my heart.

[@lovegupta2115]

Thank you so much for this video Lots of learning in short period of time Clear and cristel way to explain each points. Big thumps up to you 👍🏻

[@baskaranloganathan354]

Amazing explanation in short span of time, excellent session so far i've viewed.

[@mariantonys]

Bahut bahut Dhanyavad aapko mere Dost. You have shown today a new direction in my understanding of PivotTable. Thanks for your patient and clear explanations. God bless you.

[@tmniy]

seriously sir you are the best. i have learnt a lot more deep knowledge from your video. i wish other youtubers could learn your style which is "seedhi baat no bakwaas" because i click these videos for knowledge and not for fun. God bless you and keep growing. I wish all the success to you and to your channel.

[@Itisme177]

Thank you so much for this upload 🙏

[@BakwasBlog]

Hey Rishabh, I was already a fan, but after watching this Video I respect you also, What a video, Holy grail.... Anyone using excel must watch this, shared it with all my friends in Finance, HR, Operations

[@umairqureshi7597]

yaar what a amazing, kamaaaal

[@sampradhan5840]

@Excel superstar.. Such a clear explanations.. This is really informative and helpful.Keep it up Sir

[@avneeshsingh7051]

Many much new things to know. Thank you so much for such a wonderful learning video. Now I may make my reports more easily and fastly.

[@kamalkantsati]

best 26 minutes utilised today by me through your video.. thanks a lot..

[@ftcakhi]

Dear Thanks a Lot to explain this one in detail in such a simple way.. now i could proudly say.. i know Pivot Tables.. Thanks buddy..

[@kashifullabaig4370]

I must say that you are a quintessential teacher with profound knowledge of excel and you know how to honor your instincts with teaching that to free of cost

[@niharikajaisinghani6843]

I've gone through many videos for the Pivot table this was honestly the best, clear and amazing explanation without any confusion.. Amazing work 😁👍

[@SuperBassfanatic]

You explained everything with such clarity. Loved the session and it was worth every second. Thank you.

[@basis_tech4555]

Only one thing in my mind - God bless you with good health and happiness in your life... without any tuition fee you are sharing your expertise... good learning experience with your explaination... Thanks alot!!

[@devashishdas9324]

Really awesome... Ur teaching style is crisp and to the point!! Kudos to your work

[@qamarhashmi3478]

Zabardast Bhai, Weldon

[@nareshhaseja5827]

Thanks a ton brother... It was worth every second... Thanks once again for your time and efforts.

[@himangshustory9423]

Excellent Sir...Definitely it's helpful for me... Thank you for your valuable lesson

[@Real-ZiX]

You are my favourite now. Thankyou!

[@jyotichaudhari1780]

Amazing too good bohat hi acchi information di 👌

[@hariprasad8211]

Very informative. Keep update the tricks in excel. Hats off to sharing.

[@hemantsrivastava4233]

kya baat hai ,maja aa gaya,video was very informative kahi or jaane ki jarurat hi nahi padi boss ,thanks bro.

[@kingcinema5295]

apke pivot smjhane ka tarika bohot hi acha he or asani se samajh aane wala he mjhy jo doubt the pehle isme wo clear hogae thanks a lot

[@TheAnubhav3]

I loved the way of your teaching Rishabh Sir! Thank you

[@pradhansunil]

Fabulous Sir, somany problems solved by ur lessons, thanx and keep sharing and keep us healthy and fit for the jobs.

[@ganeshugale3257]

Kya bat hai Sir.. Cha gaye Aap..!!!

[@2212shashi]

Awesome Sir, Video is a treasure of pivot table.

[@IrfanKhan-wv8rh]

Thank you so much sir, What a teaching method. absolutely superb.

[@anjumaurya8154]

Amaging video and yes your work is appreciable

[@milinddhabadgaonkar8323]

So simple and easy to understand .... Thank you

[@shubhambhavsar4953]

very nice Explanation. Your voice and communication skill is so pure. thank you for this video.

[@mohitseventeen]

Thank You, your way of explanation is very good.

[@NUncle_vlogs]

Short, to the point and perfect and clear to understand tutorial. I have subscribed to your channel.

[@shwetashorts8341]

Very easy and informative video. Thanks a lot !

[@rakeshkumar-zd8mj]

Awesome video.Very informative and easy to follow.Thank you for sharing your knowledge.🙏🙏🙏🙏

[@atulnehra]

Super. Very nicely explained. Keep up the good work. Loved the lesson. Thanks

[@nileshtrivedi6079]

One of the best teachers ever seen. brother I m HR mgr, lost job, practising for intvw. u helped a lot.

[@mahendrasinghchouhan1615]

Sir your great man APP NE.GOOD VEDIO BANAYA

[@ashujoshi1632]

Wow, great knowledge, thanku sir we keep learning from you sir

[@SunilKumar-nv2zp]

Amazing Thank you for making this helpful video

[@ArmanKhan-iq3ji]

Really I love this video 😍😍😍 thank you so much for this information. 💐💐

[@devendoshi4203]

thank you very much, very well explained in logical and methodical way........

[@bhawanithakur001]

Super Clear concept Thankyou Sir

[@mohammedkhan4932]

Excellent way of teaching.And the almighty God has given you nice voice.May God bless you Sir.

[@khurramshahzed4925]

from last couple of day, trying to learn povit table on you tube, at least today i found the right person, great man

[@AsifKhan-fl8ef]

Thanks Excel superstar, It is best ever Pivot table video i have ever watch with so much details knowledge

[@deelipprajapati8011]

Fantastic Thank you for sharing!!!

[@infoaccts]

بہت عمدہ، سمجھانے کا انداز پسند آیا، کئی ٹرکس مجھے معلوم نہیں تھے۔

[@rajuorao3695]

Very helpful this video to know more about pivot table 👍

[@abhijitkar5289]

Great. Thanks for the tricks 🙏

[@sambitrath4844]

Unbelievable. Bhai. The mystery of pivot explained so easily. 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻

[@shubhamshukla3368]

very good video. very informative and practical knowledge. may GOD bless you a healthy and prosperous life.

[@saidulislamkhan4278]

Thank you. So helpful.

[@jhumpatumpamaity5597]

Thank you so much sir. For this valuable and informative vedio 🙏

[@Abdul_Qadoos_Wazir]

Such an informative lecture no doubt

[@CAamitrout]

It could not get any better. Thank you

[@shagunmehta1781]

Excellent, very useful techniques. Thanks for sharing. :)

[@niranjandas426]

Very clear & tricky Lesson. Really great

[@govindsailoni3438]

Great learning.

[@ketanupadhyay5423]

great video. happy to see from Canada.

[@premashishgupta3929]

Now I could have learn the Advance pivot, otherwise basic video are only available on utube. Good job👍

[@mohanpal2737]

Such really very helpful vedio..appriciate

[@sunilm1977]

Very much informative and detailed video.

[@hannansaiyed9248]

Dear very well explained.. Thank you so much 🙏

[@padamkhandgaonkar7335]

Very Important video and channel to learn MS Excel..Best Luck

[@mypower6173]

Its really amazing, the way you explain,. I love it , thank you so much

[@rithikgodimani6385]

Worth watching video thank you so much sir

[@santisudheeryadav9788]

Rishabh sir Really!you made very useful video Great job💯👍👍

[@shankarbornfree8015]

Awesome brother. Crystal clear

[@smrutibarik8202]

Excellent elaboration for easy way to understand pivot table...

[@jeetendra142]

Gajab knowledge. Thank you

[@ARIFSAIFIFARHAN]

It's an amazing session to update the traditional approach into the data and get updated on

[@josephlobo3703]

Excellent - one of the best

[@nadeemjohn6126]

Excellent video and teaching style.

[@majid7783]

Very informative video for my office work. Thanks dear ❣️

[@AllInOne-ce1ur]

Too much knowledge of pivot now .. thank you sir for such informative videos of excel.

[@AnkitGupta-jx3om]

very very comprehensive, easy to understand and catchy content on Pivot table, HATS OFF

[@sunilkhare7491]

Excellent information in such a short time that too in a very interesting way. Thank you very much dear Rishabh.

[@fahadatique3090]

Zibardast , excellent tips n trick. No doubt it's Humanity severing 👏👏👏

[@navedahmad3155]

Thanks alot..👍❤️.. worth watching..

[@DilipKumar-fp1xe]

I have never seen Pivot table in such a format ........it's amazing

[@aliahamad9373]

These are very very useful tricks... Thanks u so much sir

[@dheerajgupta1494]

what a great way of education!!

[@daynight6875]

Very useful video for me..... thenks sir 👍👍👍👍

[@manmeetsinghrana7772]

Excellent 👌 ur way of teaching is fabulous

[@simranshriwas3683]

Thanks 😊 really helpful..

[@SuperMammoos]

Dear brother.. Let me share my heartfelt thanks for this vdo, which i got an important and useful trick (point#21- formula disabling) This is what i was searching for a solution since long time. Thank you very much brother and God bless you May god gives bright future to you..🙏

[@hemantrawat8355]

Very helpfull❤️& Thank you

[@abhishekbraj8564]

Awesome lecture bhai... 🙏

[@santisudheeryadav9788]

That's great! You taught excellent rishabh sir I thank you very much 🙌🙌

[@mr_pawar_3]

Thank you sir... Apne bahut asan kardiya description me pura details deke... Bahut hard work karte ho sir app...😍