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

Full Tutorial with voice over explanation:
• How to build Dynamic &...
Download our Templates / Get Free Datasets
Visit our online store www.other-levels.com
Hire our team to join your company
other-levels.com/products/hir...
Request a Custom Dashboard
other-levels.com/pages/custom...
To watch the full Tutorials? Join our channel Membership
/ @otherlevels
Contact us for business:
Comment down below
Customer services www.other-levels.com
All our videos / otherlevel’s
Playlists
Multiple Dynamic Excel Dashboards • How to build Dynamic &...
Single Dynamic Excel Dashboard • Excel Real Estate and ...
Modern Excel Reports • Modern Excel Reports
PowerPoint Slides Playlist • How to Design a Modern...
Copyright © 2024 Other Level's. All rights reserved.
#Excel #Dashboard #Excel_dashboard
--------------
#create_dashboard_in_excel #dash_board #dashboard #dashboard_design #dashboard_design_in_excel #dashboard_en_excel #dashboard_excel #dashboard_excel_pivot_table #dashboard_excel_tutorial #dashboard_in_excel #dashboard_powerpoint #dashboards #dashboards_in_excel #dynamic_dashboard #dynamic_dashboard_in_excel #dynamic_excel_dashboard #excel #excel_dashboard #excel_dashboard_design #excel_dashboard_design_ideas #excel_dashboard_for_beginners #excel_dashboard_templates #excel_dashboard_tutorial #excel_dashboards #excel_dashboards_and_reports #excel_design #excel_dynamic_dashboard #excel_interactive_dashboard #excel_report_design #excel_reports_and_dashboards #financial_dashboard_excel #how_to_build_interactive_excel_dashboards #how_to_create_a_dashboard_in_excel #how_to_create_dashboard_in_excel #how_to_make_dashboard_in_excel #hr_dashboard_excel #interactive_dashboard #interactive_dashboard_in_excel #interactive_excel_dashboard #kpi_dashboard_in_excel #organization_chart_powerpoint #other_level #performance_dashboard_in_excel #pivot_table_dashboard #powerpoint_dashboard #project_dashboard_excel #project_management_dashboard #sales_dashboard_in_excel #дашборд_excel #داشبورد #لوحة_على_إكسسيل #لوحة_اكسيل #المبيعات_لوحة_في_إكسسل #المبيعات_لوحة_القيادة #مبيعات_تحليل #مستويات_أخرى #계기반 #뛰어나다 #엑셀_대시_보드 #Excelisfun #excel_on_fire #MyOnlineTrainingHub #The_office_lab #엑셀_대시보드 #vba_excel #sales_dashboard #sales_analytics #performance_dashboard #other_levels #kpi_dashboard #hr_dashboard #financial_dashboard #dashboards_excel #dashbord #dashboard_on_excel #dash_board_in_excel #dash_board_excel #Multiple_Dynamic_Excel_Dashboards #Uploads_from_Other_Levels #TopSaved #Single_Dynamic_Excel_Dashboard #PowerPoint_UIUX_Templates #PowerPoint_Templates #PowerPoint_Slides #PowerPoint_Dashboards #Popular_uploads #Organizational_Structure_Charts #Modern_Excel_Reports #Mix_Presentation #Islamic_PowerPoint_Templates #G_Excel #EXCEL_videos #Data_Analysis_by_PowerPoint #CV_Resume_Templates

[@OtherLevels]

Full Tutorial with voice over explanation: kzbin.info/www/bejne/pGndea2Jdtd5fMk

[@jonasgunnarsson7050]

😊

[@purplestuffs5237]

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.

[@MardiGrasMobile36613]

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.

[@OtherLevels]

Wow, thank you! Mardigras..Enjoy

[@arunkumark6351]

So true

[@vasurao1979]

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

[@mrCetus]

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]

Thank you very much, soon we will publish new version with voice over

[@leomacambira]

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.

[@davida.taylor8444]

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.

[@mariaalcala5159]

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?

[@nagurarun9420]

Bb

[@nagamani4113]

@@nagurarun9420 x Ďxdxďxdvyd xxxxxx d xxxxxx D

