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

[@SanjayKumar-uw9kn]

Sir ab mujhe lag raha hai ki mujhe mere real instructor and guide mil gaye hain I feel confident ki ab me nayi nayi cheeze sikh kar career me age badh paunga. Thanks for your videos

[@sukhdevsingh-xm8nz]

Ek question h bhai Ram Sham Neha Ram Dhoni Sehwag Ganguly Dhoni Muje...unique name chahiye Formula se Karke batao jaldi bhai

[@SanjayKumar-uw9kn]

@@sukhdevsingh-xm8nz BRO IF I ASSUME THAT THE VALUES ARE IN A COLUMN THAN WE MAY APPLY THIS FORMULA =IF(COUNTIF($A$1:$A$8,A1)=1,A1,"") AUR AGAR AP CHAHTE HO KI FIRST OCCURANCE PAR PRINT HO TO YE USE KAR SAKTE HAI: =IF(COUNTIF($A$1:A1,A1)=1,A1,"") THERE ARE ALSO SO MANY WAYS LIKE REMOVE DUPLICATES VALUE OR USING ADVANCED FILTER. AUR HAR KISI KI ALAG ALAG APPROACH AND FORMULA HO SAKTE HAIN. HOPE APKO YE SAHI LAGE

[@Innozant]

Good Sanjay..M happy for you.👍❤️

[@SanjayKumar-uw9kn]

@@Innozant It's all your blessings sir Akhir student kiska hun

[@sukhdevsingh-xm8nz]

@@SanjayKumar-uw9kn wa bhai mast .....thanx ....mai index + small...se kr raha tha jo bahut bada formula tha thanx br

[@SameetMantri]

सर बहुत धन्यवाद Sumproduct पहले ऐसे कभी नही देखा था आप बहुत अच्छा काम कर रहे हैं जय हिंद🇮🇳

[@sonikaprabhakar9527]

Bahut hee smooth teaching hai aapki...thank you 🙏

[@Innozant]

Thanks Sonika.. Really means a lot

[@amitavghosh1354]

after watching your dashboard series I realised data analyzing skill is much more required than excel and as I merely have some basic or moderate knowledge in excel I have to enhance my excel skill too... time lage ga.. but I am not going to show my back. Thank you for your extra ordinary effort.

[@Innozant]

Great Amitabh Ji .Keep Exploring 👍👍

[@emamul1987]

@@Innozant Sir we are learning many things from your video however i have to know 2 things. 1st i have big data and i want to make pivot table with scroll button. so i prepared it and take this to dashborad. So if i select 1 item detail to see. One item sales show in dash board but it show total as well and so many extra lines with so many 0 0 0. how to remove this. I have to see 1 item sales % in whole sales of stationary shop. example my total sales is of Rs100 for all items including of pen sale of 15 Rs. i will select pen to know the sale data of pen. this show pen sale data. but i want to know when i select pen it also shows how much % of sale of this pen is in total sale of 100. coz when i select pen it shows 100% pen sale which i dont want.

[@sharad_bhojwal]

Excellent sir 🙏 sir mai apki sari video dekha hu sir Ajj mai advance excel me excellent hua hu to apki vajah se sir app bahut achhe se samajhte ho har ek farmula bahut hi bariki se batate hai. Sir apka bahut bahut dhanyavad sir🙏🙏🙏

[@Innozant]

Thanks Sharda aapke itne valuable appreciation ke liye..God bless You..Happy learning ❤️

[@tejpalsain1507]

धन्यवाद सर जी आपने डैशबोर्ड को बहुत अच्छी तरह से समझाया। वरना डैशबोर्ड को समझना इतना आसान नहीं है

[@Innozant]

Thanks Tejpal Ji🙏❤️ Dashboard ki jai baar practise karna hai nahj to bhool jayenge.

[@abhinav10x]

Your contribution to enhance my excel skill will always be appreciated, thanks is not enough, respect your work।।

[@Innozant]

Thanks Abhinav.Keep Exploring

[@adnanshoukat807]

sir g kamal ka dash board sikhaya ap ny...

