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-leve...
Hire our team to join your company
other-levels.c...
Request a Custom Dashboard
other-levels.c...
To watch the full Tutorials? Join our channel Membership
/ @otherlevels
Contact us for business:
Comment down below
Customer services www.other-leve...
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]

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

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

[@MrHydyr]

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]

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

[@fj3158]

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

@@fj3158 same here

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

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

[@rahmadsalehlaia5832]

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

[@OtherLevels]

terima kasih banyak

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

[@ITyraxI]

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

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

[@marcus-un6qt]

wow your content with excel is freaking good

[@OtherLevels]

I appreciate that, Glad you like our content

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

[@vasurao1979]

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

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

[@alfaganteng9672]

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

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

[@MMOI96]

Just stumble on this. Nice channel.

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

[@marialyochoareyes8928]

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

[@OtherLevels]

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

[@cheoles4190]

Best Excel dashboard tuto ever ! Thks you !

[@OtherLevels]

you are welcome we are pleasure you liked

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

[@CustAndCode]

Looks pretty nice! 😀🤗

[@stefanomeola3028]

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

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

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

[@pauljoseph3081]

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

[@bthfjyvjiuyh]

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

[@shukuramartin5495]

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

[@toluwalopeolatunji]

This dashboard is super, duper cool.

[@OtherLevels]

Thank you

[@ambarilhamchannel]

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

[@20djps]

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

[@Userm2040]

No. Me too

[@koraygozukucuk]

​@@Userm2040video is mute.

[@muhammedwaked4684]

+١

[@alone1a]

I think there is no audio

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

[@roviskyksa5050]

oh my god keeep goooing we all need id

[@theuninspiredlife657]

Damn that dashboard is heavenly neat...

[@systemtourtvganesh]

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

[@OtherLevels]

Thank you so much 😀

[@stonedflame]

this is like artwork its so awesome

[@akhileshmandal6432]

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

[@OtherLevels]

Kindly find the updated video tutorial: Thanks dear @akhileshmandal6432

[@sa5er1234]

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

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

[@hshhsjhahsvs7728]

Thats outstanding skills. Awesome. Thanks for sharing

[@OtherLevels]

Appreciate you like 😍

[@BCCDAILYPAK]

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

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

[@santox2000]

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

[@VuNguyen-ey9dj]

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

[@OtherLevels]

No Need, Thank You Vu

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

[@thenewdataguy]

Thanks, looks really professional!

[@OtherLevels]

Glad you like it!

[@AhmedMohammed-oq6tw]

Greatest Dashboard EVER

[@Pujalovers]

thank you for example big data and database tutorial

[@OtherLevels]

You are welcome dear Cahyo

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

[@JD-eu9ld]

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

[@RovyDigitalArt]

Best Dashboard ever

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

[@AJ-et3vf]

Awesome video! Thank you!

[@OtherLevels]

Glad you liked it!

[@francble5845]

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

[@OtherLevels]

Merci chérie, nous apprécions cela

[@IzzyQuil]

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

[@didbdjdjdbSibdej]

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

[@lucasmontenario935]

this is pure gold

[@justfunn9139]

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

[@OtherLevels]

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

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

[@nelsonachoka7918]

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

[@OtherLevels]

Working on it ,Thanks Nelson

[@ahmedkhalil9965]

Mshallah, such a professional dashboard

[@garudaentertaintment7375]

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

[@OtherLevels]

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: kzbin.info/door/uDF09RGFE3V3lY77Z_cA9gjoin

[@shivamfinace]

You're a genius

[@OtherLevels]

Thank you very much

[@EL_BasiounY]

You're Genius !

[@OtherLevels]

Thank you very much

[@blakewood4756]

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

[@OtherLevels]

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

[@aniket.kumarr]

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]

Same for me 🤣🤣

[@bahadirkzlkaya]

wow awsome.. good job bro...

[@OtherLevels]

Thank you very much bro

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

[@giovannicordella7733]

Amazing, nice job!

[@OtherLevels]

Thank you very much GIovanni

[@jihanramadhanidaulay10098]

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

[@ifeanyioji6964]

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

[@adhikapandji8569]

Great jobs frienddd!!, Do you have template for this Design Dashboard?

[@OtherLevels]

Thanks dear, please visit our website www.other-levels.com

[@nguemalebizulrich9496]

Excellent ! Je suis très impressionné. Bravo

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

[@lephuc1986]

Thank you for your video, it's amazing!

[@OtherLevels]

Thank you Le...Enjoy

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

[@wah866sky7]

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

[@OtherLevels]

Microsoft 365 dear

[@DrDonBoo815]

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

[@cahyadi2017]

Tidak bisa berkata kata sungguh hebat

[@OtherLevels]

Terima kasih banyak Aisyah

[@godfreymusyimi9025]

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]

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]

@@OtherLevels Thanks alot

[@manwendersingh5749]

Wonderful work buddy!

[@Kiran.KillStreak]

nice work.

[@OtherLevels]

Thanks!

[@golaphosain]

awesome video. need Bangla subtitles

[@CLHLC]

'Porttitor congue massa. Fusce posuere' my condoleances man...

[@peterkariuki5140]

Wow...this is sooooo awesome

[@OtherLevels]

Thank you peter 😍

[@joukenienhuis6888]

Looks great, but it is hard to follow without sound

[@OtherLevels]

Thanks, soon we will publish new version with voice over

[@wizerdcloe]

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

[@AhmedSaber-t9f]

Great ! but how can i install thoes symbols

[@OtherLevels]

Please visit our website www.other-levels.com

[@rtrkings1173]

Great work 💐

[@fiesto11]

Very Good Channel!!

[@OtherLevels]

Most Welcome bro

[@beysikbookkeeping4333]

I need this one in my business.

[@OtherLevels]

Please visit our website www.other-levels.com

[@etekumoses3320]

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

[@nigelokeeffe6461]

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

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

[@Ashkanani7]

Wow I have learned so much from this one video

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

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

[@Crossfire-fd8gy]

Another side of Excel:) It's a Magic?)

[@akashbiswas4896]

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

[@OtherLevels]

Many many thanks

[@brightagbenuvor2880]

Intuitive videos. Keep it up Snr