Dashboard Step by Step | How to Build Interactive Excel Dashboard Cont...

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

[@eakiran6679]

Thanks to share video . All though I was appreciated for my excel skill but you teach me clear all my doubts and make me more confident. Request you to make more video in comparison with Excel and Google sheet in tandem . Rest personally i like your dressing sense...especially T-Shirt. and you are very handsome . Hope I will not miss even a single video of you. I am your fan.

[@Innozant]

Thanks Kiran for your compliment you really made my day! Seems like you are a new member of Innozant family. I hope that here, you will get enough content to satisfy your needs and upgrade your skills.

[@nehajoshi8780]

Thankyou Sir.....No words, totally speechless.....Great sir,great teaching...🙏

[@KhanKhan-xo9tb]

really good video sir.

[@nmbspltd5766]

I have no new words to appreciate your teaching skills as everyone else has already appreciated so much in the comments. Still i would like to mention that you are too good and gifted with excellent presentation skills. I will continue to go through every single video of yours.

[@Innozant]

Thanks dear... Really means a lot.Keep Learning ❤️

[@powerbiselfstudyguide]

I found best excel course on KZbin. Keep it up!

[@Innozant]

Thanks dear..Keep Learning ❤️

[@Meditation5235]

We can learn something new from your each vedio of excel in a very easy and precise way...please keep continue. Thanks a lot sir!!!

[@Innozant]

Thanks Saurabh ji❤🙏🙏

[@sahilkazi6613]

@@Innozant SQL N MIS relation

[@riddhishah9574]

Very nice. Agar aapki video sequence me dekh li to koi paid excel course ki jarurat hi nhi hai Thanks for educating ppl for free of cost

[@Innozant]

Thanks Riddhi...God bless you .Keep learning..Keep exploring ❤️👍 have a wonderful career ahead

[@artiverma5122]

Hr kaam perfect hota h apka, apko dekh kr pta lgta h, hme to kaafi kn knowledge h abhi🙏👌

[@Innozant]

Thanks Arti itna trust ke liye and for appreciation.

[@hardiksinghal4924]

My god sir, You are simply amazing... I love learning these things from you

[@Innozant]

Thanks Hardik

[@aishwaryaambasta7013]

Soo easy to learn with this ....and the most easy too understand.. amazing sir

[@Innozant]

Thanks Dear for such a valuable feedback,It's really mean a lot to me.

[@dharmendrasagar9260]

Aap bahut easily samjhate ho superb sir..

[@Innozant]

Thanks Dharmendra Ji.. Happy Learning dear..🙏❤️

[@jk4999]

Sir, you are simply amazing, how easily you have made this excel learning fun, I bet no one would ever find learning excel more interesting than learning it on your channel..

[@Innozant]

Thanks JK . Really means a lot that me .God bless You dear❤️👍

[@JyotiKumari-th7wy]

@@Innozant sir, i am able to select both objects in same time

[@muhammadasif-gw2kc]

Very good teaching skill Sir, it will be really helpful. 👏

[@karankapoor200]

wonderful video sir apka jassa Koi nhi sir 👌🏻👍🏻👍🏻

[@Innozant]

Thanks Karan Kapoor Ji,Keep learning dear.

[@ramakrishnab6986]

Sir,as I'm new to your channel🧐 🤔but the way of your explanation is awesome👌 🤗a big salute 🫡deserves you ❤💐

[@Innozant]

Thanks dear..Keep learning ❤️

[@sandeepaswal8944]

Sir All your videos are really helpful. You explain each and every thing in great depth.

[@Innozant]

Thanks Sandeep Ji,May it bring value to your life.

[@priyankachourasiya9712]

Sir amazing explain thanks 🙏🏻 for sharing the wonderful 😊 knowledge ❤️

[@Innozant]

Thanks Priyanka..Means a lot to me..ajeeb exploring ❤️

[@harivanshgautam3424]

Sir, you are really a good teacher. You know very well what questions will come in learners mind. Nice 🙏

[@Innozant]

Thanks Harivansh,Hope you understand and learn the concept I am trying to deliver.

[@harivanshgautam3424]

@@Innozant Yes Sir, Your every video is easy to understand.

[@siddharthsatbhadre]

Very explanatory ... thank you sir..🙏🙏🙏😊

[@Innozant]