[@Innozant]

Thanks Adnan

[@puransingh-sx2tk]

Interesting and knowledgeable kpi dashboard, khud surat dashboard thanks guru g

[@Innozant]

Thanks Puran,Iska practice jaroor karte rehna nhi to bhool jaoge .🙏❤️

[@promiseslb5273]

Really, you are wonderfull excel teacher. I am really want to learn from you...if you take online class I will join...waiting

[@Innozant]

Thanks Pramod Ji for you valuable appreciation. Yes we are running live and offline classes,Kindly visit Innozant website or connect us with team Innozant for more information about upcoming batches (Contact no available in any latest video intro)

[@horrorlovestories]

Thanks sir , I needed the dashboard videos that i got on your channel.

[@Innozant]

❤❤🙏🙏

[@sandeepaswal8944]

Sir This is so amazing KPI dashboard. Today I practiced 10 Times KPI DASHBOARD in Excel-Part 1 videos. My doubt clear. KPI DASHBOARD in Excel-Part 2 Mind blowing. You are a legend. This is THE BEST tutorial that I have ever seen on Excel. You have ignited my passion to learn.

[@Innozant]

Thanks Sandeep,I knw you are dedicated candidate and willing to learn new concept everyday to enhance your skills.God bless you dear 🙏❤️🙂

[@chakz73]

Thank you for a brilliantly explaining KPI. it made things easy

[@Innozant]

Thanks dear

[@darkshadow5708]

Very informative sir ji thank you🙏🙏🙏

[@Rustamsong]

great bhai..

[@Innozant]

Thanks Goldy

[@jaybuddhadev3543]

very nice, language and method is very easy to understand.. truly appreciate.

[@Innozant]

Thanks Jay.. Complete both part 1 and 2 steo by step ..Happy Learning

[@nambi623]

Very useful video 🎉 Thank You Sir 😊

[@pawanjounkani]

Your videos are very good for those who really want to learn excel. Main thing is you give time and effort to learners to grow their capabilities to extreme level in excel. I really appreciate your hard work. Keep it up. 👍

[@Innozant]

Thanks Pawan..Happy Learning dear.❤❤Really means a lot ti me dear

[@meet-robotics2024]

@@Innozant TRY to make an English version to favor world wide learners

[@awinashkumarsinha113]

Sir could you send me Excel sheet

[@sunny-uw9mw]

Good Evening Sir, App ka video🎥 dekhne ke baad mein Mujhe bahut kuch naya sikhne mila. Is tarha ka video banane ke liye Thank you🙏🙏🙏🙏 So much. Kuch Kuch Problem ho raha hai. Shot Out Please🙏🙏🙏🙏🙏🙏🙏🙏

[@satishojha6240]

Very effective dashboard thanku very much sir excellent part 2 I practice this 4 to 5 times.Good night sir😊😊

[@Innozant]

Practice jaroor karna Satish Ji Dashboard ka

[@RMKserve]

Dear Sir Pivot chart pe video nai banai ap ne Ye sab calculations pivot table ma kar k dashboards nai ban sakta?

[@sameermathur9927]

Brilliant video, outstanding usage of formulas

[@Innozant]

Thanks Sameer Ji Happy Learning

[@awaiskhan8135]

Sir thank you so much for this traning

[@sandippagare1740]

Sir ji mujhe aap ka kpi program bahut achcha laga. lekin mujhe same kpi table goole sheet me chahiye. kya aap ek or video google sheet ke liye bana sakte he please?

[@dharmeshsingh8455]

Very good but very tough for beginners.. need to prepare simple dashboard

[@Innozant]

Start fr basic dashboard

[@AmitSharma-xb8bi]

Very good

[@AnamHashmat]

Sir sumproduct formula ni apply ho rha year walay mn guide kr dyn plz

[@kajalthakur02]

Sir aapne koin sa excel ( office) use kiya hai like 7 ..10 koin sa kyo ki mera excel mai developer nhi aata hai

[@Innozant]

Dear Kajal..Developer tab enable Krna hota hai file -options -customize ribbon me jaake

