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

Пікірлер: 566

  • @ExcelSuperstar
    @ExcelSuperstar3 жыл бұрын

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

  • @ArifuddinMohammed

    @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

    @nikhilmathur7265

    2 жыл бұрын

    Thank you bhai, it could save my career

  • @PawanSAINI-ng9fq

    @PawanSAINI-ng9fq

    2 жыл бұрын

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

  • @tanveerdar13

    @tanveerdar13

    2 жыл бұрын

    Can you send the employee list file?

  • @mihirrpatel7770

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

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

  • @vikaasb2016
    @vikaasb20162 жыл бұрын

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

  • @kingcinema5295
    @kingcinema52952 жыл бұрын

    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

  • @basis_tech4555
    @basis_tech45553 жыл бұрын

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

  • @niharikajaisinghani6843
    @niharikajaisinghani68432 жыл бұрын

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

  • @mihirrpatel7770
    @mihirrpatel77702 жыл бұрын

    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

  • @Shashankbaranwal

    @Shashankbaranwal

    10 ай бұрын

    🎉😊 Huge 😅Thaaaaaaaank

  • @user-jc6te1vm8v
    @user-jc6te1vm8v3 жыл бұрын

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

  • @BakwasBlog
    @BakwasBlog3 жыл бұрын

    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

  • @hemantsrivastava4233
    @hemantsrivastava42332 жыл бұрын

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

  • @sudipatanag2091
    @sudipatanag20912 жыл бұрын

    Excellent 30 minutes compact learning ,Rishab Ji

  • @infoaccts
    @infoaccts3 жыл бұрын

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

  • @Itisme177
    @Itisme1773 жыл бұрын

    Thank you so much for this upload 🙏

  • @jeetendra142
    @jeetendra1423 жыл бұрын

    Gajab knowledge. Thank you

  • @vinay103
    @vinay1033 жыл бұрын

    Bahut achchha laga. Very helpful video. Thanks

  • @baskaranloganathan354
    @baskaranloganathan3543 жыл бұрын

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

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

    You are my favourite now. Thankyou!

  • @ShubhamSharma-ls6hj
    @ShubhamSharma-ls6hj3 жыл бұрын

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

  • @daujipandey1973
    @daujipandey19732 жыл бұрын

    Thnx for creating thats kind of vedio's

  • @kamalkantsati
    @kamalkantsati3 жыл бұрын

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

  • @rahmanzafar
    @rahmanzafar2 жыл бұрын

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

    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.

  • @padamkhandgaonkar7335
    @padamkhandgaonkar73352 жыл бұрын

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

  • @kashifullabaig4370
    @kashifullabaig43702 жыл бұрын

    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

  • @mariantonys
    @mariantonys3 жыл бұрын

    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.

  • @shyamagarwal5779
    @shyamagarwal57792 жыл бұрын

    Maine KZread per bahut Sare channel Dekhe lekin sabse Achcha Excel ka Samjhane Ka Tarika Aapka Hai... Thanks

  • @govindsailoni3438
    @govindsailoni34382 жыл бұрын

    Great learning.

  • @mdtausifraza9163
    @mdtausifraza91633 жыл бұрын

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

  • @sambitrath4844
    @sambitrath48443 жыл бұрын

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

  • @himangshustory9423
    @himangshustory94232 жыл бұрын

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

  • @mohammedkhan4932
    @mohammedkhan49322 жыл бұрын

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

  • @DilipKumar-fp1xe
    @DilipKumar-fp1xe2 жыл бұрын

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

  • @nileshtrivedi6079
    @nileshtrivedi60792 жыл бұрын

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

  • @sudiptamishra07
    @sudiptamishra073 жыл бұрын

    The Best Excel Tutor. Sharp, Precise and sure.

  • @ExcelSuperstar

    @ExcelSuperstar

    3 жыл бұрын

    Wow, thanks!

  • @AmitGupta-bl2iu
    @AmitGupta-bl2iu2 жыл бұрын

    Best explanation sir INDIA🇮🇳 Best Mentor

  • @hariprasad8211
    @hariprasad82113 жыл бұрын

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

  • @lovegupta2115
    @lovegupta21152 жыл бұрын

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

  • @2212shashi
    @2212shashi2 жыл бұрын

    Awesome Sir, Video is a treasure of pivot table.

  • @ftcakhi
    @ftcakhi3 жыл бұрын

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

  • @tmniy
    @tmniy3 жыл бұрын

    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.

  • @qamarhashmi3478
    @qamarhashmi34782 ай бұрын

    Zabardast Bhai, Weldon

  • @avneeshsingh7051
    @avneeshsingh70512 жыл бұрын

    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.

  • @devashishdas9324
    @devashishdas93242 жыл бұрын

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

  • @mohammadshahzeb2459
    @mohammadshahzeb24592 жыл бұрын

    Sir! U have amazing knowledge. From Pakistan

  • @dheerajgupta1494
    @dheerajgupta1494 Жыл бұрын

    what a great way of education!!

  • @TheAnubhav3
    @TheAnubhav32 жыл бұрын

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

  • @ganeshugale3257
    @ganeshugale32573 жыл бұрын

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

  • @toufeeqkhan9735
    @toufeeqkhan97353 жыл бұрын

    Thanks a lot for this video

  • @devendoshi4203
    @devendoshi4203 Жыл бұрын

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

  • @mohitseventeen
    @mohitseventeen3 жыл бұрын

    Thank You, your way of explanation is very good.

  • @umairqureshi7597
    @umairqureshi75972 жыл бұрын

    yaar what a amazing, kamaaaal

  • @sampradhan5840
    @sampradhan58403 жыл бұрын

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

  • @nareshhaseja5827
    @nareshhaseja58272 жыл бұрын

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

  • @ketanupadhyay5423
    @ketanupadhyay54232 жыл бұрын

    great video. happy to see from Canada.

  • @smrutibarik8202
    @smrutibarik82022 жыл бұрын

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

  • @shwetashorts8341
    @shwetashorts83413 жыл бұрын

    Very easy and informative video. Thanks a lot !

  • @milinddhabadgaonkar8323
    @milinddhabadgaonkar83232 жыл бұрын

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

  • @IrfanKhan-wv8rh
    @IrfanKhan-wv8rh2 жыл бұрын

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

  • @subhashsmirth8188
    @subhashsmirth81883 жыл бұрын

    Thanks sir , Great

  • @azharuddinsubhan5569
    @azharuddinsubhan55692 жыл бұрын

    Excellent sir... Single second is usefull

  • @shubhambhavsar4953
    @shubhambhavsar49533 жыл бұрын

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

  • @rajuorao3695
    @rajuorao36953 жыл бұрын

    Very helpful this video to know more about pivot table 👍

  • @rithikgodimani6385
    @rithikgodimani6385 Жыл бұрын

    Thank you so much sir for making us excel junior superstar.

  • @rcsindian
    @rcsindian2 жыл бұрын

    It is very Professional and easily way of learning for every one.

  • @shankarbornfree8015
    @shankarbornfree80153 жыл бұрын

    Awesome brother. Crystal clear

  • @NUncle_vlogs
    @NUncle_vlogs3 жыл бұрын

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

  • @CAamitrout
    @CAamitrout2 жыл бұрын

    It could not get any better. Thank you

  • @niranjandas426
    @niranjandas4262 жыл бұрын

    Very clear & tricky Lesson. Really great

  • @bawramann1590
    @bawramann15902 жыл бұрын

    Yes you're my fav teacher

  • @SuperBassfanatic
    @SuperBassfanatic Жыл бұрын

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

  • @abhijitkar5289
    @abhijitkar52893 жыл бұрын

    Great. Thanks for the tricks 🙏

  • @nadeemjohn6126
    @nadeemjohn61263 жыл бұрын

    Excellent video and teaching style.

  • @premashishgupta3929
    @premashishgupta39293 жыл бұрын

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

  • @santosh1985th
    @santosh1985th3 жыл бұрын

    Excellent Trick by Excel Superstar.

  • @majid7783
    @majid77832 жыл бұрын

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

  • @bhawanithakur001
    @bhawanithakur0012 жыл бұрын

    Super Clear concept Thankyou Sir

  • @mohanpal2737
    @mohanpal27373 жыл бұрын

    Such really very helpful vedio..appriciate

  • @manmeetsinghrana7772
    @manmeetsinghrana7772 Жыл бұрын

    Excellent 👌 ur way of teaching is fabulous

  • @muhammednafiumminiyattil6889
    @muhammednafiumminiyattil68893 жыл бұрын

    Excellent bro 👍

  • @ananda3166
    @ananda31663 жыл бұрын

    Superb Sir

  • @khurramshahzed4925
    @khurramshahzed49252 жыл бұрын

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

  • @baljeet771
    @baljeet7712 жыл бұрын

    Excellent sir Thanks for the detailed video 🙏

  • @ExcelSuperstar

    @ExcelSuperstar

    2 жыл бұрын

    Most welcome

  • @ashujoshi1632
    @ashujoshi16322 жыл бұрын

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

  • @amirahmed5561
    @amirahmed55613 жыл бұрын

    It's your wonderful learning pack, thanks

  • @ExcelSuperstar

    @ExcelSuperstar

    3 жыл бұрын

    Glad you enjoy it!

  • @rananouman2292
    @rananouman22922 жыл бұрын

    Briefly and concisely Explained the basic to Advanced about Pivot Tables

  • @gantasaala23
    @gantasaala232 жыл бұрын

    Thank you soo much brother Excellent Teaching of PIVOT Tables

  • @atulnehra
    @atulnehra2 жыл бұрын

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

  • @majahidlaskar1781
    @majahidlaskar1781 Жыл бұрын

    Rishabh... Your last advice with regards to removing get pivot data option was very nice....

  • @navedahmad3155
    @navedahmad31553 жыл бұрын

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

  • @anjumaurya8154
    @anjumaurya8154 Жыл бұрын

    Amaging video and yes your work is appreciable

  • @sanjogZimbar
    @sanjogZimbar3 жыл бұрын

    Honestly, This one of the best video about Pivot table learning.

  • @ExcelSuperstar

    @ExcelSuperstar

    3 жыл бұрын

    Glad you think so! Keep learning

  • @sunilm1977
    @sunilm19772 жыл бұрын

    Very much informative and detailed video.

  • @prakashchordia3899
    @prakashchordia38992 жыл бұрын

    explain in very plain language , one can easily understand. big thanks to u.

  • @ExcelSuperstar

    @ExcelSuperstar

    2 жыл бұрын

    Thanks and welcome

  • @akilk1
    @akilk13 жыл бұрын

    you're awesome with uniqueness

  • @Arfatshadani
    @Arfatshadani2 жыл бұрын

    Your teaching level is defferent Super Sir

  • @saidulislamkhan4278
    @saidulislamkhan42782 жыл бұрын

    Thank you. So helpful.

  • @kedarkori5284
    @kedarkori52843 жыл бұрын

    Sir excellent thank you for your tricks

  • @sarveshkarane3096
    @sarveshkarane30963 жыл бұрын

    Great explanation sir🙏

  • @debanjanmukherjee811
    @debanjanmukherjee8112 жыл бұрын

    Such wonderful learning. Salute

  • @ExcelSuperstar

    @ExcelSuperstar

    2 жыл бұрын

    Thanks a lot

  • @deelipprajapati8011
    @deelipprajapati80112 жыл бұрын

    Fantastic Thank you for sharing!!!