Thanks Siddharth ji

[@nits1180]

Dear Sir. Thanks very much...though im late in getting your videos but its very informative .i have been looking for many doubts of mine for a very long time...great teaching skills...

[@Innozant]

Thanks Nitin Ji..Happy Learning. We welcome you to experience the taste of succes with Innozant Seed of Success

[@umerkayani79]

Thanks Sir May you b happy all the time..Ameen

[@laxmichaurasiya9949]

Sir, you learn things very easily, so thank you. 🙏🙏🙏

[@Innozant]

Thanks Laxmi for wonderful feedback and you are able to learn concept very easily through the video.It really motivates me a lot.

[@umeshpant3920]

Very nice Sir. Thanks a lot..

[@Jitenderkumar-yp1rn]

Sir mai to fan ho gaya aapka.....😀

[@Innozant]

Thanks Jitendra for a wonderful feedback.its my pleasure dear..Khush rahiye..seekhiye aur aage badhiye life me

[@virendersroha1754]

Nice basic dashboard k leye achi h vedio

[@Innozant]

Thanks virendra,step by step bus seekhte rehna h.

[@Washaista]

Thank you sir.... Appreciate your work

[@Innozant]

Thanks dear❤️

[@dubeypushpendra4558]

Awesome video Sir

[@musclefscts]

11:15, tum tum na rhe... 😂 Sir I really like ur teaching style

[@Innozant]

Hahahaha..😀Thanks Amit ji .Love u dear..God bless You

[@charulatanijai9485]

Very good video Sir

[@DEEPAKMISHRA-km9uu]

Thank you sir 😊😊

[@Sarangkulkarni2711]

very nice explaination.thanks

[@Innozant]

Thanks Sarang Ji❤️🙏Happy Learning dear

[@bhoopendraraghav9781]

Sir I can understand easily so thankyou very much

[@Innozant]

Thank you Bhoopendra ji.Keep learning.

[@ajayshukla6365]

What a great video

[@bhaveshrawat1364]

well explained!!

[@makeshn9813]

Super Guruji. Please also teach how to present the same to the power point to show much more beautiful

[@Innozant]

Thanks Makesh sahab..happy learning

[@K-Starreaction]

Superb sir

[@shahzadsiddiqui5117]

Ati-Sundar...!

[@iqbalahamedkg]

Hi friend, I want to understand whether I can combine Multiple comparative sheet into single comparative wherein I can refer different department in one

[@swagatnayak1399]

Thank you so much 🥰

[@Innozant]

Thanks ❤️

[@yogeshpimple2860]

Awesome Thank you

[@Innozant]

Thanks dear

[@shaileshkumar-qf6bd]

shukriya guru ji❤

[@VikramKumar-du2mw]

Must sir 👌👌👌

[@kinghundred]

very nice sir

[@vv9730]

linked pic 8:45...how to move this to different sheet..??? , example when source data & dashboards are kept on different sheets...

[@artiverma5122]

Mashaallah 🙏 mai badia or badia bnana chahti hu

[@Innozant]

Mashaallah 🤣♥️♥️♥️

[@samarahmad4784]

Sir hum log UNIQUE function ka use kr k bhi unique value nikal skte hai na!!!

[@aalokchauhan1333]

Sir aap ye 2 object ek sth Kay select krte ho grouping k liye plzz btao naa

[@norberthodges3138]

Nice video sir

[@Innozant]

Thanks dear ❤️

[@sunilsinha202]

Thank You

[@Innozant]

Thanks dear

[@sunilsinha202]

You made me think that I can learn it. I had left it earlier... So, I shall be with you.

[@Innozant]

Thanks..Thats good .Keep it up

[@user-ik8jp1tt4o]

you are really nice bro

[@Innozant]

THANKS..keep learning

[@sparkingbulls..1847]

sir how to drag a row completly without using mouse

[@Innozant]

Using F2 And Ctrl key

[@arabindasamantra8528]

Very useful

[@Innozant]

Thanks dear Arabinda🙏🙏🙏❤️❤️

[@Manojyadavdipl]

Thank🙏

[@Innozant]

Thanks Manoj

[@akashkumar-oi1fw]

