KPI DASHBOARD in Excel-Part 1 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi

[@ankitshukla4322]

I have seen a lot of videos on dashboard making but first time writting somewhere that it was really nice way to teach it was very easy to understand and learn something new and different from this video rather then other videos on the youtube.. Great learning experience

[@uniquemobiletipstricks7714]

Ankit भाई कैसे हो

[@chinmoy48]

In today's world of money-makers and scammers scamming people in the name of educating in You-Tube, you are the best and most humble tutor sir providing free quality education in you-tube

[@Innozant]

Thanks dear.Really means a lot to me..

[@rupeshjambhale5289]

Hats Off to you Sir..!!! 😊 You are really a Very Good Teacher!! May Ganpati Bappa Bless You. Thank you so much for sharing this kind of great knowledge with all of us. Waiting for more such kind of interesting videos.. 🙏🙏😊😊

[@Innozant]

Thanks Rupesh..Keep learning ..keep exploring ❤️

[@PunesCreativeCouple]

Now a days where money-makers and scammers scamming people in the name of education on You-Tube, you are the best and most humble tutor sir providing free but quality education. Hats off to you Sir ji.

[@Innozant]

Thanks..Really means a lot to me dear..Keep Learning

[@1gopalakrishnarao]

Excellent. Very good initiative taken to help the learners/users/addicts. Thank you.

[@Innozant]

Thanks Gopala Sir,Hope you like the koi dashboard step by step process.🙏❤️

[@nitishpradhan7375]

what can we say..😌😌 U may know lot ...but U don't know that U R a really really a best sir.... no faltu talk.... direct talk on the real working problem and and the solution 👍👍 lots of love u Sir

[@Innozant]

Thanks Nitish.. Really means a lot to me 👍❤️

[@muhammadanwer1033]

Hello Boss, you are brilliant! You make learning easy and explain things very well. Thanks a lot for your time and efforts.

[@Innozant]

Thanks Anwer Sahab.. Happy learning ❤️.

[@tusharrj6578]

​@@InnozantHello sir,please help me to access the file, it's showing it doesn't exist anymore and another thing is ,the developer option is not there in our sheet ,where to get it?

[@Innozant]

@@tusharrj6578 File-options-Customize ribbon-Enable developer tab

[@Karma4Good]

कुछ नया सीखने के लिऐ में हमेशा आपके video देखा करता हु।मुजे अच्छा लगा के आप comment में पूछे गये problam का solution भी देते है ,जो बहुत अच्छी बात है।

[@Innozant]

Thanks..Koshish karte hain dear jitna possible hota hai answer dena

[@YogeshKumar-hb8zt]

I love to see your videos and try to implement in my routine , Thanks

[@Innozant]

Thanks Yogesh ji..happy learning

[@princeswapnil7868]

@@Innozant sir where to find the dataset?

[@theamark09]

Sir, aap ka koi jabab nahi hai.. Your teaching style awesome. Even no can compteate you..

[@farhanahmed3055]

Sir I want this file because when i put input range in combo box as EMP NAME that showing reference invalid

[@Innozant]

Kibdly find video description..Mis master assignment link is there

[@swapnilshukla7735]

Same is happening with me

[@sandeepaswal8944]

Sir I don't have words to speak your knowledge. You explained very well. आजतक मै सोचता था मुझे KPI बनाना कब आएगा या नहीं भी आएगा। You changed my mind today. I always learn from all your videos. May your blessings always be. Highly appreciate your work for humanity sir !

[@Innozant]

Than Sandeep,Hope you are able to understand how we proceed with making kpi dashboard step by step. Happy Learning dear.

[@vijaygurung7406]

Really sir aap ka andaaj sabse hatke hai Mene aapki jinti bhi video dekhi hai ek baar me samj me aa jaata hai

[@Innozant]

Thanks Vijay aapke valuable appreciation ke liye

[@surojitchatterjee7134]

