How to build an outstanding Excel dashboard

Поделиться
HTML-код
  • Опубликовано: 5 сен 2024
  • Excel Project Challenge for Analytics Corper 2.0
    Dataset
    drive.google.c...
    Color Palettes
    coolors.co/pal...

Комментарии • 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.

  • @harissiddiqui5857
    @harissiddiqui5857 5 месяцев назад +2

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

  • @aneruhassan8225
    @aneruhassan8225 4 месяца назад +1

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

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

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

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

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

  • @venkatsandeepsr
    @venkatsandeepsr 4 месяца назад

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

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

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

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

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

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

    Thanks Kevin that very helpfull

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

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

  • @NahidK.A-ff8yc
    @NahidK.A-ff8yc 10 месяцев назад +1

    Thanks🙏 it's very helpful

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

    I love this i will try it

  • @datalab365
    @datalab365 11 месяцев назад +1

    Good work.

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

  • @boorayyan9
    @boorayyan9 8 месяцев назад

    Fantastic video

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

    Thank you very much

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

  • @abatanadeyinka1073
    @abatanadeyinka1073 11 месяцев назад

    Awesome, can't wait to do mine

  • @emmavpgh
    @emmavpgh 2 месяца назад

    this is super cool

  • @chinuzoejima8971
    @chinuzoejima8971 12 дней назад

    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

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

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

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

  • @TophKhris
    @TophKhris 28 дней назад

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

  • @onifadeseun8698
    @onifadeseun8698 14 дней назад

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

    • @solomonikhuoria1526
      @solomonikhuoria1526 13 дней назад

      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?

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

    awesome!

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

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

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

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

  • @AyodeleOyerinde
    @AyodeleOyerinde 10 дней назад

    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

  • @kardiiobi321
    @kardiiobi321 11 месяцев назад +2

    Please how do I upload on LinkedIn please my dashboard

  • @aimeenatya
    @aimeenatya 4 месяца назад

    amazing!!

  • @VVM3388
    @VVM3388 7 месяцев назад

    Thank you 🙏

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

  • @user-zb4oe3zw2m
    @user-zb4oe3zw2m 7 месяцев назад

    outstanding hahahah thats great bro

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

  • @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  8 месяцев назад

      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 8 месяцев назад

    300ΜΒ file😂