sir mera iterview hua tha or maine practice qustion to solve kar diya tha but theorical question aise the jo thore hatke the v looup kiya hai ager iss type ke hote to bhi koi problem nahi matlab 20 question the optional type ke ek test liye or bola ki tick karte jao ager iss type ke qustion bhi aap series mai dal do to sir phir to therical qustion mai bhi pakka ho jaunga

[@Innozant]

optional question ke series already hain..quiz Sunday Playlist

[@OpPhilo03]

Sir, maja aa gaya apaki ye video dekhkar. Sir, Kaya aisa koi tareeka nahi hai jisase ham Uniqe value ki Drop down list ko bana sake vo bhi Bina Kisi Duplicate value ko remove kiye. Mera matlab hai ki ham drop down list banane ke liye pahale poore data se jisaki drop down list banani hoti hai usako copy karate hai then Usako Kisi place par paste karate hai then vaha par duplicate value ko delete karate hai then Drop down list banate hai. Isame ek problem ye aati hai ki Hame Unique value ki ek alag column ya row banani parati hai.

[@Innozant]

Thanks dear..Aapke life me.value add ho raha hai..acha laga aapse ye baat sunke.keep learning 👍❤️

[@Snehamoy_Roy]

Sir I love you

[@kamalnarayansahu886]

Sir freeze Karne ke liye Kon sa shortcut key use karte ho... Please bataiye

[@Innozant]

F4

[@surbhiverma275]

Combo list bhi group krna chhaiye tha na so that easy rhe jb hum is pure group ko dashboard pr paste kre to.....

[@Innozant]

Good Morning Surbhi,Ye basic custom Grouping example hai isliye combo box ko group nhi kiye,Aage Dashboard videos me apko dekhne ko milega🙂❤️🙏 Thanks . Happy Learning 🙏

[@surbhiverma275]

@@Innozant gd mrg sir 🙏 thank you

[@Innozant]

Step by step seekhiye aur koi bhi kbhi issue Aaye to aap Telegram/Whatsapp Kar sakte hain..Wil guide you. Happy Learning ❤️🙏

[@dharmendrasagar9260]

Sir ji aap ek video industrial excel par bhi banao bilkul shruaat se..

[@Innozant]

Haan Dharmendra Ji pehle concept wale topic finish kar Lete Hain phir Jaise aplogon ki requirement hogi will make video .. Thanks for suggestions.🙏❤️👍

[@PrateekGoyal013]

is example m combo box kyu nhi use kia

[@battlefansshorts8941]

Thanks sir ❤

[@Innozant]

Thanks Ravi

[@chandrashekharbhosle65]

How to connect to chart in dynamic?

[@Innozant]

What iutput youal are expecting now

[@GaneshJKoli]

Sir unable to get total count through countifs but its works with sumifs

[@Innozant]

Why .? With countif you may able to do the same

[@GaneshJKoli]

Sir through countif it counts only number of products and u have not selected the range of values for outcome

[@phgroup2004]

sir pivot ki picture cut karke second sheet me le ja raha hu to font clear nhi aa raha h

[@sawaimalhi8439]

very nice sir . kafi best concept diya hai aaap nay maine udemy m paid courese liye hain par itna acha aaap say samaj main aya hai please muje suggested krin muje excel dasboard expertise k liye muje kiya kiya krna chaye muje sahi say path samj nhe ah rha hai baisc and advance k udemy k courses kr rha hoon ...par mera concept tu clear kafi ho jata hai par chezoon ko analysis krne m msla ho rha hai ,,,,aaap bahot slow slow best chezain samajate hain so plz guide krin muje b ,,,meri sawal say kafi logon ko fayda hoga

[@Innozant]

Sawai sahab conceptual part sahi kijiye formulas ka..conditional formatting ,dashboard aur chart acha kijiye ,jyada se jyada example attempt karne ki koshish kiya kijiye usse dheere dheere aapko analizw karna aa jayega kis situtation me kya usw krenge ..

[@sawaimalhi8439]

@@Innozant thanks so much sir main doubra aaap ki basic playlist start ki hai bahot acha lag rha hai ...apni baki doston ko share krunga aaap k chaneel ko malik aaaap ko kuhsh rkhe 1:basic formule 2:vlookup, hlookup, if conditon ,conutsif sumifs , chart , piovt table, sirf ye zruri hai dashboard k liye ya phir macros and vba b lazmi hai ??? muje abi tak confusion hai sir