I watch you excel tutorials. these are absolutely great. you make us understand from depth and so simply. you are a really great teacher. I do get really great experience watching your videos. please upload more important excel dashboard making videos. thanks.

[@darrylfernandes4806]

I feel that exchanging knowledge from trainers is most important this will boost our IQ and knowledge base. Thanks Innozant!

[@Innozant]

Keep learning

[@sazalsarkar2130]

Really you are the Moharaja of Excel.

[@Innozant]

Thanks Sazal sahab for your valuable appreciation ❤️

[@jkyadav77]

you are a best person in my life that taught properly

[@Innozant]

Thanks Joginder ji❤️❤️

[@rajender811]

I have watched many videos at a go in a day n for several days n learnt a lot.they are great

[@Innozant]

Thanks

[@shashankku.1469]

sir bahut badhiya se samjhaya aapne..Hats off to you..lots of love to you

[@Innozant]

Thanks Shashank Ji

[@AnkJyotishAaman]

Sir Sir Sir, Kaha hai aapke charan. bohot hi jabardast. & i can't beleive ye do saal pehle ka hai ab to kya hi chal raha hoga content.

[@maddymaddy29]

bahut acha explain kiya aapne.. simple tarike se..

[@Innozant]

Thanks dear ❤️

[@jitendradore9529]

Aap hamesha hi apna best dete ho sir ji❤❤❤

[@Innozant]

Thanks dear

[@izharulhaq6119]

Assalamualikum I'm from Pakistan. I'm really impressed your teaching style. Lot of knowledge with short time you have provided. Thanks ♥️

[@srinivasbattula1863]

Really, what an explanation . Very good face expression. Nobody gets bored. Even a child can understand. Thank u very much sir

[@Innozant]

Thanks Srinivas...Really means a lot to me..God bless you.have a wonderful career ahead 👍😊

[@samirmurali6808]

Listening to your lectures is like listening to Mukesh or Kishore songs, teaching is an art, and conveying your message clearly to your audience is very important and you have mastered both. Pranam to you Guruji

[@faizaaamir1428]

You are a good teacher.you give 100 % in the excel learning videos.

[@Innozant]

Thanks Faiza👍❤️

[@yogipalliofficial]

I am always seeing your video and and always being motivated

[@Innozant]

Thanks

[@shantilalsubhashrathod4391]

Hii sir I m MIS Executive in financial services your videos give me every time motivation and new new knowledge sir please if you have possible to make SAP video , it's very much help to every mis executive.

[@azeemhussain1109]

Suddenly I found this tutorials that exactly what I was looking 2 months back to show my team that somewhat in this way. But unable to find at that time. and thanks to YT AI algorithm to show this tutorials. many thanks to you ....'SIR'

[@Innozant]

Thanks Azeem ,Keep Learning..Keep Exploring

[@rajeshbisht7743]

Sir you are great i am learn lot from your videos.

[@Innozant]

Thanks Rajesh ji

[@puransingh-sx2tk]

Guru g aaj bahot Mood off tha thank you aap ne itne shandar topic par vedio banaya mind fresh ho gaya. 🙏 aise he or vedio phir main hero ban jaunga apne office main

[@Innozant]

Kyu Puran,Kitna bhi ups downs sabke life m aata hai..but upset mat hua kijiye kyunki har prob Ka koi na koi solution HOTA hai.. Is video ki jaroor practice khudse karna for sure. God bless you 👍🙏❤️

[@superNareshg]

Thank you so much sir, Bahot hi aasani se sikha deto ho aap explaination ke sath.

[@Innozant]

Thanks Naresh Ji Happy learning dear..God Bless you ❤️

[@superNareshg]

@@Innozant Thank sir.

[@RidaHamza914]

Form Pakistan sir bhtt zabardast video .......

[@Innozant]

Love you Dear Hamza..Really means a lot to me.

