Dashboard Step by Step | How to Build Interactive Excel Dashboard | Beginners Guide Mini Dashboard

Learn how to create an interactive Excel dashboard from scratch using the built in Excel tools.
If you want to get serious about dashboards development and want a blooming career ahead I recommend you take a bit of time and learn step by step from scratch.
Download the Assignment Master Practice Folder here (All Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#dashboard#exceldashboard#Innozant #dashboardtutorial

[@BharatiyaFirstThanHinduMuslim]

I don't know why your channel is so underrated. This channel needs more likes and followers. sir bahut accha content h aapke channel ka.

[@bhaktivedios-g9t]

Same thought

[@deepakpathani7355]

Jo process aapke pass h sikhane ka , wo kisi k pass nhi. Awesome

[@aditiverma2452]

I have recommended your channel many of my friends. They found very useful and said thanks to me. fortunately, I found your channel, cant say enough thanks to you. You are great sir.

[@Innozant]

Thanks Aditi.Really means a lot to me. Have a wonderful career ahead.. Thanks for your love and support dear❤️

[@shilpabidi6253]

Thank you for the content. Your approach is very simple and easy to understand. I highly recommend your channel.

[@Innozant]

Thanks Shilpa..Keep learning

[@tariqhussain1497]

Good afternoon, you have the very best way to demonstrate and giving the examples as per the requirement. best of luck

[@Innozant]

Thanks.Keeo learning

[@amd1187]

Excellent content and excellent teacher... Hatts off to you and your way of teaching.. I am blessed to got teacher like you in KZbin... Thankyou so much sir..

[@mushutube83]

Ur Great Sir.....!

[@Snehamoy_Roy]

Ap mere one of most gurudeb ❤

[@awanishanurag1763]

The absoluteness you have achieved in Excel is amazing!

[@Innozant]

Thanks

[@artiverma5122]

Sir m apkey hr vedio ko bhut like krti hu, apka andaaj hi nirala h, hm jese people jo study k liye pesa nhi kharch sktey ap brdaan se km nhi, yha log apno ki help nhi krtey ap anjaan logo ki kr rhey, god apko hmesha khus rakhey apkey hr spney ko pura krey, god bess you

[@Innozant]

Aapka Bhi Dil Se Sukriya Arti,Achese padhiye ,apni skills improve kijiye aur jab apko lage ki ab prepare ho gye ho interview dene ke liye to contact karna aap apna cv Send karna,Main sure job me bhi help karunga aapki

[@artiverma5122]

@@Innozant cv kha send kru sir

[@artiverma5122]

@@Innozant thanks so much for help me

[@shahzadsami5613]

@ 10:15 SORRY =>>> Its our moral responsibility to Like, Share & Subscribe so guys please do it, Great Videos from Great & Enthusiastic Teacher, THANKS

[@Innozant]

Thanks Sami sahab for your love and support.❤❤🙏🙏

[@vivekpnice]

I have search for excel video from years but this is the easiest to understand. Good thing is the short video with simple language please keep this good work

[@Innozant]

Thanks Vivek..God bless You dear...Happy Learning ♥️♥️

[@sandeepaswal8944]

सर मैंने आपके वीडियो से बहुत कुछ सीखा है। जिस तरह से आपने सब कुछ समझाया वह वास्तव में दिलचस्प है। बहुत अच्छा काम सर जी! इस वीडियो को बनाने के लिए समय निकालने के लिए बहुत-बहुत धन्यवाद। मैं आपके और वीडियो देखने के लिए उत्सुक हूं।

[@Innozant]

धन्यवाद संदीप जी ,और सीखने के प्रति आपकी उत्सुकता बताता है जिंदगी में जरूर आप सफलता के नयी उचाईयों को प्राप्त करेंगे

[@viratclasses4400]

Sir by the way! more videos are available in youtube, then also, I am learning something new in Excel because of you....... You are teaching very well. you are good teacher........sir ap bolo to 2lakh subscribe krwa du kya dusro ke phone chhin chhin kr😀😀😀😀

[@Innozant]

Omg...Love You dear♥️❤️🙏apke ye word hi mere liye 2 lakh subscriber Ka gift hai..Dear Kisi se mobile cheen ke subscribe karane se jyada Acha Hoga na ki unhe khud ehsaas ho ek din ki ye mere life ko change Karne wala channel hai aur wo khud juden wo Acha Hoga na♥️♥️❤️❤️🙏🙏

[@shahzadsiddiqui5117]

You are a gem...! Now I understand how my manager prepared the dynamic KPI dashboard (Risk & Opportunities, progress, contingency. I am still at beginning level of preparing dashboard with you, coz the dashboard he prepared is so complicated that I will not understand all the things so quickly. But yes after your videos I am gaining confidence.

[@muhammadasif-gw2kc]

Amazing Dashboard. You are doing a good job. 👏

[@Innozant]

Thanks dear

[@ashishmogha5502]

your way of teaching is excellent, amazing

[@muhammadnoman1608]

Sir Your Tutorial are very very easy method and easy way :)

[@Innozant]

Thanks dear

[@RamSingh-ol5xz]

Aap bahut bhahut ache hai or apka video BAHUT best hai duwa karuga aap Ka ek din apka channel no 1 rahe

[@Innozant]

Thanks for best wishes

[@sujatakumari4830]

Awesome sir ji apki sari video bhut useful hoti hai.

[@sivaramakrishnamittapalli8689]

I created my 1st dashboard, feeling excited, thank you for upload this video...

[@Innozant]

Thats Great..keep it up👍❤️❤️

[@SVS609]

Sir Your video Classes helped me a lot. What ever I learned from u r Video Classes, I implemented at my work n customized as per my org Requirement. I Received Appreciation from my Team n Manager. Am Thank ful to u for that Sir. Not only learnt this Topic but also learnt how can we modify formula as per our Requirement. Nice Explanation. Great thing is that, you teach us from Scratch. 🙏🙏🙏🙏🙏

[@Innozant]

Thanks.. Really means a lot to me..keep learning

[@PradeepKumar-hd1ty]

Sir, मे आपको कह कर नहीं बात सकता हू की जब भी मे आपकी videos देखता हू तो कितना inspire होता ! हर videos कुछ नया सिखने को मिलता है ! 🙏🙏🙏🙏🙏🙏

[@Innozant]

प्रदीप जी ,और आपलोग हैं मेरे मोटिवेशन की वजह

[@PradeepKumar-hd1ty]

🙏🙏🙏

[@upendrakumarsingh6543]

Very good teaching

[@raghavanvs2654]

JI, You are highly a blessed guy; Mother Saraswati 's Krupa is showering on you! . keep it up. Raghavan vs, Chennai

[@Innozant]

Thanks Raghavan sahab for your valuable appreciation, Really means a lot to me dear..keep learning..keep exploring ❤️

[@Funnyment1990]

Very nice content. I like ur attitude sir

[@AnupKumar-oe2jb]

Thank you sir, sikhne ko bahut kuchh milta h apke video se

[@Innozant]

Thanks Anup,Seekhte rahiye aur apni skills ko upgrade karte rhiye

[@muktobihongosanjitchakrabo8811]

Really very informative ❤

[@mackrishh13]

Your teaching awesome 👍

[@Innozant]

Thanks Mashesh Ji..Keep Learning ❤️

[@moodkn]

Great.... Help Ful Tips... Thanks..!..

[@tayyabyarkhan1048]

Love From Pakistan.. You are a champ Sir...!!!!!!:)