[@kajalthakur02]

Thank you..

[@bhoopendraraghav9781]

Hat's of u sir god bless u

[@Innozant]

Thanks , Practice Kai baar Dashboard ki .ok

[@bhoopendraraghav9781]

@@Innozant ok sir...

[@janmeshsoni883]

hello sir i cant find the practice workbook from the direct link the page link is not opening form the mentioned link in the discription.

[@metv9263]

excellent

[@nileshchavan742]

Nice explained sir. 👍

[@Innozant]

Thanks Nilesh Ji🙏❤️

[@sheebakhan1487]

sir kia interviews main kpi deshboard k bhi question ate hain

[@Innozant]

Not mandatory.mpivot table se aayenge

[@AmitkKashyp]

Super video sir

[@Priyankamaurya1240]

Nice video

[@1gopalakrishnarao]

Excellent. You have shown the easy way of doing Dash Board. Thanks a lot. Expecting some more good videos in the days ahead. Doing a great job indeed for the benefit of Excel lovers.

[@Innozant]

Thanks Gopala Sir🙏🙂

[@ummedali2036]

Oho9

[@ummedali2036]

@@Innozant o

[@pushkalupadhyay]

Sir data analysis par vedio kab upload karengai aap and dashboard series ke or vedio ayengai kya

[@Innozant]

Haan krenge upload data analysys case study. Dashboard ke bhinaur videos ayenge jald playlist me

[@rajnishkumar6249]

sir pls help me Bahut problem a rhi hai ki jb hm developer tab se koi bhi button insert krte hai us button control krne ke liye control ka option nhi ata aur us button pr click krne pr vba ki coding a jati pls sitr

[@-ck4dc]

Very helpful

[@Innozant]

Thanks dear

[@rohidaspatgar3799]

Super information sir. But in previous vedio target set is the confusion

[@Innozant]

Why..it is random value only

[@VishnuKumar-pf6id]

Awesome Sir🙏

[@Innozant]

Thanks Vishnu ji.happy learning

[@RahulKumar-ly6ly]

Thanks a lot sir ji

[@Innozant]

Thanks

[@ramseshu110]

Good sir 👍

[@Innozant]

Thanks Ram.Rehearse on regular basis.🙏🙂

[@kavita8390]

Sir, I am getting value error when I apply sum product formula here. What would be the reason ? When I press F9 to check and logic looks correct . Pls advise? Thanks Kavita

[@Innozant]

Value error shows when we press enter instead of Ctrl shift enter Kindly check the dataset and applied formula again♥️

[@kavita8390]

Sir, I did double check but still same error. Sending u in telegram if u could pls advise Thanks a ton Kavita

[@rajeevvyas4854]

Sir mujhe ek Excel problem hai aap solution kya desire hai kya ?; Mujhe multi value result ke liye vlookup formula nahi set ho raha hai example; table data me two coloms condition me data lookup karana hai

[@Innozant]

Aise samajh nhi aayega..excel sheet ya data format share kijiye

[@kinghundred]

very nice sir

[@MiaziMedia]

Super..

[@Innozant]

Thanks ❤️

[@tohidahmad1194]

gooD viDeo Sir

[@Innozant]

Thanks Tohid Sahab.Do practice on regular basis.🙏❤️

[@rajeevrajak2789]

Monthwise nikalna hoga to kaisy nikalengy

[@pushkalupadhyay]

Sir aap or bhi vedio upload karengai kya dash board se related

[@Innozant]

Offcourse aur bhi uoload hona hai Dashboard series

[@pushkalupadhyay]

@@Innozant sir dashboard series ke question milengai kya

[@relaxingmusic4918]

Sir, I had made this performance sheet but the data does not come correct form can I send your that sheet please you check where I do mistakes..?

[@vijayjha9081]

Sir kya kahi Job interview ke liye KPI Dashboard tak se hi kam chal jayega

[@Innozant]

Mis executive ke profile ke loye apply kr rhe hain to dashboard se jyada ques nhi..excel se aayega..use sahi kriye..aur Interview attend krna start kriye.

