MS Excel - Pivot Table Slice

Sdílet
Vložit
  • čas přidán 14. 01. 2018
  • MS Excel - Pivot Table Slice
    Watch More Videos at:
    www.tutorialspoint.com/videot...
    Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

Komentáře • 114

  • @TutorialsPoint_
    @TutorialsPoint_  Před rokem

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

  • @id4khan007
    @id4khan007 Před 4 lety +6

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

  • @user-ob6uo6ib6q
    @user-ob6uo6ib6q Před 8 měsíci

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

  • @rohitwalmiki271
    @rohitwalmiki271 Před 3 lety +8

    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

  • @user-oz4qm3ml4h
    @user-oz4qm3ml4h Před 4 měsíci

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

  • @husainfikri7513
    @husainfikri7513 Před 3 lety +3

    Short and Concise. The best explanation in the world

  • @vidishasoni6585
    @vidishasoni6585 Před 3 lety +6

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

  • @logicalunboxing5903
    @logicalunboxing5903 Před 3 lety

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

  • @MonikaSharma-mb7up
    @MonikaSharma-mb7up Před 2 lety +2

    Excellent way of explanation, very systematic, clear.

  • @mghayadar
    @mghayadar Před 2 lety

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

  • @shanmugamg1794
    @shanmugamg1794 Před rokem

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

  • @dhiru180
    @dhiru180 Před 2 lety +1

    I am so lucky to find this channel.

  • @richasharma4167
    @richasharma4167 Před 2 lety +1

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

  • @snakemovetrading
    @snakemovetrading Před 3 lety +1

    Thanks for this Excellent Excel Journey.....

  • @sohanlandge4580
    @sohanlandge4580 Před 2 lety +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.

  • @namanbhandari1527
    @namanbhandari1527 Před 2 lety +1

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

  • @sabornopurkayastha4050

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

  • @afreenmehra1491
    @afreenmehra1491 Před 2 lety +1

    Thanks a lot, Your lessons really helped a lot.

  • @ramishasultana736
    @ramishasultana736 Před 3 měsíci +1

    Thank U so much for this video❤

  • @jerantivola2659
    @jerantivola2659 Před rokem

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

  • @sampatht8990
    @sampatht8990 Před 5 lety +4

    Awesome bro, You are explaining very well way..

  • @smithapamula1356
    @smithapamula1356 Před 2 lety +1

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

  • @nadimsleiman5347
    @nadimsleiman5347 Před 2 lety

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

  • @sohanlandge4580
    @sohanlandge4580 Před 2 lety

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

  • @mdsalahuddinkaiser9308
    @mdsalahuddinkaiser9308 Před 4 měsíci

    Wonderful explanation.

  • @DebashishP82
    @DebashishP82 Před 4 lety

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

  • @bhaskarkumar5626
    @bhaskarkumar5626 Před 2 lety

    The way of your are explaining is awesome.

  • @dilbarmahmadgoolfee9621

    Excellent. Very good trainer

  • @poojajain5383
    @poojajain5383 Před 5 lety

    You are super genius sir ...thanks sir

  • @yeswanthmaremalla5831
    @yeswanthmaremalla5831 Před 4 lety

    thank you sir .. very well explained

  • @mohsinfareed1797
    @mohsinfareed1797 Před 5 lety +1

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

  • @Ansarkk-ti7bl
    @Ansarkk-ti7bl Před rokem

    Such a good explanation!

  • @ryanng328
    @ryanng328 Před rokem

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

  • @sunilkumarrai5558
    @sunilkumarrai5558 Před rokem

    Excellent way of teaching

  • @deepanchakkaravarthyc6358
    @deepanchakkaravarthyc6358 Před 8 měsíci

    Super sir.. perfect explanation

  • @meenarebello2005
    @meenarebello2005 Před 6 měsíci

    Excellent tutorial . Thank you

  • @yedlasaikiran744
    @yedlasaikiran744 Před 11 měsíci

    You are a king🎉

  • @chilikapradhan278
    @chilikapradhan278 Před rokem

    very well and precisely pexplaining .

  • @parthabhattacharyya3312

    Very helpful and well made

  • @sandeep.bommanahalli
    @sandeep.bommanahalli Před 3 lety

    Nice explanation sir. Thank You

  • @chhavisrivastava890
    @chhavisrivastava890 Před 4 lety +3

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

  • @subhadeepsn1
    @subhadeepsn1 Před rokem

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

  • @messibfm9804
    @messibfm9804 Před 5 lety

    Excellent ...thank you

  • @nidhilove0402
    @nidhilove0402 Před 5 lety +1

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

  • @techgadgets5598
    @techgadgets5598 Před 7 měsíci

    Superb Video

  • @tukaramugile573
    @tukaramugile573 Před 3 lety

    Thanks for the nice explanations

  • @asadmahboob1123
    @asadmahboob1123 Před 3 lety +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.

  • @sumitsutradhar2085
    @sumitsutradhar2085 Před 3 lety

    Very nice explanation Sir and thanks.

  • @sanghachea7700
    @sanghachea7700 Před 3 lety

    The best tutorials

  • @kbharathcute
    @kbharathcute Před rokem

    Great. Really usefull 😀

  • @addisusintie260
    @addisusintie260 Před 2 lety

    u are special thanks !

  • @kameshsubramanian2553
    @kameshsubramanian2553 Před 4 lety

    Great tutorial

  • @Peerwazifaofficial
    @Peerwazifaofficial Před 4 lety

    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

  • @kalpana4174
    @kalpana4174 Před 4 lety

    VERY USEFULLL.....

  • @rafatbadar7629
    @rafatbadar7629 Před rokem

    very informative

  • @nitinambannavar5576
    @nitinambannavar5576 Před 2 lety

    Thank you so much.

  • @mdarhaan4c170
    @mdarhaan4c170 Před 5 lety +5

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

  • @MANOJKUMAR-or4be
    @MANOJKUMAR-or4be Před 5 lety

    Thanks a lot

  • @nikhildeshpande33
    @nikhildeshpande33 Před rokem

    Thank you so much

  • @srinivast9247
    @srinivast9247 Před 5 lety +1

    Sir pls explain indirect function and sum product

  • @sreedharbabu4969
    @sreedharbabu4969 Před 3 lety

    Good one👍

  • @missaxena8100
    @missaxena8100 Před 3 lety

    Thanks a lot.

  • @INFJ_YJ
    @INFJ_YJ Před 4 lety +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?

  • @Teesriflight
    @Teesriflight Před 2 lety

    Thank You!

  • @ashkavasji1812
    @ashkavasji1812 Před 3 lety

    Super Helpful

  • @dnyaneshwardhokane7955
    @dnyaneshwardhokane7955 Před 4 lety +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)

  • @amanbhargava2702
    @amanbhargava2702 Před 2 lety

    Thank you😊😊

  • @lordfinesse3874
    @lordfinesse3874 Před 4 měsíci

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

  • @othmanashara9382
    @othmanashara9382 Před 2 lety

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

  • @theerthakumar9645
    @theerthakumar9645 Před 3 lety

    Excellent

  • @user-yu5yv8dr4y
    @user-yu5yv8dr4y Před 5 lety

    thank u

  • @rashidahmad8886
    @rashidahmad8886 Před 3 lety

    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

  • @arunabhargava8222
    @arunabhargava8222 Před 2 lety

    Thank you

  • @sibalivethelifefullest3516

    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.

  • @alokkumarray705
    @alokkumarray705 Před 3 lety

    Thank you sir

  • @sanjaychavda4621
    @sanjaychavda4621 Před 4 lety

    Very good

  • @himanshunassa9742
    @himanshunassa9742 Před 4 lety

    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

  • @santoshkumar-vu7ji
    @santoshkumar-vu7ji Před 3 lety

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

  • @nithinkuruvilla2954
    @nithinkuruvilla2954 Před 2 lety

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

  • @user-ik2vl8lf2x
    @user-ik2vl8lf2x Před 4 dny

    Hi, how to add slicer for unit and value?

  • @rebm3028
    @rebm3028 Před 3 lety

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

  • @cordelliaodidi1045
    @cordelliaodidi1045 Před 8 měsíci

    Thanks

  • @apoorvab9282
    @apoorvab9282 Před 2 lety

    Hello Sir ,
    please do videos on Alteryx.

  • @waseembutt296
    @waseembutt296 Před 2 lety

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

  • @sudiptaghosh1910
    @sudiptaghosh1910 Před 11 měsíci

    please make video on Solver and scenario

  • @care4u1ly
    @care4u1ly Před 7 měsíci

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

  • @nadimsleiman5347
    @nadimsleiman5347 Před 2 lety

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

  • @mafpin1
    @mafpin1 Před 2 lety

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

  • @benjaymathews7363
    @benjaymathews7363 Před 4 lety

    can i filter column in pivot table ?

  • @mohammedyusuf3682
    @mohammedyusuf3682 Před 2 lety

    Is it will work in ms excel 2010 ???

  • @rajukaran70
    @rajukaran70 Před 4 lety

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

    • @ManjulaRavindran
      @ManjulaRavindran Před 4 lety

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

  • @dimitrisntalampiras9702

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

  • @bankimsikder9874
    @bankimsikder9874 Před 10 měsíci

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

  • @guptak1092
    @guptak1092 Před 4 lety

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

    • @shubhi1694
      @shubhi1694 Před 3 lety

      2007 Excel yeh option nahi hai

  • @bardoliya
    @bardoliya Před 6 měsíci

    Sir how to increase slicer data rage?

  • @shalujain3852
    @shalujain3852 Před 2 lety

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

  • @tlee7028
    @tlee7028 Před 2 lety

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

  • @manishshhete1094
    @manishshhete1094 Před rokem

    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

  • @kalanisdynasty
    @kalanisdynasty Před 3 lety

    Sir How to use Slicer in android excell apps

  • @vishnumurthyadiga705
    @vishnumurthyadiga705 Před 4 lety

    Sir but not show insert slice option