[@Innozant]

Thanks dear❤️❤️🙏Happy Learning

[@RahulChauhan-ll9pu]

Ultimate teaching.

[@Innozant]

Thanks Rahul Ji,Hope you learn from our video

[@umeshpant3920]

Best teaching method Sir, Salute to you!

[@pramodmishra2680]

Very nice teaching syle

[@Kuldeepsharma-lq6qo]

Thankyu soo much sir❤❤❤

[@hiteshchourey9730]

Sirji, aap ke video bahut aavha lagte hai.

[@saitinudesai]

Really Super Knowledge we gain. Thank you.

[@superstarmaheshbabu3325]

I have recommended the channel.. interesting.

[@UTPALBHAKAT-mu5nt]

Nice explanation

[@Mukeshkumar-cz4yl]

Sir I watched almost every videos.

[@Innozant]

Thanks Mukesh Ji

[@sawaimalhi8439]

love you sir 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😘😘

[@Innozant]

Thanks Dear

[@sawaimalhi8439]

@@Innozant Namste sir iam old scricber of your channel you are great in excel Tell me please sir I am learning intermediate excel without VBA many smal And Large function learnt like Logical function Text function Date function Stasactical function Lookup function Etc Samal task can be handled But until not created a Dashboard's using excel In my daily office routine not use many functions At the after few week's I forget all functions and fourmaulas Which can't use in my routine work .. So please tell me sir what I can Do those function and formulas Which remembered in my hand practice how to become good analytical skill mind Wait for your positive response Thanks in advanced

