Create Dynamic Sales Dashboard in Excel | With Voiceover

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

КОМЕНТАРІ • 80

  • @starX7995
    @starX7995 15 днів тому +1

    this is the best excel dashboard for any beginner out there just complete it.

  • @СергейКондулуков-з9ч
    @СергейКондулуков-з9ч 5 місяців тому +1

    Очень хороший урок. Вся кухня создания дашборда показана от начала и до конца. Всё дело в срезах :-)

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

    Superb presentation - Crisp and clear. Good show.

  • @ITGate24h
    @ITGate24h 2 місяці тому +1

    I loved the exercise. Thanks

  • @MustafaAli-yi2xu
    @MustafaAli-yi2xu Місяць тому +1

    Amazing Amazing Amazing bro.. keep up the good work.. your explanation is worth outstanding.

  • @agnaldodjive1673
    @agnaldodjive1673 3 місяці тому +2

    You just helped me a lot. great tutorial, thanks for sharing.

  • @jyotirmoybairagya4776
    @jyotirmoybairagya4776 9 місяців тому +1

    Sir, I really appreciate it and gain lots of knowledge please please share this main data sheet for utilisation 🎉

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

      Thank you for your kind words! I'm glad you found the video helpful. Absolutely, I've included the dataset in the description section for you to utilize. Let me know if you have any other questions or need further assistance!

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

    Very nice explanation... i have a query, is there any option to create in slicer, if we click the button it should get highlighted in different color till we click other button

  • @ragulmarley4900
    @ragulmarley4900 9 місяців тому +2

    Good one do more video like this really helpful for us 🎉

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

      Thank you very much! I'll create more helpful videos like this. If you have topics you'd like covered, let me know.

  • @RajeshAcharya-em7qk
    @RajeshAcharya-em7qk 5 місяців тому +2

    Thanks for this Share. Very easy to understand and practice.

    • @FinTechy
      @FinTechy  5 місяців тому

      You're welcome! I'm glad you found it easy to understand and practice.

  • @chinwe6341
    @chinwe6341 7 місяців тому +2

    Amazing Stuff. Thank you for attaching the data.

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

      Thanks! I'm happy to hear you found the tutorial useful.

  • @MuhammadRafi-hq6pl
    @MuhammadRafi-hq6pl 7 місяців тому +1

    Amazing job Fin techy.

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

      I'm glad you enjoyed it. Thanks!

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

    Excellent tutorial👌🏻👌🏻

  • @Rabbani_World_Flock
    @Rabbani_World_Flock 9 місяців тому +3

    I'm lucky I got it❤🎉🎉 subscriber number 74😂 growing

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

      Thank you very much :)

  • @jafetgonzaga9581
    @jafetgonzaga9581 6 місяців тому +2

    Hi, I'm new to making in excel. How can you copy the scrollbar and bargraph? I didn't see what your next step.

    • @keerthi-nf9kk
      @keerthi-nf9kk 5 місяців тому

      By default it is disabled need to enable by right click any where on the screen and search for customize the ribbon and on right side enable developer click okay

  • @MujahedMerghani
    @MujahedMerghani 26 днів тому +1

    amazing explanation but why you start work in PowerPoint

  • @claudiesoondar3577
    @claudiesoondar3577 2 місяці тому +1

    Great Dashboard, thanks. Can you create a Construction Project Dashboard

  • @mohammadharun2831
    @mohammadharun2831 2 місяці тому +1

    Thank you very much

  • @hemaraghu5202
    @hemaraghu5202 3 місяці тому +1

    Really thank you so much

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

    This is amazing... Can I get the dataset file please?
    Also waiting for more informative content

  • @binaykumar1616
    @binaykumar1616 3 місяці тому +2

    Very Nice.... thanks

  • @josephprecion5871
    @josephprecion5871 2 місяці тому +1

    Thanks for sharing

  • @mohammedbelattar8212
    @mohammedbelattar8212 5 місяців тому +1

    Thanks for this great work. Will you please share this dashboard !! (The data file is already shared . Thanks again)

  • @nagmanaikwadi-iy4pe
    @nagmanaikwadi-iy4pe 4 місяці тому +2

    Thank you very much sir

  • @emmanuelnduka3290
    @emmanuelnduka3290 9 місяців тому +3

    Please can you share the Excel file for us to work with? Thanks.

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

      Certainly! You can find the Excel file in the video description.

  • @dustyarcher
    @dustyarcher 5 місяців тому +2

    Great video and info thank you!
    Dusty

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

    At 8.43 min, as discussed in video, can't get the link even give the formula.. it is due to text box ?

  • @josephcalano8878
    @josephcalano8878 14 днів тому

    Are you doing personal tutoring?

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

    How does the past values table is stnc with Slicera??
    In this dashboard trechart is not syncing with slicers

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 9 місяців тому +1

    Thanks for the share.

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

      You're welcome!

  • @buddhikaperera5716
    @buddhikaperera5716 2 місяці тому +1

    thanks sir

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

    How to add new data in the same Dashboard?
    Like if we want to add next month data in the same dashboard

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

    Sir plz help,,,, i can not proper use in slicer,,,sir Report connecting korte giye only 1 pivote tabel show kortace,,,,

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

    what kind data that you use in this video sir?

  • @wendysmith1453
    @wendysmith1453 9 місяців тому +1

    Thanks for the video, can you share the file so I can follow along, please.

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

      Certainly! I'm happy that you found the video helpful. I've included the file in the description section for you to download and follow along. Let me know if you encounter any issues.

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

    How to create a reconciliation dashboard indicating how many breaks are there , how many are resolved and so on?

  • @irshadmurad
    @irshadmurad 6 місяців тому +1

    Nicely Done

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

    I copied and pasted both scroll bar and chart to the Dashboard, but the Chart is not dynamic even though the scroll bar works

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

    Can i get it?

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

    I am getting VALUE error when i am scrolling, first 5 data are coming perfectly in offset but for rest getting value error. Can you please help me on this. Thank you

  • @olayisadeadewole
    @olayisadeadewole 9 місяців тому +2

    How can i get the dataset file used ?

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

      You can find the Excel file in the video description section.

  • @ShreyushSharma
    @ShreyushSharma 9 місяців тому +1

    Great work ,really appreciate

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

      Thank you so much for your kind words! If you have any suggestions for future topics or any questions, feel free to let me know. Your feedback is invaluable!

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

    File will not updated because pivot table whats the solution?

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

    sir can u send the excel pdf to practice

  • @DeepakBesoya-g8b
    @DeepakBesoya-g8b 8 місяців тому

    How did you do offset - $Y$1. Unable to do that, it only shows cell value, please help

    • @manojkumaryaram3210
      @manojkumaryaram3210 7 місяців тому +1

      Yes , I'm also Facing Same Issue Kindly Requesting Please Help to this Issue

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

      After entering the formula don't press on enter. Press control+shift+enter it will work please try

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

      ​@@manojkumaryaram3210please try

  • @vaanibhardwaj3128
    @vaanibhardwaj3128 3 місяці тому +1

    Great

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

    The value is not changing while scrolling. It keeps showing the error. Kindly help.

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

      You have to connect scrolling bar to that the 1st cell which we have created … you can refer 20:05 from here and watch carefully

  • @francisjunius8013
    @francisjunius8013 5 місяців тому

    Please how do i get sql file you uploaded in the video

    • @FinTechy
      @FinTechy  5 місяців тому

      You can download the Excel Dashboard database file from the video description section.

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

    On 21:16 outside my first cust_id_001 to 005 the rest are showing invalid

    • @mandeepverma-j4h
      @mandeepverma-j4h 18 годин тому

      same error ..I dont know how to get CUST_ID_01 to CUST_IT_05 using offset formula. Please someone explain it

  • @Pratik-x4c
    @Pratik-x4c 2 місяці тому +1

    Sir plz appload video in hindi

  • @Maria-nz3mz
    @Maria-nz3mz 5 місяців тому

    where is dashboard file?

    • @FinTechy
      @FinTechy  5 місяців тому

      You can find the Dashboard file in the video description section.

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

    I have no idea why yo use the term loyal. Prehaps you are all dreamers.

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

    "promosm"

  • @javedagf
    @javedagf 21 годину тому

    Great, please contact, I need to discuss you some dashboard

  • @priscillangambi5805
    @priscillangambi5805 3 місяці тому +3

    I loved the exercise. Thanks

  • @mohamadadhikasuryahaidar7652
    @mohamadadhikasuryahaidar7652 9 місяців тому +3

    Can you share the excel file for exercise? thanks in advance.

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

      Absolutely! You can find the excel database in the description section of the video.