MS Excel - Pivot Table Slice

Поділитися
Вставка
  • Опубліковано 14 січ 2018
  • MS Excel - Pivot Table Slice
    Watch More Videos at:
    www.tutorialspoint.com/videot...
    Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

КОМЕНТАРІ • 115

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

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

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

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

  • @rohitwalmiki271
    @rohitwalmiki271 3 роки тому +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-ob6uo6ib6q
    @user-ob6uo6ib6q 9 місяців тому

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

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

    Short and Concise. The best explanation in the world

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

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

  • @user-oz4qm3ml4h
    @user-oz4qm3ml4h 5 місяців тому

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

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

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

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

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

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

    Excellent way of explanation, very systematic, clear.

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

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

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

    I am so lucky to find this channel.

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

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

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

    Thanks for this Excellent Excel Journey.....

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

    Awesome bro, You are explaining very well way..

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

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

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

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

  • @sohanlandge4580
    @sohanlandge4580 2 роки тому +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.

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

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

  • @thetswezin9611
    @thetswezin9611 5 днів тому

    Very clear explanation.🎉❤ Excellent class

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

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

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

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

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

    Thanks a lot, Your lessons really helped a lot.

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

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

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

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

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

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

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

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

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

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

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

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

    The way of your are explaining is awesome.

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

    Thank U so much for this video❤

  • @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?

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

    You are super genius sir ...thanks sir

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

    thank you sir .. very well explained

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

    Excellent. Very good trainer

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

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

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

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

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

    Excellent way of teaching

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

    Such a good explanation!

  • @meenarebello2005
    @meenarebello2005 7 місяців тому

    Excellent tutorial . Thank you

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

    very well and precisely pexplaining .

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

    Very nice explanation Sir and thanks.

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

    Nice explanation sir. Thank You

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

  • @deepanchakkaravarthyc6358
    @deepanchakkaravarthyc6358 8 місяців тому

    Super sir.. perfect explanation

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

    Excellent ...thank you

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

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

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

    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

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

    Very helpful and well made

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

    Thanks for the nice explanations

  • @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)

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

    Wonderful explanation.

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

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

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

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

    The best tutorials

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

    You are a king🎉

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

    u are special thanks !

  • @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

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

    Great. Really usefull 😀

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

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

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

    Great tutorial

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

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

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

    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

  • @MANOJKUMAR-or4be
    @MANOJKUMAR-or4be 5 років тому

    Thanks a lot

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

    Thank You!

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

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

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

    Thank you so much.

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

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

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

    VERY USEFULLL.....

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

    Thanks a lot.

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

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

  • @techgadgets5598
    @techgadgets5598 7 місяців тому

    Superb Video

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

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

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

    Thank you so much

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

    Sir pls explain indirect function and sum product

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

    Super Helpful

  • @user-yu5yv8dr4y
    @user-yu5yv8dr4y 5 років тому

    thank u

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

    Good one👍

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

    Thank you😊😊

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

    Thank you sir

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

    very informative

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

    Excellent

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

    Thank you

  • @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

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

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

  • @care4u1ly
    @care4u1ly 7 місяців тому

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

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

    Very good

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

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

  • @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

  • @user-ik2vl8lf2x
    @user-ik2vl8lf2x 17 днів тому

    Hi, how to add slicer for unit and value?

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

    Is it will work in ms excel 2010 ???

  • @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

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

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

  • @cordelliaodidi1045
    @cordelliaodidi1045 8 місяців тому

    Thanks

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

    can i filter column in pivot table ?

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

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

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

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

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

    Hello Sir ,
    please do videos on Alteryx.

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

    Sir how to increase slicer data rage?

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

    please make video on Solver and scenario