[@vijayjha9081]

Thanks Sir❤️

[@vijayjha9081]

And also Thanks sir you do a wonderful work for us I am also belongs to Bihar and I am very happy when I know that you also belongs to Bihar and also from Maithil

[@madhurimaurya9897]

Could you suggest to make performance chart on basis of digital marketing team.

[@Innozant]

you want performance chart only or Dashboard dear

[@madhurimaurya9897]

Both

[@madhurimaurya9897]

@@Innozant if you can help then it's would be easy to manage my work well.

[@thucodon]

Thank you

[@saurabh17sharma68]

Nice sirji kya ye dashboard excel2007 me chal sakta hai

[@Innozant]

Haan...new function koi use Kahan Kiya hai..step by step video dekhke khudse banaiye.

[@uniquemobiletipstricks7714]

❤❤❤❤❤

[@manishsah347]

sir , 3:40 me jo formula laga rhe he sumproduct ka mera error aa rha he , =SUMPRODUCT((YEAR=B$12)*INDIRECT(($A17&"_"&"data"))). It shows #NAME? error, what this error , and how to solve it.

[@Innozant]

name errir tab jab Aap reference/naming range galat paas kar rahe hain..phirse rk baar recap lijiye..naming range miss Kiya hai aapne

[@Meditation5235]

Sir please upload more videos on each type of dashboard. Thanks a lot!!

[@Innozant]

Thanks Saurabh Ji❤❤

[@MukeshSingh-kv4pn]

Sir apne last wale chart m title srikant yani employee name q Kiya because chart to pure ek particular department ka data show kar raha

[@Innozant]

Employee wise report bhi to hai dear

[@RahulYadav-vs2wd]

Kiya Ms Excel ka use real me Company me hota h MIS ke liye.

[@Innozant]

Offcourse...bina excel ke gujara hi nahi h dear

[@allroundgaming7742]

great

[@yogendersingh8464]

Sir last graph me all employees hai pr aapne iske title me 1 employee ka naam kyu diya" Srikant badge"

[@mohammadjamshedrain721]

Sir, aap purchase and sale ka kpi dashboards banaye

[@Innozant]

👍❤️

[@raviprakash8640]

धन्यवाद

[@Innozant]

Thanks Ravi

[@kunalsharma2661]

Sir mujhe 2 questions put up krne h aapse 1) Sir MIS m kon kon se topics cover hote h ? Basic excel, advance excel Ye to ptaa h mujhe but or bhi koi topic h ky jo MIS job k interview m cover krnw pdte h ? My 2 question second comment m h

[@Innozant]

Dear Kunal...Basic Excel Playlist 2 Nd Video dekhiye..Why MIS . Maine complete detail me smjhaya hai data science ko.👍♥️🙏

[@gauravbhatia7987]

Hlo sir sir main je apki dashboard ki series pichle week sabi videos download kar li thi but apne offset formula bohat use kiya hai wo sir muje nhi atta itna app plc offset formula ko bi basic se advance ki videos upload kre sir

[@Innozant]

Gaurav Ji video..KZbin par hi Dekha kren 😁Aise download krke dekhenge to mehnat humari bekar dear ..bht mehnat hota hi video prepare krne me boss. Happy Learning 🙏🙏🙏

[@gauravbhatia7987]

@@Innozant ok ok sir but main abb dash board ki video nhi dekhuga maine dload karlithi but main apni abb sabi videos online dekhuga youtube par thnq

[@Innozant]

👍

[@tasfia5904]

Why did you use sumproduct instead of sumifs to calculate the total data for the years? and also, why is years in the 1st array of the sumproduct function, wouldn't that multiply the year with the data wrongly?

[@Innozant]

Dear sumproduct is array funtion and works in group,and 2nd thing in above mentioned dashboard there is no such big difference if we use sumproduct instead of sumifs and it won't calculate wrong data calculation as when we have single array our sumproduct funcation just add thos values instead of multiply..Kindly debug the formula and try to understand Tasnim,also recommend you to learn Array and Sumproduct Function from Playlist Array and Sumproduct step by step 🙏♥️ Still issue you may connect us Will guide you for the same .