[@SureshKumar-xs2sw]

You are awesome Sir.. Never seen any teacher who teach or spread knoweledge without any expection from other . You are genuine teacher, I got a powerful and precious Gem...........

[@Innozant]

Thanks Sarvesh Ji.for your valuable appreciation dear.. Really means a lot to me..God bless your..Happy learning... Wishing you wonderful career ahead❤️

[@sushilchoudhary1328]

Hare Krishna! I was not aware of Dashboards at all. But I liked them very much as they are always helpful in presentations. I was always making just simple charts and most of the work on excel sheets only. Today just wanted to see, If I can learn them easily or not. But, I must say brother, I saw one video of yours and subscribed to your channel. Very understandable explanation. Big thank you to you bhai. Because of you, I guarantee, that I can be a master in dashboards. God bless you. Keep it up. Jai Hind.

[@Innozant]

Thanks Sushil ji. Really means a lot to me.Recommend you to start your learned journey from Playlist Basic Excel then proceed with Advanced excel ,pivot and dashboard...followed by mis Interview cracker.

[@sushilchoudhary1328]

@@Innozant you are always welcome. I Will watch all videos from scratch to understand this amazing Excel !!!!

[@rabiraul623]

Sir Your Explanation is Amazing. Thank you very much. 💛❤️💛

[@Innozant]

Thanks Ravi

[@rajchuwan]

sir , i am watching from nepal you are too good .

[@Innozant]

Thanks Raj

[@michaelosadebe6418]

Dis guy is good, I wish i understand indian language. nice one

[@Innozant]

Thanks Michael,Really means a lot to me

[@saidullabhamisra6905]

Suprb conversation brother...!!!!!

[@srinivasamurthy32]

sir thank you very much ,teaching method is excellent .

[@bichujamshi]

Very helpful one.. dear, well done

[@piyushtyagi6589]

Gazab...... thanks for your dedication.

[@Innozant]

Thanks Piyush Ji. Happp Learning dear

[@piyushtyagi6589]

@@Innozant aapke sare vedio gazab ke hai.......aap apni taraf se pura sikhane ki kosis karte hai......iske liye aapka bahut bahut dhanyevaad.

[@cpauv]

Nice use of excel formulas and other functionality. Appreciate your work.

[@dinudayasakalasooriya8163]

I don't understand Hindi, but step by step presentation is superb. To learn your excel, Hindi is not a must. Great Job.

[@Innozant]

Thanks Dinudaya for your valuable appreciation.Really means a lot.. Will upload videos with English subtitles soon

[@1gopalakrishnarao]

In very simple steps/procedures/formulas you have shown that, even an ordinary person can do the KPI DASH BOARD. Great||||||||||||. Now I have been addicted to your videos.

[@Innozant]

Thanks Sir for such a lovely appreciation.🙏

[@dilipgangurde7578]

Sir you are great...

[@Innozant]

Thanks Dilip Ji

[@shineadhikari7408]

7/01/2022 I am first here and i am happy to being with you Sir, Mujhe Na Yun Hi Kuchh sikhane mein bahut hi Maja Aata he. Isiliye turant subscribe Kar Diya.. Agar Dhyan Se Dekha Jaaye To Kuchh Kuchh chijon Mein aapane explain nahin kiya.. Jaise Mera savaliya Ki aapane sheet 2 main dashboard ka kam kya lekin sheet1 se to Koi link nahin tha na to Fir Kaise employee ka naam a Kaise Aata fast time jo aapane Kiya Hai i mean jo A1 bali.. but bahut Kuchh sikhane Ko Mila Hai Mujhe. So i just want to say thank you thank you and thank you so much👍👍👍

[@Innozant]

Dear Adhikari sahab dono videos sequence me dekhnege ti complete processs samjhaya Gaya hai KPI DASHBOARD ka step by step ki kaise banayenge..aap dubara recap Leon video complete descrbe kiya gaya hai ..bht easily bana payenge aap

