MS Excel - Pivot Table Slice

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 118

  • @TutorialsPoint_
    @TutorialsPoint_  Рік тому

    To Get Certification, Click Here: bit.ly/38Jyu3p
    Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.

  • @AduazaJoel
    @AduazaJoel Рік тому +1

    Tutorials point is the best for learning more about Ms excel.... I'm cracking the course with a smile.

  • @NITESHKUMAR-c7d7h
    @NITESHKUMAR-c7d7h 10 місяців тому

    The best videos of Excel that you can find on the whole internet!!! Kudos to Pawan and team.

  • @rohitwalmiki271
    @rohitwalmiki271 4 роки тому +9

    thank you so much sir for teaching such a valuable lesson so easily that too in free, you helped me become better in my corporate job so thank you so much, and may God always shower blessings on you, and may God always bless you with everything that you want so thank you so much, sir... with love

  • @husainfikri7513
    @husainfikri7513 3 роки тому +3

    Short and Concise. The best explanation in the world

  • @zakir-sohane
    @zakir-sohane 25 днів тому

    Short and Concise. The best explanation i have ever see

  • @id4khan007
    @id4khan007 4 роки тому +6

    Excellent way of explanation, very systematic, clear, legible!

  • @shanmugamg1794
    @shanmugamg1794 Рік тому

    The best tutor I ever come across...excellent and keep up the good work

  • @vidishasoni6585
    @vidishasoni6585 4 роки тому +6

    It's life changing for me... thanks for the great tutorial 🙏🙏

  • @mghayadar
    @mghayadar 3 роки тому

    You are Awesome. Thank you very much for saving my life with this Slicer video. Really helpful.

  • @dhiru180
    @dhiru180 2 роки тому +1

    I am so lucky to find this channel.

  • @MonikaSharma-mb7up
    @MonikaSharma-mb7up 3 роки тому +2

    Excellent way of explanation, very systematic, clear.

  • @sohanlandge4580
    @sohanlandge4580 3 роки тому +2

    I watched all the videos of yours on pivot tables , the best part is all the features which I want to learn, I can have it in your videos tutorials.

  • @logicalunboxing5903
    @logicalunboxing5903 3 роки тому

    These EXCEL videos are easy to understand and have made a significant boost to my carrier...👌
    Thank you...👍

  • @ryanng328
    @ryanng328 Рік тому

    You're the only Indian that speak English.
    WELL DONE

  • @sohanlandge4580
    @sohanlandge4580 3 роки тому

    Very well explained sir , best video on pivot tables on you tube

  • @smithapamula1356
    @smithapamula1356 2 роки тому +2

    Thanks a lot, really helpful video. Perfect explaination!!

  • @bhaskarkumar5626
    @bhaskarkumar5626 2 роки тому

    The way of your are explaining is awesome.

  • @richasharma4167
    @richasharma4167 3 роки тому +1

    Brilliant video and explanation. Thank you so much for a wonderful explanation. Very very helpful.

  • @sampatht8990
    @sampatht8990 5 років тому +4

    Awesome bro, You are explaining very well way..

  • @thetswezin9611
    @thetswezin9611 5 місяців тому

    Very clear explanation.🎉❤ Excellent class

  • @jerantivola2659
    @jerantivola2659 Рік тому

    This guy is a life changing thank yoy very much, such a big help 🙏🏻❤️💯🔥

  • @namanbhandari1527
    @namanbhandari1527 2 роки тому +1

    AMAZING VIDEO...VERY EFFECTIVELY TAUGHT IN SHORT SPAN.

  • @snakemovetrading
    @snakemovetrading 4 роки тому +1

    Thanks for this Excellent Excel Journey.....

  • @afreenmehra1491
    @afreenmehra1491 3 роки тому +1

    Thanks a lot, Your lessons really helped a lot.

  • @nadimsleiman5347
    @nadimsleiman5347 2 роки тому

    Thanks for everything god bless you
    you are a perfect teacher.

  • @nidhilove0402
    @nidhilove0402 5 років тому +1

    kaun h faltu log jo har video ko dislike karte h.. wonderful video very helpful :)

  • @sunilkumarrai5558
    @sunilkumarrai5558 2 роки тому

    Excellent way of teaching

  • @yedlasaikiran744
    @yedlasaikiran744 Рік тому

    You are a king🎉

  • @ramishasultana736
    @ramishasultana736 9 місяців тому +1

    Thank U so much for this video❤

  • @lordfinesse3874
    @lordfinesse3874 9 місяців тому

    hi what kind of screen / projector touchscreen are you using?

  • @sabornopurkayastha4050
    @sabornopurkayastha4050 5 років тому

    Thanks .. well explained .. keep the good job going Bro.. you are on the ball..

  • @deepanchakkaravarthyc6358
    @deepanchakkaravarthyc6358 Рік тому

    Super sir.. perfect explanation

  • @TheBhattacharya
    @TheBhattacharya 4 місяці тому

    UR a MASTERPIECE ❤U look like SONU NIGAM ( who himself was a MASTERPIECE ❤) ..U 2 R D dame in UR GENRE ❤

  • @subhadeepsn1
    @subhadeepsn1 2 роки тому

    Thanks for your video with help of this video I have done with my slicer.

  • @kbharathcute
    @kbharathcute 2 роки тому

    Great. Really usefull 😀

  • @mohsinfareed1797
    @mohsinfareed1797 5 років тому +1

    Great man. very well explained and clear. The best of all . I enjoyed your tutorial in Excel.

  • @dilbarmahmadgoolfee9621
    @dilbarmahmadgoolfee9621 4 роки тому

    Excellent. Very good trainer

  • @Ansarkk-ti7bl
    @Ansarkk-ti7bl Рік тому

    Such a good explanation!

  • @mdarhaan4c170
    @mdarhaan4c170 6 років тому +5

    sir ANALYSE TOOL DOESN'T SHOW IN MS EXCEL 2007 SO WHAT CAN I DO (BCOZ SLICE OPTION DOESN'T SHOW)

  • @chilikapradhan278
    @chilikapradhan278 Рік тому

    very well and precisely pexplaining .

  • @sanghachea7700
    @sanghachea7700 3 роки тому

    The best tutorials

  • @othmanabdalazeez
    @othmanabdalazeez 2 роки тому

    How can I make the slicer title font bigger. Also the slicer fonts in general. Thanks

  • @asadmahboob1123
    @asadmahboob1123 3 роки тому +1

    Hi Sir,
    Thank you for the video. It's very informative,
    Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked?
    If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.

  • @chhavisrivastava890
    @chhavisrivastava890 5 років тому +3

    excellent way of teaching but I have only one request please share this data so that we can practice it as you guide.

  • @INFJ_YJ
    @INFJ_YJ 4 роки тому +2

    Hi there, do you still reply on your videos?
    I have a doubt, in my organisation's Ms excel 'Insert Slicer' option id greyed out i.e. I can not select this option. U have any idea how to fix it?

  • @sibalivethelifefullest3516
    @sibalivethelifefullest3516 3 роки тому +1

    What if both pivot tables have different data even then one slicer can work for both? could you please help me Sir how to show the date month-wise using slicer? please help.

  • @nadimsleiman5347
    @nadimsleiman5347 2 роки тому

    I want to ask about
    i have office 10 but IFS & FILTER function
    not found
    how could i work with them

  • @meenarebello2005
    @meenarebello2005 Рік тому

    Excellent tutorial . Thank you

  • @care4u1ly
    @care4u1ly Рік тому

    How to highlight the cells using slicer in the pivot table?

  • @nithinkuruvilla2954
    @nithinkuruvilla2954 3 роки тому

    Shall we export this pivot and slicer in to outlook and send it??

  • @mafpin1
    @mafpin1 3 роки тому

    How to write text below tabel? Sometime error when i clear slicer. Do u have trik?

  • @rashidahmad8886
    @rashidahmad8886 4 роки тому

    Please tell me if I put my data under pivot table like 1st August to 18 August but I want to expand date till 22 August in same pivot table so how can I do that

  • @DebashishP82
    @DebashishP82 4 роки тому

    Thanks a lot mate. I was just looking for it.

  • @Therealknowledge786
    @Therealknowledge786 3 роки тому

    please some one help , is these slicers work only on pivot table because on normal tale this option is not enable

  • @mdsalahuddinkaiser9308
    @mdsalahuddinkaiser9308 9 місяців тому

    Wonderful explanation.

  • @dnyaneshwardhokane7955
    @dnyaneshwardhokane7955 4 роки тому +1

    Sir can we make a formula like
    (If a specific value content in a column then copy whole column and paste in another sheet automatically with pastelink)

  • @sumitsutradhar2085
    @sumitsutradhar2085 3 роки тому

    Very nice explanation Sir and thanks.

  • @tlee7028
    @tlee7028 2 роки тому

    How do I update slicers if Rita and John are no longer in data?

  • @addisusintie260
    @addisusintie260 2 роки тому

    u are special thanks !

  • @cknagdimat7961
    @cknagdimat7961 10 місяців тому

    While inserting SLICER in excel 2010 am getting a pop up showing message as "ALL CONNECTIONS" due to which I am not getting slicer option. What is the solution

    • @suchipinku25
      @suchipinku25 10 місяців тому

      Convert the table to table design or try it in pivot table

  • @rebm3028
    @rebm3028 4 роки тому

    Hello, With the slicers of a pivot table, I can't keep the format (example wraps)
    As soon as I click on another segment, there is no more wrapping and the box is unchecked ...

  • @sandeep.bommanahalli
    @sandeep.bommanahalli 3 роки тому

    Nice explanation sir. Thank You

  • @AniPetrova-x9u
    @AniPetrova-x9u 5 місяців тому

    Hi, how to add slicer for unit and value?

  • @poojajain5383
    @poojajain5383 5 років тому

    You are super genius sir ...thanks sir

  • @manishshhete1094
    @manishshhete1094 Рік тому

    what if i have name slicer and name list is lengthy, then how do i get the desired name in search do i need to scroll the entire name list

  • @tukaramugile573
    @tukaramugile573 3 роки тому

    Thanks for the nice explanations

  • @dimitrisntalampiras9702
    @dimitrisntalampiras9702 3 роки тому

    I can not select Insert Slicer. U have any idea how to fix it? thanks

  • @bankimsikder9874
    @bankimsikder9874 Рік тому

    Bhaiya Insert Slicer unclick able for my excel. I use to office 365

  • @sreedharbabu4969
    @sreedharbabu4969 3 роки тому

    Good one👍

  • @rajukaran70
    @rajukaran70 4 роки тому

    I dont see Anayzer tab or slicer in MS Excel 2007. How to go about? Can you pls help?

    • @ManjulaRavindran
      @ManjulaRavindran 4 роки тому

      The analysis and design tab comes.only if we click on the.pivot.table

  • @amanbhargavaofficial
    @amanbhargavaofficial 3 роки тому

    Thank you😊😊

  • @yeswanthmaremalla5831
    @yeswanthmaremalla5831 5 років тому

    thank you sir .. very well explained

  • @mohammedyusuf3682
    @mohammedyusuf3682 3 роки тому

    Is it will work in ms excel 2010 ???

  • @santoshkumar-vu7ji
    @santoshkumar-vu7ji 4 роки тому

    nice video sir but i want prodcut and region in column after that values what to do sir

  • @guptak1092
    @guptak1092 4 роки тому

    Unable to find Slicer option in
    Analyse TAB Which was using by you unable to find
    Pl do needful

    • @shubhi1694
      @shubhi1694 3 роки тому

      2007 Excel yeh option nahi hai

  • @techgadgets5598
    @techgadgets5598 Рік тому

    Superb Video

  • @parthabhattacharyya3312
    @parthabhattacharyya3312 5 років тому

    Very helpful and well made

  • @benjaymathews7363
    @benjaymathews7363 5 років тому

    can i filter column in pivot table ?

  • @Peerwazifaofficial
    @Peerwazifaofficial 4 роки тому

    Great excellent video 👍,
    Can you please let me know how to create Invoices in Excel with GST, and with some liquor Taxes as in Liquor products only VAT is use so please kindly make a video on GST products and On Liquor products as well,
    Thanks

  • @apoorvab9282
    @apoorvab9282 2 роки тому

    Hello Sir ,
    please do videos on Alteryx.

  • @bardoliya
    @bardoliya 11 місяців тому

    Sir how to increase slicer data rage?

  • @Teesriflight
    @Teesriflight 2 роки тому

    Thank You!

  • @shalujain3852
    @shalujain3852 3 роки тому

    Please tell how to update pivot table when data gets updated.

  • @shubhi1694
    @shubhi1694 3 роки тому

    Sir Window kon si hai..??? Window 2007 mein nahi hai

  • @kalpana4174
    @kalpana4174 4 роки тому

    VERY USEFULLL.....

  • @rafatbadar7629
    @rafatbadar7629 2 роки тому

    very informative

  • @AbdiJama-e1r
    @AbdiJama-e1r 17 днів тому

    Thanks my dear brother

  • @srinivast9247
    @srinivast9247 6 років тому +1

    Sir pls explain indirect function and sum product

  • @himanshunassa9742
    @himanshunassa9742 5 років тому

    thanks for the video, is it possible to get a Find option in Slicer....in case we have many options in slicer then it will be easy to do it by finding

  • @kameshsubramanian2553
    @kameshsubramanian2553 4 роки тому

    Great tutorial

  • @messibfm9804
    @messibfm9804 5 років тому

    Excellent ...thank you

  • @kalanisdynasty
    @kalanisdynasty 3 роки тому

    Sir How to use Slicer in android excell apps

  • @minhzae
    @minhzae 2 роки тому

    His patience in telling you how to create the pivot table at the beginning of every video 🤌. I would have flipped everything over 🤭

  • @ashkavasji1812
    @ashkavasji1812 4 роки тому

    Super Helpful

  • @vishnumurthyadiga705
    @vishnumurthyadiga705 4 роки тому

    Sir but not show insert slice option

  • @sudiptaghosh1910
    @sudiptaghosh1910 Рік тому

    please make video on Solver and scenario

  • @missaxena8100
    @missaxena8100 3 роки тому

    Thanks a lot.

  • @theerthakumar9645
    @theerthakumar9645 3 роки тому

    Excellent

  • @alokkumarray705
    @alokkumarray705 3 роки тому

    Thank you sir