How to build an outstanding Excel dashboard

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

КОМЕНТАРІ • 67

  • @tanofreeborn994
    @tanofreeborn994 7 місяців тому +8

    This Guy is spitting knowledge for free, I have learnt so much from just one video. Plus your explanantions are very easy to understand. Thank you so much.😘😘😘😘😘

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

    I can't even lie; this is the first time I'll complete a long yt video at once.

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

    God bless you, boss. I have created a dashboard using these datasets and the following procedures.

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

    sir, the excel am using dosnt have option to paste custome colors in it. so i had to select different color just to follow up your steps and i must say you re really a genius data analysis.

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

    God bless you.. your explanation is very simple and easy.

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

    Thank you. You did provide Dataset for this video. It would be very kind of you if you provide datasets for your other videos as well. It would be very helpful for learning and practice.

  • @aishattola9068
    @aishattola9068 11 місяців тому +3

    Thanks a lot for sharing this. You did a lot in the video starting from the ear soothing background music which made me enjoy every second of learning to the way you pointed out the littlest mistake one could make while replicating this. Learning to make to a dashboard was enjoyable thanks to you 👍

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

    I really love this video..Very well understood! I learnt alot already
    Thank you so Much.God bless you for this💯

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

    How beautifully you have created it sir. It's really useful and looks attractive.

  • @peace-is-happy7046
    @peace-is-happy7046 4 місяці тому

    Bro...Keep Going we always get caught up in different avenues and the MIND can't think and this really put a curve in the Market on these YT Videos....Preciate it....

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

    Thank you very much. You did fantastic and helpful dashboard.

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

    Great job! Keep them coming but please use a more calming background music so we can focus better on what you're saying. Thanks

  • @akoladeolawale266
    @akoladeolawale266 11 місяців тому +1

    Really Appreciate this breakdown, This was an Enjoyable Experience.

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

    Thank you for this insightful video. It is really helpful. God bless brother

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

    God bless you, really insightful.... Thanks

  • @allikbdy467
    @allikbdy467 11 місяців тому +1

    Thanks man! I learned a lot! Hope i will be able to my report like this.

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

    This was really helpful i was able to complete it but couldn’t save it didn’t see it on my excel I would really appreciate if you anybody can help me out

  • @datalab365
    @datalab365 11 місяців тому +1

    Good work.

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

    am having a little challenge after following the whole steps, i highted to save as picture but it didnt bring the option, if i may ask i thing you re using another version of excel, could you plese advise to install. am using 2019 version and some of the features you re using is not in it but i had to use itlike that and i got the whole steps right. thank you sir for the kowledge sharing.

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

    I love this i will try it

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

    Fantastic video

  • @Ghost-qv4ev
    @Ghost-qv4ev 9 місяців тому +1

    HI, I don't have (different from ) option here as to What I should do. ( 16:45) I am using Mac 2021 version.

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

    Thanks Kevin that very helpfull

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

    Awesome, can't wait to do mine

  • @NahidK.A-ff8yc
    @NahidK.A-ff8yc 10 місяців тому +1

    Thanks🙏 it's very helpful

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

    Your dashboard is awesome, infact I learned a lot, however the color coding is not consistent and can be confusing. What I mean is that Sales and Profit bar colors shouldnt have the same color as the segment colors. It would make it confusing.

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

    Thank you very much

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

    God bless you for these insightful video Sir..Please i'll like you to suggest a site where we can have access to more data sets like dis for our personal practice.. Thank you Sir.

  • @TophKhris
    @TophKhris 29 днів тому

    there's no save as picture on my excel 😢😢

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

    Amazing...Thank you so much... you saved my ass

  • @onifadeseun8698
    @onifadeseun8698 15 днів тому

    Pls sir is there a way I can import colors the way you did in this video,...on Excel version 2013

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

      One way to go about it is to look at the colour ranges after he's pasted the colour codes.
      That way you can get the ranges for the three colours. This means that you have to pause the video at the point where he pastes the code.
      Umm... How about you update your Excel?

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

    1;18 im not able to delete sum of profit option while making an chart at left side,
    Column Labels
    2014 2015 2016 2017 Grand Total
    Sum of Profit 49,544 61,619 81,795 93,439 286,397

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

    this is super cool

  • @AyodeleOyerinde
    @AyodeleOyerinde 11 днів тому

    Someone should please help with 'preventing deletion of imputed data in excel sheet' (I want the user to impute data into excel sheet but shouldn't be able to delete or modify imputes

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

    Thanks a lot for this. Please, when I wanted to save the dashboard as a picture, after right clicking as you did, there is no 'save as picture' option from the drop down , please how else can I save it as picture? Thanks

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

    Thank you 🙏

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

    it look like some of us re using different excel. i bearly get it

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

    Hello, Thanks so much for your video. I just finished designing my dashboard and suddenly seeing “reference isn’t valid”😢 and I am submitting it for my assignment. pls help…

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

      Has this been sorted now.

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

      @@tosinilesanmi3778 yes, it has. I struggled it out through google. Thank you.

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

    This is wonderful. I will like a chat with you to discuss something nice for my company.

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

      You can reach out to me on LinkedIn

  • @kardiiobi321
    @kardiiobi321 11 місяців тому +2

    Please how do I upload on LinkedIn please my dashboard

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

    awesome!

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

    Thanks for this video. I tried it out. Please Sir, the point to safe the page as picture is not working on my excel 2016

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

      Yh, 2016 does not have the features.
      You can do a screenshot

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

      Thank you very much boss.
      I want to know the year of excel you use, so i can upgrade to such Sir.@@AnalyticsExtra

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

    amazing!!

  • @user-zb4oe3zw2m
    @user-zb4oe3zw2m 7 місяців тому

    outstanding hahahah thats great bro

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

    Hey. What Microsoft Office do you use? I use 2019 version and I cannot insert the color code. I do not have the Hex option. Can you advise me what can I do? Thanks

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

      Please convert the Hex to RGB with google and use the RGB instead.
      I am currently using M365

  • @kardiiobi321
    @kardiiobi321 11 місяців тому +1

    Secondly please next time reduce the background music please it's distracting

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

    300ΜΒ file😂