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

Рет қаралды 325,191

3 жыл бұрын

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

Пікірлер: 569

@ExcelSuperstar 3 жыл бұрын

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

@ArifuddinMohammed 3 жыл бұрын

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 3 жыл бұрын

Thank you bhai, it could save my career

@itsofficialsaini 2 жыл бұрын

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

@tanveerdar13 2 жыл бұрын

Can you send the employee list file?

@mihirrpatel7770 2 жыл бұрын

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 3 жыл бұрын

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

@niharikajaisinghani6843 2 жыл бұрын

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

@vinay103 3 жыл бұрын

Bahut achchha laga. Very helpful video. Thanks

@ShubhamSharma-ls6hj 3 жыл бұрын

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

@vikaasb2016 2 жыл бұрын

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

@rajeshsingh4394 3 жыл бұрын

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.

@baskaranloganathan354 3 жыл бұрын

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

@kingcinema5295 2 жыл бұрын

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

@lovegupta2115 3 жыл бұрын

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 👍🏻

@Itisme177 3 жыл бұрын

Thank you so much for this upload 🙏

@basis_tech4555 3 жыл бұрын

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

@user-jc6te1vm8v 3 жыл бұрын

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

@NUncle_vlogs 3 жыл бұрын

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

@himangshustory9423 3 жыл бұрын

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

@BakwasBlog 3 жыл бұрын

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

@avneeshsingh7051 2 жыл бұрын

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.

@hemantsrivastava4233 2 жыл бұрын

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

@qamarhashmi3478 3 ай бұрын

Zabardast Bhai, Weldon

@devashishdas9324 2 жыл бұрын

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

@rahmanzafar 2 жыл бұрын

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.

@mariantonys 3 жыл бұрын

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.

@kamalkantsati 3 жыл бұрын

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

@sampradhan5840 3 жыл бұрын

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

@infoaccts 3 жыл бұрын

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

@atulnehra 3 жыл бұрын

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

@nareshhaseja5827 2 жыл бұрын

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

@jyotichaudhari1780 2 жыл бұрын

Amazing too good bohat hi acchi information di 👌

@ganeshugale3257 3 жыл бұрын

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

@hariprasad8211 3 жыл бұрын

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

@IrfanKhan-wv8rh 2 жыл бұрын

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

@mohitseventeen 3 жыл бұрын

Thank You, your way of explanation is very good.

@ftcakhi 3 жыл бұрын

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

@TheAnubhav3 2 жыл бұрын

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

@mahendrasinghchouhan1615 2 жыл бұрын

Sir your great man APP NE.GOOD VEDIO BANAYA

@SuperBassfanatic Жыл бұрын

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

@shwetashorts8341 3 жыл бұрын

Very easy and informative video. Thanks a lot !

@milinddhabadgaonkar8323 3 жыл бұрын

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

@shubhambhavsar4953 3 жыл бұрын

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

@mohammedkhan4932 2 жыл бұрын

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

@Real-ZiX Жыл бұрын

You are my favourite now. Thankyou!

@pradhansunil 2 жыл бұрын

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

@anjumaurya8154 Жыл бұрын

Amaging video and yes your work is appreciable

@rakeshkumar-zd8mj 2 жыл бұрын

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

@rajuorao3695 3 жыл бұрын

Very helpful this video to know more about pivot table 👍

@shubhamshukla3368 3 жыл бұрын

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

@mohanpal2737 3 жыл бұрын

Such really very helpful vedio..appriciate

@kashifullabaig4370 2 жыл бұрын

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

@umairqureshi7597 2 жыл бұрын

yaar what a amazing, kamaaaal

@abhijitkar5289 3 жыл бұрын

Great. Thanks for the tricks 🙏

@sudipatanag2091 2 жыл бұрын

Excellent 30 minutes compact learning ,Rishab Ji

@mypower6173 2 жыл бұрын

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

@saidulislamkhan4278 2 жыл бұрын

Thank you. So helpful.

@ashujoshi1632 3 жыл бұрын

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

@niranjandas426 2 жыл бұрын

Very clear & tricky Lesson. Really great

@manishgupta1902 3 жыл бұрын

Thanks Rishabh ji

@SunilKumar-nv2zp 2 жыл бұрын

Amazing Thank you for making this helpful video

@govindsailoni3438 3 жыл бұрын

Great learning.

@deelipprajapati8011 2 жыл бұрын

Fantastic Thank you for sharing!!!

@sambitrath4844 3 жыл бұрын

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

@tmniy 3 жыл бұрын

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.

@bhawanithakur001 2 жыл бұрын

Super Clear concept Thankyou Sir

@nadeemjohn6126 3 жыл бұрын

Excellent video and teaching style.

@jeetendra142 3 жыл бұрын

Gajab knowledge. Thank you

@CAamitrout 3 жыл бұрын

It could not get any better. Thank you

@devendoshi4203 Жыл бұрын

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

@sunilm1977 2 жыл бұрын

Very much informative and detailed video.

@shagunmehta1781 2 жыл бұрын

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

@sanjaysaindane8812 2 жыл бұрын

Worth. Thanks

@2212shashi 2 жыл бұрын

Awesome Sir, Video is a treasure of pivot table.

@Abdul_Qadoos_Wazir 2 жыл бұрын

Such an informative lecture no doubt

@navedahmad3155 3 жыл бұрын

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

@shankarbornfree8015 3 жыл бұрын

Awesome brother. Crystal clear

@ketanupadhyay5423 2 жыл бұрын

great video. happy to see from Canada.

@kedarkori5284 3 жыл бұрын

Sir excellent thank you for your tricks

@hannansaiyed9248 2 жыл бұрын

Dear very well explained.. Thank you so much 🙏

@rithikgodimani6385 Жыл бұрын

Worth watching video thank you so much sir

@DilipKumar-fp1xe 3 жыл бұрын

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

@daynight6875 3 жыл бұрын

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

@simranshriwas3683 3 жыл бұрын

Thanks 😊 really helpful..

@hemantrawat8355 2 жыл бұрын

Very helpfull❤️& Thank you

@mdtausifraza9163 3 жыл бұрын

Best video in youtube. Sir mai mai Am ki taiyari kar raha hun jisme mujhe aapki video se bahut help milti hai .

@sandeepbhargava2714 2 жыл бұрын

Amazing very well explained

@toufeeqkhan9735 3 жыл бұрын

Thanks a lot for this video

@josephlobo3703 2 жыл бұрын

Excellent - one of the best

@AshishGupta.007 3 жыл бұрын

awesome video thank you so much boss

@tultul03 2 жыл бұрын

Very helpful info.

@smrutibarik8202 2 жыл бұрын

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

@ArmanKhan-iq3ji 2 жыл бұрын

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

@pkumarchaudhary2010 3 жыл бұрын

Great way of explanation

@ahmedabidi3421 Жыл бұрын

Excellent vedio thanks

@subhashsmirth8188 3 жыл бұрын

Thanks sir , Great

@abhishekbraj8564 3 жыл бұрын

Awesome lecture bhai... 🙏

@goldrush4513 2 жыл бұрын

great help

@ARIFSAIFIFARHAN Жыл бұрын

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

@nileshtrivedi6079 2 жыл бұрын

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

@daujipandey1973 2 жыл бұрын

Thnx for creating thats kind of vedio's

@mohan8887 3 жыл бұрын

Amazing vedio

@jhumpatumpamaity5597 Жыл бұрын

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

@dineshar3455 3 жыл бұрын

awsm sir thank u..