[@JD-eu9ld]

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

[@stefanomeola3028]

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

[@nguemalebizulrich9496]

Excellent ! Je suis très impressionné. Bravo

[@ITyraxI]

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

[@ambarilhamchannel]

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

[@neivnot]

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

[@milenaandric3992]

This is impressive! You have amazing skills!

[@OtherLevels]

Thank You Milena...enjoy

[@koushikkumar3967]

No sound

[@k10633]

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

[@OtherLevels]

Thank you very much Karan, We appreciate that 😍

[@rav1495]

its fake!!!

[@shukuramartin5495]

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

[@PirachaNajeeb]

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]

It's my pleasure

[@ziarehman482]

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

[@lephuc1986]

Thank you for your video, it's amazing!

[@OtherLevels]

Thank you Le...Enjoy

[@cheoles4190]

Best Excel dashboard tuto ever ! Thks you !

[@OtherLevels]

you are welcome we are pleasure you liked

[@stonedflame]

this is like artwork its so awesome

[@AhmedMohammed-oq6tw]

Greatest Dashboard EVER

[@roviskyksa5050]

oh my god keeep goooing we all need id

[@OMMI100m]

Just stumble on this. Nice channel.

[@marcus-un6qt]

wow your content with excel is freaking good

[@OtherLevels]

I appreciate that, Glad you like our content

[@manwendersingh5749]

Wonderful work buddy!

[@hshhsjhahsvs7728]

Thats outstanding skills. Awesome. Thanks for sharing

[@OtherLevels]

Appreciate you like 😍

[@pauljoseph3081]

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

[@user-ii4ts8eg9f]

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

[@PurinV]

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

[@nigelokeeffe6461]

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

[@thenewdataguy]

Thanks, looks really professional!

[@OtherLevels]

Glad you like it!

[@kiranhpe9333]

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.

[@ebitda9691]

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

[@georgeb.6611]

Glad I’m not the only one 😂

[@saal8098]

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

[@saal8098]

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

[@saal8098]

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

[@4gpaa]

My toes are curling up

[@RovyDigitalArt]

Best Dashboard ever

[@CustAndCode]

Looks pretty nice! 😀🤗

[@Ashkanani7]

Wow I have learned so much from this one video

[@haiodaalbardee5666]

Awesome , Wonderful :)

[@esraaramadan9579]

big thank you other level's for that amazing toutorial

[@OtherLevels]

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

[@rahmadsalehlaia5832]

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

[@OtherLevels]

terima kasih banyak

[@theuninspiredlife657]

Damn that dashboard is heavenly neat...

[@lucasmontenario935]

this is pure gold

[@brightagbenuvor2880]

Intuitive videos. Keep it up Snr

[@rtrkings1173]

Great work 💐

[@ifeanyioji6964]

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

[@tranalice1758]

amz !! i really love it

[@yahahaa112]

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

[@phd_gaming5010]

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

[@toluwalopeolatunji]

This dashboard is super, duper cool.

[@OtherLevels]

Thank you

[@sucsatumama]

al menos seria bueno la tabla base para practicar a su ritmo, pero si no se puede igual se le agradece el gran aporte realizado , gracias.👍

[@AJ-et3vf]

Awesome video! Thank you!

[@OtherLevels]

Glad you liked it!

[@giovannicordella7733]

Amazing, nice job!

[@OtherLevels]

Thank you very much GIovanni

[@akashbiswas4896]

Very nice video....amazing work❤❤❤

[@OtherLevels]

Many many thanks

[@freecity7553]

That is amazing 😱 nice work

[@OtherLevels]

Glad you like it!

[@withrejkapermana6087]

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.

[@tujams9307]

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

[@OtherLevels]

Thank you! it will be ready within a month

[@tujams9307]

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

[@IzzyQuil]

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

[@blueberryandme]

You are a legend ❤️

[@marialyochoareyes8928]

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

[@OtherLevels]

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

[@VuNguyen-ey9dj]

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

[@OtherLevels]

No Need, Thank You Vu

[@namdaunhat8679]

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

[@OtherLevels]

I appreciate that! Thank you very much

