you have the ultimate depth knowledge in excel & its uses, you are ,just an artist or a Guru, who knows all the creation...bahut , magic dikhane wala sasta teacher bhi dekh liya, but un sabhi ko agar aap ke samne byatha diya jaye to un log ka asli aukat nikal ke aa jayega...because, they make videos for earning money, unka content ke ilaba, kuch bahar se topic de diya jayega, to sabhi ka hawa fussss ho jayega. But sir, you spread knowledge, inspiration, motivation, kyun ki sara kuch aap ke andar hain...really you are my inspiration & true motivation of learning excel with interest.
Sir I have learned dashboard from an institute but it was not closely explained..but the way of your explanation about dashboard, it's very easy to understand and completely explain. I am happy that I m your subscriber.
Sir ap bhot best person ha main ak semi organization ma computer py kam krta hoin actually mugy driver ka over time and vehicle maintenance record wagra ko excel py banana ha auto tor py gari ka num enter kryin to detail show ho jhy
I have recently came through your videos and i must say they are indeed very informative and insightful. I'm in process of learning Dashboard so please guide from where should i begin my journey.
sir very nice one secrate you have kept ,the values which were selection not having suffics "$" hence error showing , eg =VLOOKUP(A12,$A$1:$J$9,$K$3+1,0)
Hello Sir I want to pursue my career in Business Intelligence analyst please guide me which are main things to learn so that i start my career quickly.
Hi Sunita. .Aap Basic excel playlist se start kijiye seekhana(Announcement playlist me jaiye whan ek video maine bnaya hai mis learning process wo vidoe dekhiye ki kaise padhai karna hai sequence me) Assignment download kar lijiye aur practice regular basis par
I need our help, regarding chat for our construction sites quality issue, year wise (Actually issue type also many, year also many , project also many,) i need on one graph
Sir isko dekhne kee baad kya charts series start kar sakte hai...konse chart kab use kiya jata hai...jaise gauge chart,Gantt chart, waterfall chart so on...
Hi sir, Earning much knowledge from your videos, i would like to draw your attention, please make industrial daily weekly monthly yearly report dashboard which includes plan/actual production raw material consumption yield% quality,supply..Thanks
Sir am still waiting your response Can you please share dashboard video as i need on my E-mail address??? I shall be very thankful to u for this act of kindness
Dear Rakesh abhi Dashboard ke basics hi start hue hain..Aage aane wale videos me saare form control cover honge Aisa koi topic nhi hoga Excel se related ki aapko is channel par na mile..but time lagega usme thora ..step by step seekhte chaliye
Bus value jab freeze karte ho to wo bata do .. ki kaha freeze karni he is bar apne 2 bar freez ki aur ek hu bar bataya Pehalevali value freeze kiya vo nahi bataya dusari vali value freeze ki vo bataya vlookup ke doran 10.17 to 10.18 time
Dear pehle aap cell reference ke video dekhen basic excel playlist se..in sequence yadi playlist wise seekhenge to ye prob nhi aaygi.. Videos in sequence playlist available hain video description me
Virender ji humne drop down list bnaya haina ab usme sequence kya hai region ka ex-north ka 1st position South ka 2nd and so on....vlookup ko dynamic banaye rakhna h isliye hume index no. Ki value drop-down list se lena hai ..yes or no..?yes..ab aap dekho yadi main usme 1 plus nhi krunga to wo to pehle column ki value le lega..jo humen nhi chaiye.. Aap keh re ki 2 likh do sidhe phir index no ka drop down list se koi link hi nahi reh jayega na dear..ab saamjh aayega sayad ..ya ap dubara video repeat krke dekhiye maine btaya hua hai.thanks
Sagar ji ...Aisa sequence me course aapko mil hi nahi sakta guaranteed. Dear aaap direct uploadrd video dekh rahe hain.. Playlist wise topic dekhiye. Eg..start with Basic Excel Playlist-73 videos hain use finish nkrne ke baad (aap kisi bhi lateset video ke description me jaake dekhen aapko videos in sequence playlist dikhega.usi sequence me course karna hai)
Friend, when I have raw data contain absenteeism, Bill to pay score, schedule adherence and 2 more. These are call center data on daily basis. I want it to present on dashboard. Can u make a video on it please?
# OF EMPLOYEES , AGGREGATE WEEKLY HOURS OF ALL EMPLOYEES & AGGREGATE HOURLY EARNING OF ALL EMPLOYEES BUT RESULT SHOWN IN 4 CONDITIONS ARE :- 1 MONTH YOY , 1 MONTH 2 YOY , 3 MONTH YOY AND 3 MONTH 2YOY HOW TO MAKE KPI DASHBOARD PLEASE GUIDE TO ME.....
you have the ultimate depth knowledge in excel & its uses, you are ,just an artist or a Guru, who knows all the creation...bahut , magic dikhane wala sasta teacher bhi dekh liya, but un sabhi ko agar aap ke samne byatha diya jaye to un log ka asli aukat nikal ke aa jayega...because, they make videos for earning money, unka content ke ilaba, kuch bahar se topic de diya jayega, to sabhi ka hawa fussss ho jayega. But sir, you spread knowledge, inspiration, motivation, kyun ki sara kuch aap ke andar hain...really you are my inspiration & true motivation of learning excel with interest.
Thanks Soumya for your love and support.Keep Learning..Keep Growing 👍
Sir I have learned dashboard from an institute but it was not closely explained..but the way of your explanation about dashboard, it's very easy to understand and completely explain. I am happy that I m your subscriber.
Dear Virender Negi Ji,Keep watching ,Learn and enhance your skills in regular basis.Will try to upload quality video everyday.Thanks .Tc
Mashallah sir,,,,,,,,,,,,,,,,,,,,,,,,,bohat maza aaya..............great sir..Allah aap kaay ilm maay izafa karay.Aameen
Thanks Khalid sahab
You are the king of Excel...Respect
Thanks dear
Apka hr vedio uneeq h, bhut acha smjatey h ap
Thanks Arti for your valuable Feedback..Seekhiye har roj kuch naya
The way you teaches the concept shows your confidence and indepth knowledge in your subject
Plz sir upload a one shot excel course
Thanks Sharma Ji.
Excel video course is available ,Yoi may visit innozant website
Teacher ho to aap jaisa , aisa lgta jaise aap hath pakad kr Sikh rhe ho 🙏 u r great
Thanks dear..God bless
I am really fond of seeing your videos as there are lots of things which is unknown to me can be easily learnt. May God Bless You in your future a
Very nicely explained, 🎉 thanks
Simple way to explain such a wonderful dashboard method. Great sir!!! Thanks a lot.
Thanks Saurabh Ji❤️🙏 for such a lovely appreciation ❤️🙏
mind blowing explaination sir
hats off
😍😄😄😄
Sir ap bhot best person ha main ak semi organization ma computer py kam krta hoin actually mugy driver ka over time and vehicle maintenance record wagra ko excel py banana ha auto tor py gari ka num enter kryin to detail show ho jhy
simple and informative teaching style
Thanks Khan sahab❤️
I have recently came through your videos and i must say they are indeed very informative and insightful. I'm in process of learning Dashboard so please guide from where should i begin my journey.
You want the do dashboard only..if yes then star your learning journey from Povot table followed woth chat and dashboard.
Really very nice and helpful to begginers
Thanks Riddhi..Keep learning ❤️😊
सर आप बहोत अच्छे से सिखा रहे हो.
Thanks dear
Very nice sir aap bhot hi acha samjate hain thanks dir
Thanks
Thank you Sir for your energetic and simplified exclamations.
Thanks Binay ji
i m speechless cant find words to praise you. superb
thanks Aftab.. Really means a lot to me
It's my interest in learning about Dashboard...Please guide me exactly how to start,I came across this video and understood all things
Excelent sir, you are Jenious and always Anspire us thanks a lot and just keep it up and do whatevere you want to do
Thanks Rohit.God bless you dear
Thank you very much sir, I like the way you talk and make us understand things so easily. Thanks by heart.
Thanks Verma ji❤️❤️Recommend you to start your learning journey from playlist Basic Excel Onwards.
Excel's Great Teacher
Thanks ❤️❤️🙏
Thank you sir ji bahout badiya explan kiya hai app ne 🙂
Thanks Javeed sahab
As always, your videos are a rescuer for me at the right moment❤️ many thanks, sir! Btw missing your classes, really good old days.
Thanks Ansh,Have a wonderful career ahead.God bless You..Soon will meet in Your Success Journey Podcast series with me.👍
@@Innozant Sure sir, Thank you😇
sir very nice one secrate you have kept ,the values which were selection not having suffics "$" hence error showing , eg =VLOOKUP(A12,$A$1:$J$9,$K$3+1,0)
I enjoyed making this mini dashboard with you
Thanks Sakshi..
KPI Dashboard 😀 bhi hai aage♥️♥️👍
God bless you.Happy Learning ❤️
Sir is video ki tarif karne ke liye koi word hi nhi hai mere paas 😊 (owsm video)
Thanks Suraj for wonderful feedback,It really motivates me a lot and gives me reason to make good content that adds some value in students Life.
Awsm sir
You r great explainer
Good sir app toh knowledge gain kar kar hi chhodege hamari
Love You ❤️🙏Gaurav Ji itna yakeen show Karne ke liye ..Main koshish Apne taraf se karta rahunga humesha Kuch naya sikhaun.
Thnq sir
Excellent
good lesson
There is no like button highlight..... Awesome
Thanks Monika for your valuable appreciation God bless you .Keep learning ❤️👍
Really very nice way to teach sir. Thanks
Thanks dear❤️❤️
As always..very informative..thanx
This is an amazing tutorial which i have ever seen.
Thanks Dear...Happy Learning dear.
Sir ak request hai,agar excel me calculator kese banate hai basic to advanced level ka kuch video upload kar dete to thoda help ho jata
very nicely explained....
great video sir
Great sir, this is fantasic function and very useful, seriously you are tremendous.
Thanks Shailender ji..God bless you..Happy learning.❤🙏
Sirji, best video
Thanks Hitesh Ji.Keep learning
Excellent Rating...
Thanks sir for this video, can i know how to delete tab incert from deloper bar
Sir video bahut acchi bani hai
Thanks Ritik,Keep watching.
Thanks you so much sir......🥰🥰
Thanks Shivam Ji
Really superb guruji 🙏
Thanks Manoj ji.❤❤
Sir, how to show our dashboard through web and it should be dynamic. Please tell me.
Thanks Sir💞
Thanks
@@Innozant sir aap kaa sb trick super hai 💞
sir developer tab ka combo box vhi same kaam to krra h jo data validation ka list+ match function krta h
Good hai..haan wahan position khud bta deta hai yahan apko match se pta krna hota h relative position
You are superb
Thanks Arti
Super
Really nice
Thanks dear❤️🙏
Job well done sir! Thanks
Thanks dear
Hello Sir I want to pursue my career in Business Intelligence analyst please guide me which are main things to learn so that i start my career quickly.
Thanku sir
Nice thanku sir
Thanks dear
TQ....sir
Very nice
Thanks Elina...Keep Learning ♥️
very nice sir
Sir kindly reply... I was asked an question in interview that how to count alphabet.. like
A
a
A
A
How many capital A in this range.. kindly reply
Sir muze complete excel aur usame dashboard bhi sikhana hai, apaka 1 vedio mene dekha hai apa bahut acchi tarah se padate hai plz sir 🙏
Hi Sunita.
.Aap Basic excel playlist se start kijiye seekhana(Announcement playlist me jaiye whan ek video maine bnaya hai mis learning process wo vidoe dekhiye ki kaise padhai karna hai sequence me)
Assignment download kar lijiye aur practice regular basis par
Really great sir 👍👌🙏
Thanks dear
nice video, thanks
Thanks Ade❤️🙏
Hii Sir ji,
aap freeze kese kar rhe ho?koi shortcut hai kya uska??
I need our help, regarding chat for our construction sites quality issue, year wise (Actually issue type also many, year also many , project also many,) i need on one graph
Awesome sir ji
Thanks Dear
@@Innozant welcome sir ji 🙏
jis ma driver ka over time b calculate ho jhy sath vehicle ka b record ah jhy
Sir isko dekhne kee baad kya charts series start kar sakte hai...konse chart kab use kiya jata hai...jaise gauge chart,Gantt chart, waterfall chart so on...
Haan..start kariye ab chart..No issue
@@Innozant please create what's app link so that we can share problem of excel
I mean what's app group
HOW DID YOU BRING THE DATA IN BELOW TABLE WHERE YOU APPLIED VLOOKUP
Hi sir, Earning much knowledge from your videos, i would like to draw your attention, please make industrial daily weekly monthly yearly report dashboard which includes plan/actual production raw material consumption yield% quality,supply..Thanks
Will be very thankfull of you for this act of kindness
Ok dear..noted
Sir am still waiting your response
Can you please share dashboard video as i need on my E-mail address???
I shall be very thankful to u for this act of kindness
As i am applying +1 in vlookup formula its not working
Sir ji Can we do Same with Pivot Table ,,
Bhai power bi ke interview Questions par video bana do
Pehle power pivot and power query finish krke phir beaten h
Sir I want to learn excel please reply jarur dena
Sir combo box ka range select ni ho rha hai..ek hi cell par rah rha hai
Sir excel Jatadhari interview crack series kab aayega sir excel par dhyan do
Kuch time se busy hone ki wajajse videos nhi bana pa rhe hain..March se phir saare videos series aane lagenge dear..
How the data get is linked for North, east, west
Sir V Look formula Not applied Don't know why
What happen
Please show dashboard link with formula and check box
ITS AND URGENT REQUIRED FOR MAKE A DASHBOARD BECAUSE THIS DASHBOARD SEND TILL THE TONIGHT FOR INTERVIEW PROCESSING
🙏
Ise mail pe report ki tarah kaise publish kare ?
Last few days I'm trying this offset formula but every time it's showing#na please help me to solve the problem
Hi Tanushree .kindly share your query on @innozantofficial telegram id.
What problem you are facing ij offset formula ?
How to merged 2 graph dynamically
Sir forcast analysis par vedios milengai kya
Abhi upload nahi kiye hain forcast analysis videos...jarur krenge pehle conceptual saare topic finish kar lein
@@Innozant actually I need trand analysis so pls fast uploade kariye sir even I m ready to pay your fees sir
@@Innozant but I need all topics of trend analysis agar aapke pass bane huye ho to aap mail kar de mujhe jo apki fees ho me pay karne ke liye ready hu
@@Innozant sir pls reply me
Nahi video bane hue nhi hai..m working on that
when i create month wise result value is not correct
But is not working at ms Excel 2021
Sir aap kaunse company me work karte hai?..exp aacha hai aapka
Thanks Rakesh Ji😊Hope aapko videos pasand aate honge aur aap unse seekhte honge.Happy Learning
@@Innozant lekin aap baki ke form control nahi cover kiye..
Dear Rakesh abhi Dashboard ke basics hi start hue hain..Aage aane wale videos me saare form control cover honge Aisa koi topic nhi hoga Excel se related ki aapko is channel par na mile..but time lagega usme thora ..step by step seekhte chaliye
Bus value jab freeze karte ho to wo bata do .. ki kaha freeze karni he is bar apne 2 bar freez ki aur ek hu bar bataya
Pehalevali value freeze kiya vo nahi bataya dusari vali value freeze ki vo bataya vlookup ke doran
10.17 to 10.18 time
Dear pehle aap cell reference ke video dekhen basic excel playlist se..in sequence yadi playlist wise seekhenge to ye prob nhi aaygi..
Videos in sequence playlist available hain video description me
Sr isme ek baat smjh ni aayi vlookup me index value 1+1 kyu
Direct 2 kyu ni
Plss reply
Virender ji humne drop down list bnaya haina ab usme sequence kya hai region ka ex-north ka 1st position South ka 2nd and so on....vlookup ko dynamic banaye rakhna h isliye hume index no. Ki value drop-down list se lena hai ..yes or no..?yes..ab aap dekho yadi main usme 1 plus nhi krunga to wo to pehle column ki value le lega..jo humen nhi chaiye..
Aap keh re ki 2 likh do sidhe phir index no ka drop down list se koi link hi nahi reh jayega na dear..ab saamjh aayega sayad ..ya ap dubara video repeat krke dekhiye maine btaya hua hai.thanks
Hi sir
Sir How to freeze the formula
Using F4...basic excel se learning start kriye
great vidio but work book download nahi ho rahi
Thanks Faheem Ji for your valuable feedback.
Ab check kijiye link misplace ho gya tha.. download it and do practice.
Sir aapki videos sequence mein nahi milti...
Sagar ji ...Aisa sequence me course aapko mil hi nahi sakta guaranteed.
Dear aaap direct uploadrd video dekh rahe hain.. Playlist wise topic dekhiye.
Eg..start with Basic Excel Playlist-73 videos hain use finish nkrne ke baad (aap kisi bhi lateset video ke description me jaake dekhen aapko videos in sequence playlist dikhega.usi sequence me course karna hai)
Purchase dashboard bhi banado
👍❤️
Sir mere main developer tab show nhi ho rha hai ..
File-options-customize ribbon
Developer tab uncheck hoga use check krke ok press kr dien
how to freeze cell?
Using F4 key.kindly start leqrning from basic excel-The learning begins playlist
How you use freez in formula
Using F4 dear
@@Innozant thank you
Friend, when I have raw data contain absenteeism, Bill to pay score, schedule adherence and 2 more. These are call center data on daily basis. I want it to present on dashboard. Can u make a video on it please?
Can I get your number please
Plz write here formula
# OF EMPLOYEES , AGGREGATE WEEKLY HOURS OF ALL EMPLOYEES & AGGREGATE HOURLY EARNING OF ALL EMPLOYEES BUT RESULT SHOWN IN 4 CONDITIONS ARE :- 1 MONTH YOY , 1 MONTH 2 YOY , 3 MONTH YOY AND 3 MONTH 2YOY HOW TO MAKE KPI DASHBOARD PLEASE GUIDE TO ME.....