[@girishjames]

You are simply adding values to others by your knowledge which I could see in your every video.. It's amazing👍👍.. Please do your best since people like you are rare to find.. You are doing an amazing task..

[@Innozant]

Thanks Giri sahab for your valuable comment.. Really means a lot to me.🙏❤️❤️

[@girishjames]

@@Innozant Thank you sir.. Need to learn more off about offset index and match since all are your favorite functions.. 🙏🙏🙏

[@monikamanchanda1626]

Beautiful explain ation

[@Innozant]

Thanks Monika...❤️Have a wonderful career ahead ♥️

[@javedpathan4088]

Amazing video sir

[@NirajKumar-ie9xc]

Thanks sir

[@prashantkumaryadav7137]

very nice knowledgeable video

[@Innozant]

Thanks

[@pandharinathjoshi6565]

Sir, every video and ur teaching very well sir...🙏

[@koushik4484]

Great Presentation. 🙏🏻

[@Innozant]

Thank you!

[@RMKserve]

Amazing super. Every video increases my knowledge and confidence ❤️❤️❤️♥️🇵🇰

[@Innozant]

Thanks Rizwan

[@arijeetkumarsharma226]

You Amazing Guruji.

[@Harsh-jb3hl]

Thank you

[@karankapoor200]

ara sir Marco KO to apki video ka hi intjar karta hu sir or ma all user sir ka channel KO subscribe kardigya plaeas all friend 🙏🙏 is video like or share kara pleas sir pdana 100%data h apna please like share to apa Karhi sakta h🙏👍🏻👌🏻

[@Innozant]

Thanks Karan

[@MuhammadKamran12345]

Good bro...❤

[@solehashaikh5749]

Amazing Learning Sir Ji :) Thank You so much

[@aishwaryaambasta7013]

On small data very useful function...

[@Innozant]

Thanks Aishwarya

[@yogeshbokade8680]

Nice video & ur gidencs also. I'm already subscribe sir.

[@yogeshbokade8680]

Sir i need report almost 200 branches sale daily basis with drop down list & chart . So Plz make video & gidence me.

[@Innozant]

♥️👍

[@samarahmad4784]

Aap best hai Sir

[@Innozant]

Thanks Samar

[@sateeshchauhan5479]

So Nice

[@praveshkumarroy2327]

Thank you so much sir

[@Innozant]

Thanks Pravesh Ji

[@abhishekpunia8838]

Helpful video sir ,keep it up.

[@Innozant]

Thank You Abhisehk Ji,Keep watching,Learn and Share.

[@kinghundred]

very nice sir

[@dharmendragosai2630]

Sir apple video se me bahut kuch sikh Raha hu namaskar sirji

[@epocholympiadfoundation8063]

Hello Sir This is such a great experience to see your interesting contents in very easy way. I really enjoy and learn at the same time. 🙏

[@Innozant]

Thanks dear...Happy learning 🙏❤️

[@meditationmusic6482]

Sir.ji so good video 📷

[@Innozant]

Thanks dear..

[@artiverma5122]

Too beautiful sor

[@Innozant]

Thanks Arti

[@jaitiwari241]

nicely explain sir

[@Innozant]

Thanks Jai

[@kmanoj392]

Good sirji

[@mohammadilyas2240]

زبردست excellent

[@Innozant]

Thanks ❤️

[@sonukumar-xp5sd]

Awesome

[@ChandanKumar-gp8zw]

thanks

[@vaibhavsingh2304]

Amazing work👌👌👌👌

[@Innozant]

Thanks Vaibhav

[@eakiran6679]

Thanks is not enough to let u know how much u add value in my professional life. Can u share video Visual Basic in excel so all my void of excel will be filled.

[@Innozant]

Thanks Kiran ..You may able to watch VBA videos soon dear..m planning to launch it soon

[@amitapattanaik1071]

Lovely

[@Jackieee0]

Sir formulla lagane ke bad aap kiya shortcut key press karte ho jo sabhi row me data ate hai

[@gauravbanerjee7891]