[@vasimuddinsheikh3766]

Sir, Can you please suggest which DBMS is the best to practice SQL commands amongst these two MICROSOFT server & MYSQL?

[@Innozant]

Choose any editor theme is minor differences of syntax

[@varma21abhi]

Excellent 👌 You are making great educational content, you are being undervalued, I wish for to get 1 Million subscribers soon ❤️❤️❤️

[@Innozant]

Thanks Abhijeet Ji for such a valuable appreciation and your concern.Really means a lot to me dear.. Thanks for being part of Innozant 👍❤️

[@eahteshamsharker931]

Anyone please help me... i couldn't set formula in chart title...please help me to write down here that particular formula ''Departmentwise Report from ''&B14&'' to''&G14, in a correction format.

[@kunalsharma2661]

2) Sir MIS jobs k liye interview m kuch questions puch jaate h jaise Purpose of MIS, Different types of MIS, core principles of MIS, Level info. Requirement in an MIS, Level of decision making , advantage of MIS in bussiness, different approaches used in designing an MIS ???

[@Innozant]

Iske upar video banaya hai..Live interview series dekhiye...confidence badhega usse Aapka.🙏❤️

[@binp4920]

Unable to download practice file ..error: practice file does not exist ..

[@Innozant]

Kindly download it from Master link available in video description ♥️👍

[@binp4920]

@@Innozant got it thanks ..

[@puransingh-sx2tk]

Need more vedio on dashboard guru g Daily production wise dashboard template kese banega agar team ki report or individual report publishe karna hoga to example total advisor production count, average apt, IT issue, brk, team meeting, total log in hr,. Data can in increase or decrease It is possible in dash bord

[@Innozant]

Haan abhi the Dashboard ke bht saare video aane Hain dear...Time lgega lekin is channel par aisa koi series nhi Hoga Jo na dikhe aapko..Seekhaane ke maqsad se is platform se Juda hu main..Have patience dear.tc.gn

[@gajanandpawar8977]

There is a problem while applying Sumproduct Formula, it did not work.

[@Innozant]

You are doing som e mistake dear..kindly download the koi dashboard assignment file from given link and again recheck

[@SameetMantri]

गजानन जी शुरू मे मुझे भी दिक्कत हो रही थी आज काम कर रहा है सर बहुत धन्यवाद Sumproduct पहले ऐसे कभी नही देखा था आप बहुत अच्छा काम कर रहे हैं जय हिंद🇮🇳

[@SumitBhagat27]

Sir dashboard meeting me present karne types kya kya hai? Without sharing data how to share dashboard with team mates?

[@Innozant]

Ok..video bnane ki koshish bkrta hu ispe

[@eahteshamsharker931]

Target is always going to be changed, how could we fixed that. And also in this vedio I can see your department bar colour has been changed. Plz let me know how ??

[@Innozant]

Make it value as i use randbetween there,kindly watch video again steo by step you may able to understand each and every step

[@eahteshamsharker931]

@@Innozant after following your instructions, made it value, it's getting now fixed as a single digit. After the change in the performance data of the employees it has not changed now it is not changing anymore

[@amleshdubey5985]

Thank you very much sir, its very helpful for me ............Sir could you Please upload monthly expense Calculator Vs income..Thank you very much !!

[@Innozant]

Ok..dear. Give me some time.will.upload it

[@abhijitchakraborty7950]

There's a another way to create dashboards using power pivot options in excel which is a much more convenient way of creating dashboard where neither renaming of data is necessary nor application of formula and would deliver the exact charts without any error ur way of creation of dashboard couldn't be applied in a real work scenario as it would consume much time and it's not clear whether a change in data would automatically be reflected in your charts as well...

[@Innozant]

Dear Abhijit Thanks for sharing your opinion, Kindlg note that we are trying to provide conceptual knowledge to make them aware the flow of Dashboard development, Dear not a single way, many more ways to create Dashboard these days using data visualization tool....Soon you may able to watch the video for the same.❤❤❤🙏🙏🙏

