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

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

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

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

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

  • @YusufYusuf-q6b
    @YusufYusuf-q6b 5 дней назад +25

    Awesome tutorial! Can't believe how much I learned in just one video. On a side note, I’ve been using the Astirna New Tab extension to manage my browsing better, and it’s so convenient!

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

    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.

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

    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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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.

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

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

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

  • @BhadrikShah-x9o
    @BhadrikShah-x9o 18 дней назад +1

    this is a great tool providing the best training

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

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

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

      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

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

    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

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

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

  • @SmartTradingRU
    @SmartTradingRU 6 дней назад +3

    Класс! Пусть твои усилия всегда находят отклик!

  • @almerasegayo
    @almerasegayo 22 дня назад

    Ну что сказать, прям по этой видеоинстукции, так сказать, заработал немного денег. Без вопросов, работает. Спасибо за годную связку

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

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

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

    Looks pretty nice! 😀🤗

  • @alfaganteng9672
    @alfaganteng9672 Месяц назад +1

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

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

    اقدر اسويه في google sheets ؟ يعني اضيف شكل مربع مثلا، واضيف المعادلة فوق المربع واجمعهم ؟

  • @thebesttechnical3608
    @thebesttechnical3608 9 дней назад

    This dude literally knows everything.

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

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

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

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

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

    This is impressive! You have amazing skills!

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

  • @Tracks4You-e5f
    @Tracks4You-e5f Месяц назад

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

  • @AnasFathallah-i6q
    @AnasFathallah-i6q 23 дня назад +1

    I really appreciate your efforts! Could you help me with something unrelated: I have a okx with USDT, and I have the 12word phrases: ( proof inner hobby bounce blouse able donate virtual luggage cart morning ticket). What's the way to send them to Binance?

  • @megas2carol
    @megas2carol 6 дней назад +1

    Спасибо за ваши старания!

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

    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.

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

  • @NavbharatOA
    @NavbharatOA 6 дней назад

    Вот это добрейшее утро;)

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

    How is the small triangle shaped pointer in the top right progress bar move according to the changes of the bar chart?

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

    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?

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

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

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

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

      Thank you very much Karan, We appreciate that 😍

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

      its fake!!!

  • @AhmedSaber-t9f
    @AhmedSaber-t9f Год назад +3

    Great ! but how can i install thoes symbols

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

      Please visit our website www.other-levels.com

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

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

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

    this is pure gold

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

      We are working on that, Please Enjoy the playlist

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

    Thanks, looks really professional!

  • @buiminh2070
    @buiminh2070 5 дней назад +1

    Все понятно! Расскажите подробнее про...

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

    Awesome video! Thank you!

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

    Thats outstanding skills. Awesome. Thanks for sharing

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

    Greatest Dashboard EVER

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

    You're Genius !

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

    this is like artwork its so awesome

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

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

  • @SmartTradingRU
    @SmartTradingRU 6 дней назад

    Класс! Какие ресурсы для обучения лучше использовать?

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

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

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

    oh my god keeep goooing we all need id

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

  • @RayaMihaylova-s5w
    @RayaMihaylova-s5w 15 дней назад

    Thanks for explaining

  • @megas2carol
    @megas2carol 6 дней назад +1

    Супер! Я понял больше благодаря вашему видео!

  • @jihanramadhanidaulay10098
    @jihanramadhanidaulay10098 2 месяца назад +1

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

  • @IsaiasMore-q8s
    @IsaiasMore-q8s Месяц назад

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

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

    Best Dashboard ever

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

    Wow...this is sooooo awesome

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

    Damn that dashboard is heavenly neat...

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

    thank you for example big data and database tutorial

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

      You are welcome dear Cahyo

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

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

  • @posnic2016
    @posnic2016 15 дней назад

    Связка огонь, автору респект

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

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

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

    This dashboard is super, duper cool.

  • @sarfarazalam9890
    @sarfarazalam9890 7 дней назад

    thanku bro, ur videoes are very usefull

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

    Where do you get the icons from? I can't find them in the standard excel symbols list.

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

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

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

    Very Good Channel!!

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

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

    How you calculated profit?

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

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

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

      Profit = [Total Value]-[Bulit Cost]

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

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

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

      Merci chérie, nous apprécions cela

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

    Amazing, nice job!

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

      Thank you very much GIovanni

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

    Mshallah, such a professional dashboard

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

    You're a genius

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

    How can you do this with an investment portfolio since there is no real-time or close to real-time updates of the stock data? The only way you can get such data automatically is with the "Stocks" function in Microsoft 365, but that is only available online.

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

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

  • @Tcolonel
    @Tcolonel 7 дней назад +1

    супер связка, доходность опупительная

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

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

    wow awsome.. good job bro...

  • @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  3 года назад

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

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

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

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

      Most of them from Excel icon library, Thanks Raji

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

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

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

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

    Is it possible to do the same thing on Google sheet?

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

      We will publish google sheets dashboard ASAP, Thanks dear

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

    Great work 💐

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

    Can this be integrated into a CRM with Zapier or Pabbly to collect statistics and databases?

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

    What is the formula in square shape color topic (the color cell with i)?

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

      Which shape bro?

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

      At 21:26
      i
      the one that appear in red or yellow or green

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

      @@Asida028396 the idea is to get (Square Shape) from i Letter,
      1- insert 3 Textboxes
      2- Link each one with one of these cells (AH:12, AH:13, AH14)
      3- type formula in (AH:12, AH:13, AH14) if the Value in AF9 meets your target, so appears the target number if not meet the target so keep it empty.
      4- change (the new Textboxes ) colors,
      now when the above formula will be true so one of Textboxes will appear.

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

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

  • @ruts-rpc
    @ruts-rpc 2 года назад +2

    Can you share example file for edit ?

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

      Please visit our website www.other-levels.com

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

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

    Amazing work! One questions though, how do you manage to insert the arrow on the p&l bar to make it move if you change views etc. In video #2 the arrow is already there and moves if data changes… thanks!

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

      Add new series to the chart with same value cell but change its type to scatter and copy paste icon as formating and adjust X and Y values. Worked for me.

  • @megas2carol
    @megas2carol 6 дней назад +1

    Продолжайте в том же направлении

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

    Is there any sound in this video?