[@athanasiosbasios9133]

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]

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.

[@shreejithnair3128]

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

[@bibybsa7921]

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]

Join our channel, and get answers to all your questions: kzbin.info/door/uDF09RGFE3V3lY77Z_cA9gjoin

[@NguyenHuy-fg5tm]

Wonderful !!!

[@creativeideaofficial2836]

Thank you your video is very nice👍🙏

[@systemtourtvganesh]

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

[@OtherLevels]

Thank you so much 😀

[@basiouny96]

You're Genius !

[@OtherLevels]

Thank you very much

[@hermesjunior7770]

Hi! Would it be possible to ever enable automatic subtitles for your videos?

[@yohannesyokomichi6773]

This is amazing! Is it possible to do this in google sheets with a much more simpler datasets?

[@OtherLevels]

Yes ,but google sheets not support slicers

[@riyasissuedeen8007]

@@OtherLevels in google sheet, under data tab, we can find slicer option right?

[@wizerdcloe]

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

[@DevN9007]

Thank you so much!

[@OtherLevels]

You're welcome! Enjoy

[@peterkariuki5140]

Wow...this is sooooo awesome

[@OtherLevels]

Thank you peter 😍

[@etekumoses3320]

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

[@palanik2302]

Amazing

[@iqbalgamingteam7482]

Noted. Thanks before

[@ahmedkhalil9965]

Mshallah, such a professional dashboard

[@Tedchemog]

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.

[@WilliamRandomUploads]

Amazing stuffs

[@bahadirkzlkaya]

wow awsome.. good job bro...

[@OtherLevels]

Thank you very much bro

[@tusharmishra3080]

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

[@OtherLevels]

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

[@rhealye]

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

[@CahyoPilar]

thank you for example big data and database tutorial

[@OtherLevels]

You are welcome dear Cahyo

[@fiesto11]

Very Good Channel!!

[@OtherLevels]

Most Welcome bro

[@rajiahilan9336]

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

[@OtherLevels]

Most of them from Excel icon library, Thanks Raji

[@sa5er1234]

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

[@shivamfinace]

You're a genius

[@OtherLevels]

Thank you very much

[@cristianviales]

Just amazing

[@OtherLevels]

Thax Cristian...enjoy

[@cristianviales]

You welcome, I am very interested in the future of the channel and I have not seen any other with this characteristic of professionalism and perfection in dashboards

[@OtherLevels]

​@@cristianviales thank you for your great words...much appreciated 😊

[@nelsonachoka7918]

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

[@OtherLevels]

Working on it ,Thanks Nelson

[@shijirtuyakh5827]

Hi, dashboard is amazing. Thanks for your tutorial. I have a question to ask from 29:25. How can i see other sheets inside the dashboard without moving to that sheet?

[@OtherLevels]

Dear bro Thank You... you need to unify the header and lift slicers design with same color and dimensions then copy and paste for all sheets, wait for tutorial #5 to know how to do this feature and more...

[@Vjsodhi]

@@OtherLevels when will you make the episode 5, eagerly waiting..thanks for this awesome work btw

[@OtherLevels]

@@Vjsodhi Soon...Thanks bro

[@cicciogrecia]

Great job but I think Power BI would be more efficient for this type of dashboards

[@fj3158]

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

We are working on that, Please Enjoy the playlist

[@hongphonginh4346]

Ý 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.

[@Kiran.KillStreak]

nice work.

[@OtherLevels]

Thanks!

[@mojtabafazeli2140]

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

[@OtherLevels]

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

[@mojtabafazeli2140]

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

Ok Mojtaba...please contact us

[@tuchu2150]

amazing

[@jonasferreira215]

Can you put the Data Base that you used to make this dashboard under the video?

[@kailyeoh]

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

[@tomogorman3947]

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

[@romelnunez1248]

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

[@OtherLevels]

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

[@fuhrer50]

أحلى شغل يا هندسة 😉 بس لو سمحت ما هو سنة اصدار برنامج الاكسل الموجود بالشرح ؟؟

[@OtherLevels]

Microsoft excel 365 dear

[@waitong3458]

Cool!