How to build Dynamic & Interactive Dashboard in EXCEL with Pivot Tables&Charts | Tutorial Episode #1

Поделиться
HTML-код
  • Опубликовано: 23 ноя 2024

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

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

    www.other-levels.com to download our Templates & Get Free Datasets

  • @purplestuffs5237
    @purplestuffs5237 2 года назад +35

    If only the internet was around when I was in school, this video would have made learning Excel in school easier.😂 Kids today do not realize how lucky they are that all this free information is available to them.

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

    Luar biasa, udah kayak melihat aplikasi yang berbeda. Terimakasih ilmunya min🙏

  • @leomacambira
    @leomacambira 6 месяцев назад +4

    You really are on another level! You make Excel easy!!! A big hug from your fan in Brazil. Thank you very much for the knowledge shared.

  • @ebitda9691
    @ebitda9691 3 года назад +840

    I never thought that I would ever be turned on by an excel spreadsheet...

    • @georgeb.6611
      @georgeb.6611 3 года назад +23

      Glad I’m not the only one 😂

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

      @@georgeb.6611 دذذ. ذو. ً

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

      دذذذددتعهنم ىووو

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

      @@rahul__sharma__ اللي عندك جحممخخ

    • @4gpaa
      @4gpaa 3 года назад +2

      My toes are curling up

  • @MrHydyr
    @MrHydyr 3 года назад +37

    WoW. Just WOW! It's the coolest thing I've ever seen in Excel. In fact in the whole Microsoft Office. Amazing. Keep going, add audio it will be very appreciated. Thank you again for sharing.

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

      Wonderful..Thank You Hydyr...More will come

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

      @@OtherLevels yes pls add audio! I couldn't follow it and I'm not even a Newbie when it comes to excel, so I am sure there are many other ppl who would have been turned off without any audio - I was literally checking my sound to see if it was working or not! 😂🙈

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

      @@fj3158 same here

  • @marcus-un6qt
    @marcus-un6qt 2 года назад +5

    wow your content with excel is freaking good

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

      I appreciate that, Glad you like our content

  • @PirachaNajeeb
    @PirachaNajeeb 4 года назад +16

    SubhanAllah. This is really the best dashboard I have ever seen. May Allah bless you with more knowledge and insight and reward you to help others.

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

      It's my pleasure

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

      @@OtherLevelscan you please guide how to publish the excel dashaboard. I have been facing this issue when it comes to sharing it

  • @marialyochoareyes8928
    @marialyochoareyes8928 8 месяцев назад +3

    Связка огонь, пока работает, пробуем 😮🎉

    • @OtherLevels
      @OtherLevels  8 месяцев назад +1

      Спасибо, дорогой @marialyochoareyes8928

  • @MardiGrasMobile36613
    @MardiGrasMobile36613 3 года назад +19

    OMG! You are so awesome. I have watched oodles and oodles and vids and most are blurry or just not very detailed in the step by step instructions. I just want to say thank you for being as dynamic as your dashboard! You are greatly appreciated.

  • @Tracks4You-e5f
    @Tracks4You-e5f День назад

    Лаба твои инсайды просто бомба! Жду новых идей.

  • @ITyraxI
    @ITyraxI 3 года назад +35

    Jesus. This looks nicer than my PBI dashboards. You're a legend.

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

    Best Excel dashboard tuto ever ! Thks you !

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

      you are welcome we are pleasure you liked

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

    Just stumble on this. Nice channel.

  • @vasurao1979
    @vasurao1979 3 года назад +37

    What a incredible dashboard on spreadsheet, I never come across till date.. great job

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

    Wosaaa. Love excel. Feeling cool when i was doin The fx & diagram thing that time

  • @alfaganteng9672
    @alfaganteng9672 8 дней назад

    Этот канал действительно шарит в арбитраже. Всегда интересно смотреть

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

    the making of this video is more amazing than what it tells

  • @davida.taylor8444
    @davida.taylor8444 3 года назад +61

    Great ideas here! I wish I had thought of using Insert Text Boxes to pull data from a pivot table for KPIs. I have an immediate use for this.

  • @shukuramartin5495
    @shukuramartin5495 Год назад +2

    this is so amazing , i cant wait to get started!

  • @fj3158
    @fj3158 3 года назад +4

    @Other Level’s pls add audio! I couldn't follow it and I'm not even a Newbie when it comes to excel, so I am sure there are many other ppl who would have been turned off without any audio - I was literally checking my sound to see if it was working or not! 😂🙈

    • @OtherLevels
      @OtherLevels  2 года назад +2

      We are working on that, Please Enjoy the playlist

  • @IsaiasMore-q8s
    @IsaiasMore-q8s День назад

    Связка работает отлично, лаб молодец!

  • @shreejithnair3128
    @shreejithnair3128 4 года назад +7

    Nice workn!!! Please add audio if possible..
    Can I get this file???

  • @tusharmishra3080
    @tusharmishra3080 2 года назад +8

    Great video, but don't have audio for it.. could you please add voice-over so that it's better understandable. Thanks

    • @OtherLevels
      @OtherLevels  2 года назад +2

      Thank you Tushar ,Soon, We gonna publish updated version with voiceover explanation, wait for it

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

      @@OtherLevels great tutorial. Just following up to see if the voiceover version was ever uploaded. Thanks a bunch.

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

    This dashboard is super, duper cool.

  • @CustAndCode
    @CustAndCode Год назад +2

    Looks pretty nice! 😀🤗

  • @Tedchemog
    @Tedchemog 8 месяцев назад +1

    Did you use a little of gel with the water? Your hair looked to stick together more (especially when you had your hair standing up) when I expect with just water.

  • @santox2000
    @santox2000 21 день назад

    Связка отличная, респект автору!

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

    this is like artwork its so awesome

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

    Damn that dashboard is heavenly neat...

  • @milenaandric3992
    @milenaandric3992 3 года назад +59

    This is impressive! You have amazing skills!

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

    Woaahhh... This dashboard looked like another CRM for generating reports! 🎊🎉👏

  • @k10633
    @k10633 3 года назад +44

    Amazing work this gave me good grades thanks a lot, was standing apart in my whole class ❤️

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

      Thank you very much Karan, We appreciate that 😍

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

      its fake!!!

  • @mariaalcala5159
    @mariaalcala5159 3 года назад +104

    Wow That is amazing I cannot find the proper words to describe how amazing and professional that dashboard is. Great job! By far the most beautiful and perfect dashboard I ever seen!
    I struggle a lot with the different use of colors for my dashboards but what you do is just incredible! I was actually thinking of doing a course in visual design. Do you have any advice?

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

    Thats outstanding skills. Awesome. Thanks for sharing

  • @ambarilhamchannel
    @ambarilhamchannel 2 года назад +2

    What you do there is great, not merely a dashboard but also you involved art inside that

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

    Hello, nice tutorial, I am still following it. It is really hard but very enlightening.
    I would like to ask why we don't use the count different for PO numbers, shouldn't we want to know distinct number quantities?

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

      Join our channel, and get answers to all your questions:
      ruclips.net/channel/UCuDF09RGFE3V3lY77Z_cA9gjoin

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

    your channel and almost video issue from you very specific, it's mean, show your passion on this, wonderful,
    thank you so much

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

      I appreciate that! Thank you very much

  • @elkassebdrive
    @elkassebdrive День назад

    Спасибо за пошаговый разбор, все просто как пять копеек а заработок не копеечный)

  • @stefanomeola3028
    @stefanomeola3028 2 года назад +12

    Impressive visual skills applied to Excel. Looks like Power BI or similar indeed

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

    Thanks, looks really professional!

  • @tujams9307
    @tujams9307 2 года назад +2

    It's amazing, a video speaks it very clearly, nice

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

      Thank you! it will be ready within a month

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

      @@OtherLevels I dn't know how to tact u,and I want to collaborate with u on a video. Can U give me?

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

    Всё проверил, спасибо за связку.

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

    thank you for example big data and database tutorial

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

      You are welcome dear Cahyo

  • @roviskyksa5050
    @roviskyksa5050 4 года назад +7

    oh my god keeep goooing we all need id

  • @systemtourtvganesh
    @systemtourtvganesh Год назад +2

    Hats off to your creativity. Definitely you are just above awesome level ❤

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

    Really dashboard explanation is great way. i can't think why voice is slint.

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

      Kindly find the updated video tutorial:
      Thanks dear @akhileshmandal6432

  • @sa5er1234
    @sa5er1234 2 года назад +6

    This is achievable with consistent data and with such feed. Sadly, departments are usually not unified in terms of reports.

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

    this is pure gold

  • @AJ-et3vf
    @AJ-et3vf 2 года назад +1

    Awesome video! Thank you!

  • @AhmedMohammed-oq6tw
    @AhmedMohammed-oq6tw 4 года назад +2

    Greatest Dashboard EVER

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

    That was cool, So I don't need figma for advance if I can learn from the basic. Anyway, this video are give me another way to design. I don't need to confuse this time. Thank you so much!! I'ts mean a lot for me.

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

    You're Genius !

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

    Ya ALLAH har insan kamyab ho har insan ko sehat izat or beshumar Dolat Or beshumar rehmatain berkatin ata farma Ameen.

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

    Mshallah, such a professional dashboard

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

    It looks great. Nicely done. However, there is no audio.

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

      Thank you Romel, Soon, We gonna publish updated version with voiceover explanation, wait for it

  • @RovyDigitalArt
    @RovyDigitalArt 4 года назад +3

    Best Dashboard ever

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

    Great work, if you add audio it will be more great

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

      Working on it ,Thanks Nelson

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

    You're a genius

  • @esraaramadan9579
    @esraaramadan9579 2 года назад +5

    big thank you other level's for that amazing toutorial

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

      Much welcome, to get dataset please visit our website www.other-levels.com

  • @AhmedSaber-t9f
    @AhmedSaber-t9f 11 месяцев назад +2

    Great ! but how can i install thoes symbols

    • @OtherLevels
      @OtherLevels  9 месяцев назад +1

      Please visit our website www.other-levels.com

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

    wow awsome.. good job bro...

  • @blakewood4756
    @blakewood4756 3 года назад +6

    I have to confess.. I spent several minutes trying to figure out why the sound on my computer wasnt working.... Great demo tho

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

      We started add voiceover to our videos, and also we will add VoiceOver to all previous videos very soon, Enjoy Blake

    • @aniket.kumarr
      @aniket.kumarr 3 года назад +4

      I was wondering the same.. and the lack of any comments mentioning sound made it feel more and more like the "fault" was on my end.. 😅😂

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

      Same for me 🤣🤣

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

    Hi, I appreciate great work .But I was wondering if its possible to get raw data for this exercise , for easy tutorial follow up
    Thank you

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

      Thanks dear Godfrey glad you like our content
      Kindly visit our website to get the datasets for training and practicing
      www.other-levels.com/blogs/datasets

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

      @@OtherLevels Thanks alot

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

    Wow I have learned so much from this one video

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

    Great sir . .. how can i watch your second episode .

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

      To watch all videos tutorials of our designs and learn how to create them,
      please join Other Levels Membership and get up to a 15% discount on our templates:
      ruclips.net/channel/UCuDF09RGFE3V3lY77Z_cA9gjoin

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

    Looks great, but it is hard to follow without sound

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

      Thanks, soon we will publish new version with voice over

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

    Please let me know which version of Excel you are using, and whether need to add with any plugin. Thanks

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

    Wow...this is sooooo awesome

  • @JD-eu9ld
    @JD-eu9ld 2 года назад +2

    This looks so good! Similar to the ones I see in investment portfolios.

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

    Amazing, nice job!

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

      Thank you very much GIovanni

  • @20djps
    @20djps 3 года назад +43

    Am I the only one who cannot listen to the Audio?

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

    Vous êtes un dieu vivant du logiciel excel.
    Comment faites vous pour maîtriser toutes ces données du bout du doigt ?

    • @OtherLevels
      @OtherLevels  9 месяцев назад +1

      Merci chérie, nous apprécions cela

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

    Wow such an amazing work. I just want to try ... where will I get this icons?

    • @OtherLevels
      @OtherLevels  2 года назад +2

      Most of them from Excel icon library, Thanks Raji

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

    Wow it's amazing..,! Can I get excel data file for practice.. I also want to creat same as it is..

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

      To get the datasets, visit our online store:
      www.other-levels.com

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

    I need this one in my business.

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

      Please visit our website www.other-levels.com

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

    Не плохая связка. Процесс использования, такой же легкий, как у предыдущих

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

    How did u make the arrow on the target bar dynamic? Great work btw

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

    Very Good Channel!!

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

    Where do you get the icons from? Really nice video also.

  • @DrDonBoo815
    @DrDonBoo815 2 года назад +2

    This would have been awesome if it was paired with a translator or audio.

  • @lephuc1986
    @lephuc1986 3 года назад +4

    Thank you for your video, it's amazing!

  • @Kiran.KillStreak
    @Kiran.KillStreak 2 года назад +1

    nice work.

  • @yahahaa112
    @yahahaa112 2 года назад +2

    would love something like this for tracking support volumes, staffing and resolution times!

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

      Have you tried Power BI? If you have access to it its essentially the same but simplified

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

    Excellent ! Je suis très impressionné. Bravo

  • @kiranhpe9333
    @kiranhpe9333 3 года назад +16

    Hi, This looks great. Do you have a sample of the 'Main Table' available for download so that I can follow your tutorial ? Thank You.

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

    Ý tưởng tuyệt vời ở đây! Tôi ước gì tôi đã nghĩ đến việc sử dụng Chèn hộp văn bản để lấy dữ liệu từ bảng tổng hợp cho KPI. Tôi sẽ tập làm thử ngay lập tức cho điều này.

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

    Thank you for your very beautiful tutorial .. It is possible to put an Excel database file to accompany your tutorial

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

      Thanks brother...Please visit our website www.other-levels.com

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

      @@OtherLevels Thank you very much for your answer .... I do not want the dashboard ... the Excel file that has the data and based on its information, you gave this tutorial .... If possible, put the download link for that Excel file,please. Thank you very much.

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

      Ok Mojtaba...please contact us

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

    Great work 💐

  • @VuNguyen-ey9dj
    @VuNguyen-ey9dj 3 года назад +9

    Wow, this is amazing! Does this thing require a high perform CPU also?

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

    Hi Great video - just wondering how you make the up down arrow dynamic in the second last Text box on top right

  • @BelajarBersama-v2e
    @BelajarBersama-v2e 3 года назад

    Thank you your video is very nice👍🙏

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

    owsome :-)
    can you crete basice to advance in one vedios for job regarding vedios

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

    Tidak bisa berkata kata sungguh hebat

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

      Terima kasih banyak Aisyah

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

    awesome video. need Bangla subtitles

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

    This is soooo coooooooool. Will give it a try thanks heaps for sharing

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

    Quite unique but my thoughts, it is more valuable and suitable even though func data is more simple

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

    This is awesome well done sir ..could you share the final copy😃

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

    Wonderful work buddy!

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

    Woww.. could you please give me the link for the next part

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

      ruclips.net/video/K6jCpXlyWNI/видео.html
      ruclips.net/video/11JBU8iUAJs/видео.html
      ruclips.net/video/0vK2zRT3ixg/видео.html
      Enjoy buddy