sir, one more subscriber added, awesome teacher, excel ki pura gyan sir le pass lo.

[@Innozant]

Thanks Gaurav Ji.. Happy Learning dear❤️🙏

[@battlefansshorts8941]

Thank you sir ❤🌹😊

[@Innozant]

Thanks Ravi ji

[@aakankshasrivastava9497]

You are doing gud job sir , Thank you!!

[@Innozant]

Thanks Aakanksha ,Hope you start learning , Recommend you to download Example Worksheet available in Description,You may find all Playlist Example workbook at one place.

[@aakankshasrivastava9497]

@@Innozant yes sir I m learning a lot from your Excel videos..after that I want to learn VBA n SQL so plz guide me.i love d way u explain each n everything regarding ol d topics.n thank u for motivating us..

[@Innozant]

First complete Advanced Excel then proceed with SQl followed by VBA and one Data visualization tool either Tableau or Power BI. Suggested -Powet BI.Whenever you are in doubt while choosing career option feel free to Whatsapp/Call me-7065069985

[@aakankshasrivastava9497]

@@Innozant sure 👍Thank u

[@rakeshranjan7525]

Very nice

[@Innozant]

Thanks Rakesh Ji

[@rakeshranjan7525]

@@Innozant welcome sir

[@gopinathg2812]

sir ur teaching is awesome. i need videos on full vga macros.

[@Innozant]

Thanks dear...Sure you may able to learn VBA and Power BI soon❤️

[@deepakbahuguna4312]

sir you added my skills in my resume

[@Innozant]

didn't get your query

[@Radhe.mahant2010]

Bhai mst video banate ho

[@Innozant]

Thanks dear

[@ashishkumaryadav7899]

Thanku sir

[@FarhanAli-En7]

Such a great experience, Sir how can I find complete series of dashboard from 1st video to last step by step

[@Innozant]

Seprate dashboard playlist is there

[@radhikumar327]

Verynice sir

[@Innozant]

Thanks

[@EmDiAverageGamer]

Sir yeh column wale k jagah match bhi kar sakte the na with headers to get the column number??

[@Innozant]

Yes..You mis to attempt it

[@ajay306]

Thnq

[@johndas8173]

Sir salary sheet video banao hr level ka basic to advanced level se and dynamic ek ek rule defination ke saath

[@improvemyself7543]

Great sir I have a Question about Cell Refrensing in Dynemic chart .what if when we Remove Cell Refrensing you used in create table name Dynemic .Is it Possible Without cell Refrensing .

[@artiverma5122]

Kya ismey vlookup ki jgh xlookup use kr sktey hai sir

[@Innozant]

Wo aur acha apply hoga..yes we can

[@chandrashekharmishra9521]

Thanx

[@Innozant]

Thanks dear

[@rishabhjaiswal4259]

muhje koi batye ga ki jab sir nae max min formula use kiya to suzuki ki jan sale mae different ho gai tab to ye galat ho gya na.

[@Innozant]

Randbetween use Kiya hoga function to value refresh hone par alag aaya hota

[@rishabhjaiswal4259]

@@Innozant mae samhja nhi vlookup lgaya tab exact data ayya but jaise max min lga to vo change so chart bhi galat le ga video mae aap dehkiye sir

[@chandandatta6446]

Nice

[@Innozant]

❤️🙏

[@ajay306]

Thqq

[@deputydirector881]

nice

[@syedyaseen7940]

I need some information regarding charts and dashboard will you plz help me to get it done

[@Innozant]

Kindly ask your query

[@syedyaseen7940]

@@Innozant i want to prepare a report for presentation can you help me to create one

[@mohmmedfaisal1061]

Sir please suggest k agar online class laeni ho aap sae toh

[@Innozant]

Hi Fiza Aap Innozant ke contact no par whatsapp/call karke 3rd Jan se new batch start ho rha hai uska detail leke joj. Kar sakte hain

[@dineshkargeti4225]

Great air

[@gauravbhatia7987]

Good

[@Innozant]

Thanks Gaurav Ji🙏♥️

[@localarts5095]

Sir Vlookup ke jagha index match functions nhi le sakte ?

[@Innozant]

Kyu nhi le skte hain

[@bhoopendraraghav9781]

unique content

[@Innozant]

Thanks Bhoopendra Ji,

[@bhoopendraraghav9781]

@@Innozant you are great sir welcome sir