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

Поделиться
HTML-код
  • Опубликовано: 18 мар 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: ruclips.net/user/trumpexc...
    #Excel #ExcelTips #ExcelTutorial

Комментарии • 187

  • @haider121979
    @haider121979 3 года назад +3

    Easy, smart, and practical. God bless 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!!

  • @KingKonAdventure
    @KingKonAdventure Год назад

    Great job! Very useful and easy to follow.

  • @Samiahusain
    @Samiahusain 2 года назад

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

  • @anbarasua4576
    @anbarasua4576 2 года назад +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.

  • @gosavirealty
    @gosavirealty 3 года назад

    Completed whole playlist. You're awesome.

  • @ellemason2055
    @ellemason2055 3 года назад +2

    Very easy to follow. Thank you!

  • @thenewdataguy
    @thenewdataguy Год назад +1

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

  • @vinaykumar-ci7bj
    @vinaykumar-ci7bj Год назад +2

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

  • @evernote88
    @evernote88 3 года назад +1

    Learning so much from this channel 🙏🏻

  • @AnitaNtombelaAMN
    @AnitaNtombelaAMN 3 года назад

    Very simple, Thanks and God Bless you.

  • @user-vc7iy8wj4z
    @user-vc7iy8wj4z Год назад

    Sharing knowledge , Educating others are really appreciated ❤

  • @SM-ce1uy
    @SM-ce1uy 2 года назад

    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 Год назад

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

  • @raashidofficial3183
    @raashidofficial3183 4 года назад

    Very good 👍👌. appreciate your help for giving knowledge

  • @edwinotwori7794
    @edwinotwori7794 3 года назад

    Really a help. Thanks. Keep posting.

  • @balasubramanianshanmugam3721
    @balasubramanianshanmugam3721 3 года назад +1

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

  • @PARAGKADAM
    @PARAGKADAM 2 года назад +3

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

  • @FaysalEasyExcel
    @FaysalEasyExcel 4 года назад +1

    Thanks sir very clearly described

  • @vismeetashah4852
    @vismeetashah4852 2 года назад

    Wonderful , It's very useful thank you

  • @jubileelifeinsurance5991
    @jubileelifeinsurance5991 4 года назад

    Respected Sir Sumit , You are great

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

  • @jaylg2000
    @jaylg2000 Год назад

    Just one word !!!"Fantastic"

  • @nileshmetkar1737
    @nileshmetkar1737 3 года назад

    It’s very helpful for me 🙏

  • @vaishnavishetty7192
    @vaishnavishetty7192 Год назад

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

  • @mutembeijames9822
    @mutembeijames9822 3 года назад

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

  • @Vutsman1
    @Vutsman1 2 года назад

    Excellent tutorial. And very cool.

  • @ManojKumar0101
    @ManojKumar0101 6 месяцев назад

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

  • @broto8
    @broto8 3 года назад +2

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

  • @user-pj2xg8ov4q
    @user-pj2xg8ov4q 6 месяцев назад

    Thanks a lot Sumit for such a nice teaching..

  • @srinivasumanem4979
    @srinivasumanem4979 Год назад +1

    Very good explanation sir. Thank you.

  • @zainzainzn
    @zainzainzn 2 года назад

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

  • @rizwanabibi7987
    @rizwanabibi7987 Год назад +1

    Thank you sir ❤
    Amazing, well explained

  • @rajeshakkineni5127
    @rajeshakkineni5127 3 года назад

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

  • @1206kendra
    @1206kendra 9 месяцев назад

    This video was great, thank you!

  • @datatalksbyjunaid4292
    @datatalksbyjunaid4292 2 года назад

    Thanks for the simple video

  • @NoTorr2000
    @NoTorr2000 Год назад

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

  • @BroCode465
    @BroCode465 2 года назад

    That was dope!! Thank you!

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

  • @sangitparajuli1227
    @sangitparajuli1227 3 года назад +1

    well explained thanks !

  • @allanamone5171
    @allanamone5171 Год назад

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

  • @vbreddy4296
    @vbreddy4296 4 года назад +2

    SUMIT SIR AWESOME

  • @xmasgombakomba3322
    @xmasgombakomba3322 Год назад

    Fantastic stuff Sumit, thanks muchly

  • @sopaayun
    @sopaayun 10 месяцев назад

    Love it, thank you so much, god bless you

  • @Teesriflight
    @Teesriflight Месяц назад

    Good Job! Thank you for this.

  • @muhammadeilyas
    @muhammadeilyas Год назад

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

  • @vitoc.1535
    @vitoc.1535 11 месяцев назад

    Great video, thank you!

  • @emmanuelonuoha3642
    @emmanuelonuoha3642 2 года назад

    Nice work, thanks alot.

  • @NilanjanJanaofficial
    @NilanjanJanaofficial Месяц назад

    Very Helpful for Me. Thanks 👍

  • @rajeshnaik7207
    @rajeshnaik7207 2 года назад

    thank you so much very informative and useful infromation

  • @sowmyasankar4471
    @sowmyasankar4471 2 года назад +1

    Excellent Sumit 👏

  • @sv4430
    @sv4430 3 года назад

    Thank you.

  • @MrEms333
    @MrEms333 4 года назад +2

    Very Nice I hope can make like that one

  • @sanmu6325
    @sanmu6325 3 года назад

    Hi sumeet your videos are always good

  • @allanjuarez4303
    @allanjuarez4303 3 года назад

    Thanks a lot!

  • @junyusu5075
    @junyusu5075 3 года назад

    Thank you

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

  • @pkmbpkmb3499
    @pkmbpkmb3499 2 года назад

    Simply WOW

  • @adamchoi1352
    @adamchoi1352 Год назад

    Good video! Very helpful.

  • @subhashaswal31stdec
    @subhashaswal31stdec 3 года назад

    very helpful...tnx

  • @olaitanadekunleoyebola7528
    @olaitanadekunleoyebola7528 Год назад

    This is very much on point

  • @Gireesh_j
    @Gireesh_j Год назад

    Thank you…. It helps me a lot

  • @vishajoshi3500
    @vishajoshi3500 Год назад +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

  • @stephanychuquilin9764
    @stephanychuquilin9764 3 месяца назад

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

    • @trumpexcel
      @trumpexcel  3 месяца назад +1

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

  • @bollywoodkiharkhabar9262
    @bollywoodkiharkhabar9262 2 года назад

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

  • @uppariraghavendra3854
    @uppariraghavendra3854 Год назад

    Super very clear understand

  • @freddjensen9556
    @freddjensen9556 3 года назад

    Thanks

  • @budisetiadihermanto7445
    @budisetiadihermanto7445 2 года назад

    God bless you!!

  • @vedantsutar
    @vedantsutar 4 года назад +1

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

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

  • @raedmisen538
    @raedmisen538 Год назад

    VEERY HELPFUL , THANKS

  • @melodyLiang-cf9ww
    @melodyLiang-cf9ww 2 месяца назад

    Great video!!!

  • @Jepp392
    @Jepp392 2 года назад

    Great video! 10/10

  • @sreedharbabu4969
    @sreedharbabu4969 3 года назад

    Good one👍

  • @natarajang6125
    @natarajang6125 2 года назад

    Wow, amazing

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

  • @hassanmburia8825
    @hassanmburia8825 Год назад

    Thank you so much

  • @lilkloode
    @lilkloode 3 месяца назад

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

  • @iankr
    @iankr 3 года назад

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

  • @sherylleduna5367
    @sherylleduna5367 2 года назад

    Thanks!!

  • @hassanmburia8825
    @hassanmburia8825 Год назад

    I have created my team dashboard through the slice be blessed

  • @MuhamadYusufRamdhan
    @MuhamadYusufRamdhan 3 года назад

    thx dude

  • @arunachari2689
    @arunachari2689 Год назад

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

  • @JamesGarangDeng
    @JamesGarangDeng Год назад

    that is very fantastic

  • @fawaz84
    @fawaz84 2 года назад

    thank you

  • @wajahatrasheed1173
    @wajahatrasheed1173 2 года назад

    Fabulous

  • @lakhotiasupreet
    @lakhotiasupreet 3 года назад

    This is good

  • @mohammedjunaidofficial8321
    @mohammedjunaidofficial8321 3 года назад

    Nice

  • @victorj9320
    @victorj9320 Год назад

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

  • @suaiburrahman3582
    @suaiburrahman3582 Год назад

    Great 🙂

  • @telugu-malayalamlearning8032
    @telugu-malayalamlearning8032 10 месяцев назад

    Sooper yaar

  • @ottoambrose5448
    @ottoambrose5448 Год назад

    Great

  • @YasserIsmail
    @YasserIsmail 4 года назад +1

    well done

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

  • @jafarhussain6606
    @jafarhussain6606 3 года назад

    Please build a dashboard on supply chain KPIs with detailed steps

  • @sandeepmishra4233
    @sandeepmishra4233 Год назад

    Nice brother 😊

  • @Mad1080
    @Mad1080 9 месяцев назад

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

  • @gopeshsalhotra3499
    @gopeshsalhotra3499 3 года назад

    I need your help on top 10 customers on pivot tables

  • @rajshree4635
    @rajshree4635 2 года назад +1

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

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