[@viswanathan19]

Your explanation is clear and sequential,

[@Innozant]

Thanks Vishwanathan 😊

[@Marathiboost]

5 ad cut kiya fhir video shuru hui 🤩🤩🤩🤩🤩

[@Innozant]

Aisa kya😀❤️..👍

[@Marathiboost]

Ha Sir

[@storekeeperTips]

Really fantastic brother i very like your teaching simple way

[@Innozant]

Thanks dear..Keep Exploring 👍

[@storekeeperTips]

Sure my lovely brother 🥰❤️

[@relaxingmusic4918]

Asalamualikum Sir jee very good tutorial video. thanks

[@Innozant]

Thanks

[@chakz73]

Thank you very much my dear friend. well explained. made things easy to understand. for all the efforts you have put in thank you once again

[@ghulamullahkhan597]

What a beautiful style of teaching 😍 ❤.

[@Innozant]

Thanks dear ❤️

[@ghulamullahkhan597]

Sir we need dashboard for our wholesale food store rice. Ghee.wheat etc in excel

[@dhurjyoti]

sir 8:22 mei jab aapne slect kiya tab woh A1 soe kiya =CHOOSE ke secton mei, fir wo $A$1 mei keise convert huwa?

[@bideshghosh80]

u have vast experience about excel

[@sathyanandhamd5453]

Awesome sir jiii , m thankq full to u ..... Always

[@Innozant]

👍♥️

[@saminaazeemi7419]

Nice, interesting way to teach. Thanks a lot.

[@Innozant]

Thanks Samina..Keep learning..keep exploring ❤️

[@satishojha6240]

Choose,Max,vlookup,offset function are use in first part of dashboard thanku very much sir 🙏🙏🙏.waiting next part.Good night sir

[@Innozant]

Soon... practice jaroor karna iski.

[@SVS609]

Very much useful. Really i learnt new thing. Thank you very much sir. Can i expect like from u sir

[@Innozant]

Thanks Shekar for your valuable appreciation..Happy Learning ❤️❤️🙏

[@ArmanKhan-iq3ji]

Hii Sir I'm mis incharge I like your videos, thank you for sharing this information 👍.

[@Innozant]

Thanks Arman Sir for your valuable feedback🙏👍❤️

[@parulsrivastava3757]

These videos are really helping a lot to learn how to representthe data analysis in a beautiful format

[@Innozant]

Thanks Parul for your valuable appreciation dear❤️Happy Learning

[@ritikiiitd6649]

thankyou sir ji this video is very helpful to me

[@Innozant]

Thanks dear

[@deepakbadhgujjar1154]

Thank you sir 🙏 You are the best

[@Innozant]

Thanks Deepak Ji

[@pushpak5939]

Hi Sir, this video is very helpful for me , as I often have to make reports but after this video I can make an effective dashboard.

[@Innozant]

Thanks dear♥️👍

[@naninaidu66]

Thank you so much... It's very helpful

[@Innozant]

Thanks dear

[@Techno49]

very good, good content

[@Bobsfavourate]

Mate... watched it for the first time... very nice... learning for every aged people.. much appreciated.

[@Innozant]

Thanks Birju❤️Happy Learning dear

[@sujitkumarsinha1490]

Nice approach of teaching

[@Innozant]

Thanks Sujit Sinha Ji,We welcome you experience the taste of success with Innozant-Seed of Success 🙏♥️🙂

[@gracysinghit03]

Sir I already subscribed you and you are great

[@Innozant]

Thanks Bisht sahab

[@SaqibAli-on6hv]

You are good 👍❤

[@Innozant]

Thanks Saqib

[@cvamlifts]

Can you please share the data as the link provided in the description is invalid and the other one has a lot of data set and I am not able to find it there.

[@shonakmdheeraj7590]

As Usual great sir

[@Innozant]

Thanks dear

