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

Sdílet
Vložit
  • čas přidán 18. 03. 2020
  • In this video, I will show you how to create a Pivot Table dashboard in Excel in 15 minutes. The dashboard includes Pivot Charts and slicers.
    ✅ Download File - bit.ly/2QuzwHZ
    ☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
    Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    Best Excel Books: trumpexcel.com/best-excel-books/
    Subscribe to get awesome Excel Tips every week: czcams.com/users/trumpexc...
    #Excel #ExcelTips #ExcelTutorial

Komentáře • 187

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

    Easy, smart, and practical. God bless you!

  • @harsohrabsingh8020
    @harsohrabsingh8020 Před rokem +2

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

  • @anbarasua4576
    @anbarasua4576 Před 2 lety +9

    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.

  • @vinaykumar-ci7bj
    @vinaykumar-ci7bj Před 11 měsíci +2

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

  • @ellemason2055
    @ellemason2055 Před 3 lety +2

    Very easy to follow. Thank you!

  • @gosavirealty
    @gosavirealty Před 3 lety

    Completed whole playlist. You're awesome.

  • @thenewdataguy
    @thenewdataguy Před rokem +1

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

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

    Learning so much from this channel 🙏🏻

  • @KingKonAdventure
    @KingKonAdventure Před rokem

    Great job! Very useful and easy to follow.

  • @Samiahusain
    @Samiahusain Před 2 lety

    this was such an informative video. many many thanks for the concise, relevant and to the point information, that was easy to follow.

  • @user-vc7iy8wj4z
    @user-vc7iy8wj4z Před rokem

    Sharing knowledge , Educating others are really appreciated ❤

  • @AnitaNtombelaAMN
    @AnitaNtombelaAMN Před 3 lety

    Very simple, Thanks and God Bless you.

  • @jaylg2000
    @jaylg2000 Před rokem

    Just one word !!!"Fantastic"

  • @edwinotwori7794
    @edwinotwori7794 Před 3 lety

    Really a help. Thanks. Keep posting.

  • @SM-ce1uy
    @SM-ce1uy Před 2 lety

    so useful ! amazing thank you ! basically saw a finalized version at a coworker and got excel envy lol so I had to google to find out the process. now I know !

  • @parikshitbhavsar4076
    @parikshitbhavsar4076 Před rokem

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

  • @balasubramanianshanmugam3721

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

  • @user-pj2xg8ov4q
    @user-pj2xg8ov4q Před 6 měsíci

    Thanks a lot Sumit for such a nice teaching..

  • @vaishnavishetty7192
    @vaishnavishetty7192 Před rokem

    Very easy to understand and do it . Thank you !!!

  • @BroCode465
    @BroCode465 Před 2 lety

    That was dope!! Thank you!

  • @Vutsman1
    @Vutsman1 Před 2 lety

    Excellent tutorial. And very cool.

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

    Excellent Sumit 👏

  • @xmasgombakomba3322
    @xmasgombakomba3322 Před rokem

    Fantastic stuff Sumit, thanks muchly

  • @sivas9443
    @sivas9443 Před 4 lety +2

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

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

    well explained thanks !

  • @srinivasumanem4979
    @srinivasumanem4979 Před rokem +1

    Very good explanation sir. Thank you.

  • @1206kendra
    @1206kendra Před 9 měsíci

    This video was great, thank you!

  • @vismeetashah4852
    @vismeetashah4852 Před 2 lety

    Wonderful , It's very useful thank you

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

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

  • @vbreddy4296
    @vbreddy4296 Před 4 lety +2

    SUMIT SIR AWESOME

  • @muhammadeilyas
    @muhammadeilyas Před rokem

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

  • @rizwanabibi7987
    @rizwanabibi7987 Před rokem +1

    Thank you sir ❤
    Amazing, well explained

  • @FaysalEasyExcel
    @FaysalEasyExcel Před 4 lety +1

    Thanks sir very clearly described

  • @raashidofficial3183
    @raashidofficial3183 Před 4 lety

    Very good 👍👌. appreciate your help for giving knowledge

  • @PARAGKADAM
    @PARAGKADAM Před 2 lety +3

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

  • @datatalksbyjunaid4292
    @datatalksbyjunaid4292 Před 2 lety

    Thanks for the simple video

  • @vitoc.1535
    @vitoc.1535 Před 10 měsíci

    Great video, thank you!

  • @jubileelifeinsurance5991

    Respected Sir Sumit , You are great

  • @broto8
    @broto8 Před 3 lety +2

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

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

  • @adamchoi1352
    @adamchoi1352 Před rokem

    Good video! Very helpful.

  • @Teesriflight
    @Teesriflight Před 25 dny

    Good Job! Thank you for this.

  • @melodyLiang-cf9ww
    @melodyLiang-cf9ww Před 2 měsíci

    Great video!!!

  • @nileshmetkar1737
    @nileshmetkar1737 Před 3 lety

    It’s very helpful for me 🙏

  • @mutembeijames9822
    @mutembeijames9822 Před 3 lety

    It's the best video if you still wonder to make an interactive dashboard

  • @emmanuelonuoha3642
    @emmanuelonuoha3642 Před 2 lety

    Nice work, thanks alot.

  • @sanmu6325
    @sanmu6325 Před 3 lety

    Hi sumeet your videos are always good

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

    Love it, thank you so much, god bless you

  • @Jepp392
    @Jepp392 Před 2 lety

    Great video! 10/10

  • @NilanjanJanaofficial
    @NilanjanJanaofficial Před měsícem

    Very Helpful for Me. Thanks 👍

  • @pkmbpkmb3499
    @pkmbpkmb3499 Před 2 lety

    Simply WOW

  • @allanjuarez4303
    @allanjuarez4303 Před 3 lety

    Thanks a lot!

  • @olaitanadekunleoyebola7528

    This is very much on point

  • @natarajang6125
    @natarajang6125 Před 2 lety

    Wow, amazing

  • @zainabidzain
    @zainabidzain Před 2 lety

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

  • @rajeshnaik7207
    @rajeshnaik7207 Před 2 lety

    thank you so much very informative and useful infromation

  • @uppariraghavendra3854

    Super very clear understand

  • @rajeshakkineni5127
    @rajeshakkineni5127 Před 3 lety

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

  • @raedmisen538
    @raedmisen538 Před rokem

    VEERY HELPFUL , THANKS

  • @NoTorr2000
    @NoTorr2000 Před rokem

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

  • @budisetiadihermanto7445

    God bless you!!

  • @Gireesh_j
    @Gireesh_j Před rokem

    Thank you…. It helps me a lot

  • @sreedharbabu4969
    @sreedharbabu4969 Před 3 lety

    Good one👍

  • @allanamone5171
    @allanamone5171 Před rokem

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

  • @sv4430
    @sv4430 Před 3 lety

    Thank you.

  • @mrCetus
    @mrCetus Před 2 lety

    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

  • @lilkloode
    @lilkloode Před 3 měsíci

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

  • @sherylleduna5367
    @sherylleduna5367 Před 2 lety

    Thanks!!

  • @hassanmburia8825
    @hassanmburia8825 Před rokem

    Thank you so much

  • @stephanychuquilin9764
    @stephanychuquilin9764 Před 3 měsíci

    Muchas gracias ! Estuvo muy bien explicado, sencillo y al punto. Exactamente lo que necesitaba.

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

      Thank you Stephany... Glad you found the video helpful 🙂

  • @MrEms333
    @MrEms333 Před 4 lety +2

    Very Nice I hope can make like that one

  • @subhashaswal31stdec
    @subhashaswal31stdec Před 3 lety

    very helpful...tnx

  • @vishajoshi3500
    @vishajoshi3500 Před rokem +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

  • @junyusu5075
    @junyusu5075 Před 3 lety

    Thank you

  • @JamesGarangDeng
    @JamesGarangDeng Před rokem

    that is very fantastic

  • @suaiburrahman3582
    @suaiburrahman3582 Před rokem

    Great 🙂

  • @wajahatrasheed1173
    @wajahatrasheed1173 Před 2 lety

    Fabulous

  • @telugu-malayalamlearning8032
    @telugu-malayalamlearning8032 Před 10 měsíci

    Sooper yaar

  • @freddjensen9556
    @freddjensen9556 Před 3 lety

    Thanks

  • @ottoambrose5448
    @ottoambrose5448 Před rokem

    Great

  • @vedantsutar
    @vedantsutar Před 4 lety +1

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

  • @fawaz84
    @fawaz84 Před 2 lety

    thank you

  • @vikass5477
    @vikass5477 Před 2 lety

    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

  • @lakhotiasupreet
    @lakhotiasupreet Před 3 lety

    This is good

  • @YasserIsmail
    @YasserIsmail Před 4 lety +1

    well done

  • @sekharispassion
    @sekharispassion Před rokem

    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.

  • @sandeepmishra4233
    @sandeepmishra4233 Před rokem

    Nice brother 😊

  • @MuhamadYusufRamdhan
    @MuhamadYusufRamdhan Před 3 lety

    thx dude

  • @iankr
    @iankr Před 3 lety

    Great. It looks like your month and year slicers were combined into one box?

  • @bollywoodkiharkhabar9262

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

  • @mohammedjunaidofficial8321

    Nice

  • @learningsurfer
    @learningsurfer Před 3 lety

    Nice video

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

      Glad you found the video useful!

  • @hassanmburia8825
    @hassanmburia8825 Před rokem

    I have created my team dashboard through the slice be blessed

  • @PraveenKumar-gn3to
    @PraveenKumar-gn3to Před 2 lety +1

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

  • @sumitshelke4640
    @sumitshelke4640 Před 2 lety

    Good

  • @linalai6673
    @linalai6673 Před 3 lety

    When I did month slicer, the month shown was 1/20/2020 instead of January, may I know how to edit the month in slicer?

  • @arunachari2689
    @arunachari2689 Před rokem

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

  • @YasserIsmail
    @YasserIsmail Před 4 lety

    is there any way to connect this to Power BI, charts in Power BI not really nice as Excel

  • @pthdxe
    @pthdxe Před 2 lety

    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?

  • @chetansamdani163
    @chetansamdani163 Před 3 lety

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