Excel Dashboard Course #21 - Creating a Pivot table Dashboard with Slicers in Excel (in 15 minutes)

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

КОМЕНТАРІ • 192

  • @anbarasua4576
    @anbarasua4576 3 роки тому +10

    The Dashboard course was neatly designed and explained well. It will be really beneficial. This is compelling me to see more from the channel. Could not download data files for practice along with the video.

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

    thanks i made a dashboard by following side by side. such well explained video without unnecessary talking. One question , how can i make everything fits in one frame

  • @PraveenKumar-gn3to
    @PraveenKumar-gn3to 2 роки тому +1

    Can you tell me how the sheets have been created. Please share the link that sagrigation of pivot sheets by one click

  • @vinaykumar-ci7bj
    @vinaykumar-ci7bj Рік тому +2

    Very informative and useful for all, thank you so much for your time and training support ❤

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

    What is the correct link for the file?

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

    Very Nice I hope can make like that one

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

    Hi, I’m not getting all my tabs when I’m clicking Report Connections, its showing only one pivot table. Plz let me know what to do

  • @jimherr152
    @jimherr152 Місяць тому

    I noticed that the title of the graphs don’t change when you select the different slicer buttons. So if I go to print a graph, the graph title does not automatically reflect the parameters from the buttons in the slicers.
    What is the solution for that?

  • @Aura-Essence-p
    @Aura-Essence-p Рік тому

    In my excel no slicer is there😮

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

    Hi thanks for the tutorial. however, i found the combo chart for line keep disappear everytime i change the slicer. do you know the solution ? thanks

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

    Sir, Where from can I get the design and Analyze tab, I can see only upto view.

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

    what if I add a new data entry on data source, shall the pivot table/dashboard updated automatically? so, far I need to refresh it many time everytime I add new information on it. Pls Adv, thanks

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

    Thank you sir ❤
    Amazing, well explained

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

    downloadable file is not opening

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

    Download link not working,please help to share to download practice Excel workbook

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

    Any excel experts who can work on a project . Need experts only who can showcase work via video

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

    Thank you for posting this video. It is so useful and understandable. keep posting.......

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

    Very good explanation sir. Thank you.

  • @harsohrabsingh8020
    @harsohrabsingh8020 Рік тому +2

    Hey Sumit, big fan of your videos and the simple explanations! Keep them coming. Thanks a lot for all the knowledge!!

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

    If I link to Access query, and try to create a second pivot table, the create pivot is grayed out.
    If I create a 2nd pivot table using the same query on a different worksheet, I can't link using the slicer - only one worksheet shows up and not the other.
    What am I doing wrong?

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

    Thanks for sharing this excellent dashboard with us.. well explained..
    Kindly help us to download this file.. We are not able to download..

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

    Great video i have only 1 issues. When i create slicer is do report connection but i only see 1 pivot instead of multiple. I made 5 sheets with different pivots but only see the pivot on the sheet i create the slicer on. Any ideas? Thank you😊

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

    Wonderful Sumit Please give us more Pivot Dashboard tutorials ! Please the ones like HR without Pivot can you do it with Pivot

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

    Download link is not working. Please share Download link

  • @shrijibhau
    @shrijibhau 10 днів тому

    Thank you so much, very effective video.
    Very helpful.
    Examples and way of explaining is on point.

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

    How to create slicker for only top 5 or top 10 or as per requirement

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

    sadly the download link doesn't work. Please solve this

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

    Hi please share the pivot table URL with this course data

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

    7:30, 9:24 double axis chart 10:42 to 12:10

  • @SrinivasKumar-h7u
    @SrinivasKumar-h7u Рік тому

    hi sir, the practice file is not available here in the link. The link exits automatically. could you update and fix the issue ?

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

    But we need how to fixed/lock. Only slicer will active & see result but can't remove dashboard sheet.

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

    It's simple & Neat. Thanks .can you please share the link . Earlier link might have outdated

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

    Sir ur awesome ur provide this details free god bless you apko bhagwan jo apko chahiye wo do

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

    unable to download the file.. link is not working which you shared in discripiton

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

    Bit OTT for me at this stage but it is so easily done by you ... it is quite impressive

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

    When I click on your file link, then I don't find file on my download folder. Can you make available the file? Thanks.

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

      i faced the same issue. The tutorial is great but it would be better to get a hands-on experience

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

    unable to download the file.. link is not working which you shared in description

  • @JamesSmith-fj6bp
    @JamesSmith-fj6bp 3 роки тому

    When we change the entry on slicer the formatting of char changes like design and fonts.. How to stop that... I'm using excel 2013

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

    requesting to check download file. I could not download as it was saying 504 gateway time out.

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

    Sir,
    Thank you for clearing my doubt on how to change slicer pattern from vertical to horizontal.
    Also, on links to all pivot tables to control the entire sheet in one click.

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

    Once everything created, how do you go back to pivot tables for each tab, my pivot tables for each tab disappeard

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

    The download link is not working, please help

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

    Thank you for your video!! I am not able to download your data file to practice this.

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

    Awesome would be really helpful if you make video on Macros VBA

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

    Easy, smart, and practical. God bless you!

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

    Can you shre the file again..its not opening

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

    Thanks for inspiration, really like it.. Clean and simple in a good way!

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

    hi sir, i want to add slucer for % of sales values, like 10%, 20%, 30%, 40% and so on....please help...

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

    Great job! However, on the download file, the bar chart does not change when a single region is selected. So I see you broke the connection to that chart, right? Thanks.

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

      Great! It now works! Maybe it was my error? You were extremely busy on March 19, 2020!!! LOL

  • @throughmylens04
    @throughmylens04 2 місяці тому

    Excellent video...Simple,clear and efficient...Very useful video

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

    Hi how can i contact you on your website?

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

    Thank you you so much, very informative video. My question: Can we combine a dashboard using pivot tables and excel chartings and may be VBA?

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

    can these dashboards be exported to powerpoint such that i can still use the slicers

  • @Teesriflight
    @Teesriflight 3 місяці тому

    Good Job! Thank you for this.

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

    Thanks sir very clearly described

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

    SUMIT SIR AWESOME

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

    Thank you so much for your lovely explanation.. It is really helpful

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

    My Report Connections doesn't show the other pivot tables to select. Ideas? In a hurry? This is due soon : (

  • @salehofgalaxy
    @salehofgalaxy Місяць тому +1

    Perfect 👌

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

    thank you so much very informative and useful infromation

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

    is the data link doesn't work or something?

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

    well explained thanks !

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

    You can't download this file. Can you put a new link for the download file, Please?

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

    excellent very informative easy to understand explain in very easy way this increase my knowledge

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

    Very easy to follow. Thank you!

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

    Download File link is not working

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

    Excellent Sumit 👏

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

    Very Helpful for Me. Thanks 👍

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

    Love it, thank you so much, god bless you

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

    Can you share a sample data dump

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

    Data file to share kar do brother

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

    Hi thanks for the tutorial. however, i found the combo chart for line keep disappear everytime i change the slicer. do you know the solution ? thanks

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

    It is very useful and good presentation. I want to download your file for practice but cannot success. Can you share this file for me, pleaase?

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

    The presentation is really easy to understand. I have learnt a lot. Was not able to download the file though.

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

    I have created my team dashboard through the slice be blessed

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

    Thanks for the simple video

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

    Not able to download the file

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

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

    VERY useful video. You just kept me from looking ignorant in front of my manager and HIS Manager. Many thanks!

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

    The download file link isn't working

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

    Can you please make dashboard for recruitments

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

    We need the excel file please

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

    I have tried rearranging the month in the data. However, when I created the slicer, the arrangement of the months were not in sequence as in Jan, Feb, Mar and so forth..Why is that?

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

      It is due to Pivot arrange alphabets order, try to insert nos like 01_Jan, 02_Feb, 03_Mar it will u as per ur desire sequence

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

    Very Good...Easy to understand,Hat of to you!

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

    Unable to download file

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

    Unable to download file

  • @1206kendra
    @1206kendra Рік тому

    This video was great, thank you!

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

    Link for downloading this file please

  • @m.d.shibyshiby7923
    @m.d.shibyshiby7923 2 роки тому

    Option tab is not found

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

    Hi Sumit, Can you please tell me about drawbacks of pivot table that is about dynamic data which you specifically discuss in the above video, I couldn't understand

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

    I mean Last video

  • @vikrantsharma-i3u
    @vikrantsharma-i3u 9 місяців тому

    Thanks a lot Sumit for such a nice teaching..

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

    Thank you so much, very effective video.
    Very helpful.
    Examples and way of explaining is on point.
    Thank you once again. ❣️

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

    U r the best bro 👍👍
    Keep it up as usual

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

    What software did you use please?

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

      Software for? The tool I show in the video is Excel, and I've used Camtasia for the recording

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

    I am unable to download the file

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

    Download File link is not working sir

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

    Simple and amazing way to create dashboard. This helped me to create interactive dashboard as per need of my client

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

    Sir
    File not downloading in mobile

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

    So nice sir... thank you for the creative dashboard s