[@msohail1217]

amazing bro, for the first time i came to your channel watch your video, already hit like and subscribed..well done!

[@Innozant]

Thanks dear..We welcome you to experience the taste of success with Innozant Seed of Success ❤️🙏

[@learnadvanceexcelwithsuraj6015]

Nice sir, you are the best

[@Innozant]

Thanks Suraj

[@gauravjoshi3774]

Sir I want to add month name in same column but in different rows. 15:40 how to use offset formula here.

[@jatinkumar6859]

All videos are good

[@Innozant]

Thanks Jatin ji.Happy learning

[@tejpalsain1507]

Very important and helpful video for us. Thanks.

[@nishantjha8159]

Wow .. Subscribed !

[@Innozant]

Thanks Jhaji

[@nishantjha8159]

@@Innozant 🙆🏾‍♂️

[@sandipmakwana6462]

Excellent sir

[@Innozant]

Thanks Sandip Ji

[@fashionmaniaa2710]

jab ap ne choose ka formula uase kar rahe ho to kon se button se $ ka option aayta hai at 08:24 minutes ke video k clip pe deekeyga

[@Innozant]

Dollar sign using F4

[@rescuekitchen5896]

very well explained

[@Innozant]

Thanks dear

[@arvindreddy3546]

8:50 i am getting multiple names in different columns instead getting Arjun shaw after giving formula also unable to paste formula as define name is disabled. Any thoughts are appreciated.

[@sanashakeel6578]

I am not able to get the correct values of the person ny applying vlookup formula. Like did rohit's data/record is not populated instead someone's else data come at his place. Can you please guide?

[@ssurey9276]

Impressive 👌👌

[@rey4646]

Fantastic explain

[@srinivasanv1490]

Hi, I do not know, How i missed you, accidentally came across your videos, excellent and simple, down to earth approach, Thanks for all your efforts to educate us,

[@Innozant]

Thanks Srinivasan sahab.. Thanks for being part of Innozant family ❤️👍

[@QamarAbbas-dq3fh]

Best Sir u r best

[@Innozant]

Thanks Qamar

[@jyotimoyyi3410]

Very good brother

[@Sachin19831000]

Thanks for valuable information

[@Innozant]

Thanks dear for your valuable appreciation.. Happy learning

[@mokhash.h4724]

Wonderful sir g

[@himanshukesarwani1619]

I'm getting an error when assigning the cell link , step at time of video 9:26, error "reference isn't valid" please guide

[@saurabhsen007]

Beautifully explained sir🙂👍

[@Innozant]

Thanks Saurabh Ji👍❤️

[@soniabhi8327]

Sir Excel 2010 me slicer ka option hai??

[@RightVoicealways]

@Video 8:25. Sir bahut sahi chal rha tha sab...achanak se apne wo index Liya A1 fir wo dollar k sign kaise aaye samajh nahi aa Raha $A$1

[@neerajbasole4861]

while using choose formuale single employee is not being linked whole list is being selected can you please resolve my query.. casuse of that i am unable to create further dashbord

[@MohdIrfan-be5ib]

Hello sir, you are the great teacher on youtube . Mujhe Practice me ek problem aa rahi hai jab mai n Vlookup ke shaath match formula lagaya hai to wo exact match nahi kr raha hai aur kisi dusre employee ka data show kr rha hai.

[@Innozant]

Galat paas kar re hain match app..phir se dekhiye video aur sahi se apply kariye kaise seekhaya gya hai

[@vijaysahal4556]

superb sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay ji

[@aloktripathi3177]

Excellent KPI dashboard. Guide me if i have to use multiple drop-down linked sequentially

[@bhausahebsakurkar210]

Very Good.........

[@Innozant]

Thanks

[@ShivaSurabhi-mq9qw]

I am facing problem with the emp performance data mapping. where I am getting the values of one empl. to another employee... please help me in getting solution...