[@sridharkrishnappanavanerth3388]

Need your help in this regard.I have two dates eg 03-11-20 and 12-12-20 in cells A2 and A3, in cell B5 I want to mention "PRE HOSPITALIZATION BILLS FROM (03-11-20 TO 12-12-20)" Please demonstrate how to do this. When i tried this the two dates are shown in date serial formats, but i want it show in date formats only.i want the every thing to be dynamic, when i change the dates it should reflect in sentence.

[@Innozant]

Pass text before date as date sereal consider it as datevalue. Or you may share your worksheet data format will help you out

[@AwesomeVj0312]

Brothet please sales man ka monthly quarterly yearly dash board ka ek video banao na please, usmay employee ka attendance present, absent, uska performance grading kay saath, grooming ratings, visual merchandising rating, sales ranking, sales target vrs achievement ratings, percentage..msg bada hai par aapkay liye chutki ka kaam hi..

[@karansahu7808]

i'm unable to download to practise file , kindly look this issue

[@Innozant]

It is available in video description link is there

[@omprakashsingh-bl9ku]

Can you share these formats

[@Innozant]

Download link are there in video description..kindly download it and practice

[@avanishchandra3795]

👍👍👍

[@Innozant]

oh..hope you complete this dashbkard by your own

[@avanishchandra3795]

@@Innozant yes sir

[@alkabhardwaj4314]

How to get a raw data

[@Innozant]

What rank you want . kindly share your query

[@binp4920]

Please send the practice file 🙏

[@naveedgul2084]

thanks sir

[@Innozant]

Thanks dear

[@emamul1987]

@innozant Sir we are learning many things from your video however i have to know 2 things. 1st i have big data and i want to make pivot table with scroll button. so i prepared it and take this to dashborad. So if i select 1 item detail to see. One item sales show in dash board but it show total as well and so many extra lines with so many 0 0 0. how to remove this. I have to see 1 item sales % in whole sales of stationary shop. example my total sales is of Rs100 for all items including of pen sale of 15 Rs. i will select pen to know the sale data of pen. this show pen sale data. but i want to know when i select pen it also shows how much % of sale of this pen is in total sale of 100. coz when i select pen it shows 100% pen sale which i dont want.

[@Innozant]

Share your assignment sheet on @innozantofficial telegram id

[@emamul1987]

@@Innozant i already shared

[@chandanshahoo1286]

My radio button is not working please help

[@Innozant]

Issue ?

[@kishoreallampallu7485]

sir ji make a dash board different parameters like sale ,txn,avg,different years

[@Innozant]

Yes Kishore ,Soon you may able to see Sales, Performance and other Daahboard too.Happy learning 👍🙏❤️

[@tailormaldives9725]

Links please

[@Faisal_0703]

practice file does not exists😓😓

[@Innozant]

Kindly download it from assignment master link given in video description.Direct file link is broken but you may able to download it from main link

[@mrrai3791]

Excellent video but your explanation very fast please next time slow

[@Innozant]

Thanks Dear...❤️🙏 Noted..Will take care of it in nead furure ❤️🙏

[@sinoboy4650]

charan kaha he aap k 👏

[@CryptoQuest143]

Kindly provide training file

[@Innozant]

Kindly download it from video description.. assignment master file link are there

[@kamaichhaprfarke]

Second Video is incomplete, because in starting of the video you have connected three dep. with other options , how you haven't discuss.

[@Innozant]

Kindly watch first video of Kpi followed with 2nd video dear. its complere video of KPI.❤️🙏

[@mitulpatelful]

Plz send me excel file

[@Innozant]

Kindly download all assignments from second link given in video description.

[@rajeevrajak2789]

Sahi say nahi samjhaty or adha adhura bataty hain

[@Innozant]

Rajeev ji..aap ek ek comment jarur padhke dekhen students ka ki maine ek ek step in detail process btaya hai ki nahi .aap ydi steps jo btaye gye hain wo galat krenge to kaise aayega output

[@shubhamsachdeva6969]

Thank you