[@kosar52]

There should be sumifs instead of counifs.... M I correct sir...

[@Innozant]

Wheet dear?

[@pawanwakale8801]

Sir yeh last me Grouping kaise kiya uska thoda samjha nhi, Kaise kiya isme two objects join

[@Innozant]

Again repeat kren ek baar video aayega samajh

[@Meditation5235]

i think there should be Sumifs instead of Countifs, as we need to sum all ranges and not count..

[@GaneshJKoli]

Yes

[@TanuSid-xk3ue]

Haan wahi to countif se bus count kar raha hain sum to aa nhi raha

[@ARHAM559]

Mera to Total nahi lag raha

[@shrikantsahu2085]

Hi sir Good Morning muzhe pura excel sikhna hai app ek video banahiyei jisamei pura excel ka course ho

[@Innozant]

Good Morning dear, Complete excel hi karaya gya hai dear playlist wise. Aap announcement playlist me jaake ek video hai mis learning process use dekhiye ki kaise seekhna hai step by step Ya video description me bhi link diya gya hai videos in sequence playlist. Happy learning

[@shashankku.1469]

Sir.. do you also take SQL classes...If yes, please let me know i can connect with you..Thanks in advance

[@Innozant]

Yes we are running SQL Classes,You may connect us for more information

[@shashankku.1469]

@@Innozant please let me know if there is any contact number?

[@yogendrathapliyal1333]

pls explain also when u do..its very confusing....

[@RohitKumar-pi5gb]

Sir ye dashboard wali series se pahle chart series dekh lu kya kyuki chart nhi aata hai

[@Innozant]

Pehle chart phir dashboard pe move kren

[@RohitKumar-pi5gb]

@@Innozant ok sir

[@sumannath2057]

Respected sir.. Kya mujhe Chart and Dash Board ka alag se pura learnig video mil sakta he....if possible please share me.. This is very urgent sir.. Thank you..

[@Innozant]

Dashboard series is there

[@AnupKumar-oe2jb]

Sir dashboard ka video banate rahiye plz

[@Innozant]

Haan aayega dashboard video series

[@sandipsingh8377]

How to copy paste this dashboard from excel to email? Pls help

[@Innozant]

There is no need to copy paste .link collaboration kr skte h

[@issac557]

Sir how did you select these two data while doing grouping.. I can only select one

[@Innozant]

With ctrl key

[@varya51]

Sir practice file download nhi ye wali vedio ki

[@Innozant]

Direct link diyabhyabhai practice file ka..open for download

[@gauravbhatia7987]

Sahi hai

[@Innozant]

🙏🙂♥️

[@DEEPAKMISHRA-km9uu]

Sir dashboard practice k liye Excel files kaha se milegi

[@Innozant]

Video description me link hai download kar lijiye

[@RanjanJoshi1952]

इस फार्मुले में कालम B काउन्ट कर रहा जबकि काउन्ट कालम C करवाना है , कृपया समस्या का निराकरण कीजिए।

[@asimbhai7497]

Sir practice file download nahi hi rahi

[@Innozant]

Master assignment folder jo 2nd link hai wahan se download kar lijiye

[@awanishanurag1763]

❤

[@TulsiKumari-my1dz]

Sir data itna chota h kuch dhikhaye nhi de raha

[@Sonu-yq6cq]

Mangya sir g aap ko

[@Innozant]

Thanks Sonu🙏❤️

[@ARHAM559]

Sir Total thek Nahi Aaa raha COUNTIFS ka

[@Innozant]

??

[@Maayu_Vijay]

Sir grouping nahi ho rahi he group open nahi ho raha he

[@Innozant]

Kaunsa version hai aapka office..issue hona ni chaiye

[@RahulRoy-po9ct]

🙏

[@deepaktyagi9717]

Ye data Noorain Sir ka hai

[@pramodsingh4236]

🙏🙏🙏🙏🙏🙏🙏🙏

[@vv9730]

4:40 anap shanap chart banate ho...🤣🤣🤣🤣🤣🤣

[@Innozant]

😊

[@tarjitmalka3978]

🌟🌟🌟🌟🌟

[@arsalanaamir9925]

AAP KI VIDEO QUALITY BOHAT BILLER YA KHARAB HY

[@Innozant]

Koi issue nahi hai video me .check again dear