Sir you are the best! Everyone in TH-cam teaches to promote their course and knowledge and give us brief and leave it to us…But it is very clear from every video of yours that you only want us to learn …Your teaching method makes us feel that we are in actual classroom and teacher is keeping us very attentive …This is what we call teaching and actual teacher👏👏👏
Thanks Mounika for your valuable appreciation and Feedback.Finally main jis soch ke saath aaya tha TH-cam platform par ye apka comment aaj mujhse sachme acha feel karya hai ki main sahi track par hoon..I am one of the most underrated on TH-cam but you recognise,Really means a lot to me,God bless you dear.Have a wonderful career ahead ❤️
मजा आ गया सर आपके वीडियो से बहुत motivation मिलता है मै पेशे से accountant हु और आपके द्वारा सिखाया गया countif functions को use करके और उसमे कुछ कोर excel की tricks use करके मैने GSTR-2 A की excel file download करके अपनी books की purchase entry को मेच करके देखा result भी excellent आया जिस काम को करने मे पुरा करने मे पुरा 1 दिन लगता था वो अब लगभग 2 घन्टे मे ही हो जाता है 2 घन्टे भी इसलिये लगते है क्युकी मेरी excel sheet को GST PORTAL के हिसाब से formatting करने मे थोड़ा सा समय लग्ता है जबकी formula तो तुरंत लग जाता है इसका क्रेडिट केवल आपको ही जाता है क्युकी आप बहुत अच्छे से किसी भी टोपीक को समझाते हो 🙏🙏🙏🙏
Your technique of teaching is just awesome. The best thing about you sir you teach because you want people to learn and get benefitted but in many videos people teach just to showcase that they know better. You show a sense of belongings as you want to make our work easier.
Revise kar raha hu sir. now excel seems easy compared to one year ago. Thanks to you 🙏. I saw below my comment and your reply which is 8 months old.🙂🙏 There is no teacher like you.
You Beauty sir the one and only in the youtube Mr Innozant ,learn more God bless you outstanding stunning. we learn alot sir before it i watched many vidoes but i didn't find like it so gorgieus....
Already diya gaya hai excel sheet dear..kindly aap video description me jaake assignment master download karen ..aapko harek playlist ka excel practice sheet mil jayega
Sir, I need your help. Actually I have a excel sheet of survey done details date wise mentioned in it and I have 11 survey teams. I want to add a formula in an incentive column as like, on same date if a survey engineer surveyed more than 3 surveys then he get 100rs incentive for his 4th survey and then 5th survey and so on. If he did survey 1, 2 or 3 then no incentive given to him. Which function I have to use?
Tahseel sdm office me operator work k liye kis application pr camand achchi honi chahoye h .word ya excl me . Sir please answer zaroor de dijiyga sir please sir plz answer dijiyga.
Sir aapko fir se preshan karne k liy sorry sir . Sir mera ek or question h sir mujhe ye to aapne bata diya word excl aana chahiye lakin sir mujhe excl me kon kon se function pr jada focus karna h .sir mera marg darshan aap hi kr sakte h. Sir plz reply dijiyga mujhe bhi safal hona h life me
I have a data set where it has Start Date & End Date. I need to count a number of total cells if my Start Date & End Date is same. What formula i should use to get this answer??
Sir main stuck hun ek jagah aapki help chahiye..agar ek column me multiple duplicate words hai aur us har ek duplicate word ka row number chahiye to kya formulae use karenge
Good Morning Archana,Kindly ask those candidate that in regular office work & mis reporting which application I need to use Excel or R programming? 2nd thing if the person is not from technical background or No interest in programming then what is the use of R programming for those person. 3rd thing tell those person yadi itna hi knowledge hai market ka to phir apka R programming bhi opcilit ho raha hai...Better to learn Python Instead of R programming as it's limited.
Excel never dead dear,this application is the basic need of daily office work .If you want to make career in MIS fields start learning Advanced Excel first. There are two way to proceed If you are from Non technical background Advanced Excel+SQL+VBA+TABLEAU or POWER BI if you are from Technical background Advanced Excel+SQL+VBA+R programming or python with data science
Sir practice file Ka single link share kijiye rather then complete folder very easy to find out and practice 🙏 otherwise folder ok to find out for practice file 🙏 sir for your guidance 👍
Pawan Ji already sabka individual link diya gya tha but somehow broken ho gya hai link..dubara sabka link phirse generate Krna hoga..time dijiye update kr denge kuch din me
in download files, there are tota, 14 or 15 files under driver, Is this the complete sets of practice ? Or you have some alternative download files sir,
@@Innozant not sure sir, I got only one link, however you are telling there are two seperate links in for practice in all specific videos. This is the problem , can you please tell me where it is , so that i can find it out. As i can see only one download file sir
Is there any formula to get 'TRUE' if the value in a particular cell is 'greater than or equal to' twice the value in an another cell? Plz rply. Thank You
Sir, yeh question thoda off-topic hain. Kya aap bata sakte hain ki new dynamic arrays like Filter function or Unique function k extracted values ko kaisa Sum kar sakte hain? Suppose hum new filter function use kar k kuch data lekar aaye, wahan ek column amount ka hain aur us column ko humain sum karna hain, to kaisa kar sakte hain?
@@Innozant Sir suppose, hum filter function use kar k kuch data extract karte hain and there is an amount column. Ab extracted data table ka size change hote rahega according to the given criteria. How to use the sum function in such a situation?
Sir, i was using countifs function. My condition was that i have to count the number of employees from south region and from Hyderabad branch earning more than 30000 rupees. I applied the formula and it gave me the result 4. While in reality there are 6 employees as such when i count them. Why is it so sir?
اسلام علیکم سر جی کیا حال چال ہے ٹھیک ٹھاک ہو سر میراایک سوال ہے کہ اگر میں ایک کالم میں 1 لکھوں تو دوسرے کالم میں اشاریہ پچاسں لکھا جائے تو ایسا کوئی فارمولا مجھے بتائیں ۔
Dear tell me . I have big data . I need to separate age gender doses . Age 10 to 40 . 40 to60 . And 60 to 100 age factor in this age factors some are male and female and 1st 2nd doses
Sir you are the best! Everyone in TH-cam teaches to promote their course and knowledge and give us brief and leave it to us…But it is very clear from every video of yours that you only want us to learn …Your teaching method makes us feel that we are in actual classroom and teacher is keeping us very attentive …This is what we call teaching and actual teacher👏👏👏
Thanks Mounika for your valuable appreciation and Feedback.Finally main jis soch ke saath aaya tha TH-cam platform par ye apka comment aaj mujhse sachme acha feel karya hai ki main sahi track par hoon..I am one of the most underrated on TH-cam but you recognise,Really means a lot to me,God bless you dear.Have a wonderful career ahead ❤️
Very True
Great information !sir g .countifs and sumifs ki examples krwa dein. @@Innozant
मजा आ गया सर आपके वीडियो से बहुत motivation मिलता है मै पेशे से accountant हु और आपके द्वारा सिखाया गया countif functions को use करके और उसमे कुछ कोर excel की tricks use करके मैने GSTR-2 A की excel file download करके अपनी books की purchase entry को मेच करके देखा result भी excellent आया जिस काम को करने मे पुरा करने मे पुरा 1 दिन लगता था वो अब लगभग 2 घन्टे मे ही हो जाता है 2 घन्टे भी इसलिये लगते है क्युकी मेरी excel sheet को GST PORTAL के हिसाब से formatting करने मे थोड़ा सा समय लग्ता है जबकी formula तो तुरंत लग जाता है इसका क्रेडिट केवल आपको ही जाता है क्युकी आप बहुत अच्छे से किसी भी टोपीक को समझाते हो 🙏🙏🙏🙏
Bht vidoes dkhy smjh ni a rhaa thaa... Best video.. concept clear ho gyaa Thank you so much..
❤️👍
Your technique of teaching is just awesome. The best thing about you sir you teach because you want people to learn and get benefitted but in many videos people teach just to showcase that they know better. You show a sense of belongings as you want to make our work easier.
Thanks Bindu ,Really means a lot to me.Keep learning ❤️..Keep Exploring.
Have. A wonderful career ahead dear👍♥️
@@Innozant stay blessed and keep rising
Thanks for quick response. 🙏🙏
सर आप की और मेरी चोइस मिलती जुलती है जैसे आपको टी - शर्ट और ऐकसल पसंद हे वैसे मुजे भी Thanks for teach us
Thanks..😀
Well teaching. Standing my intlect
Thank you Sir aapne bahut acche se sikhaya mujhe acche se clear hua.
Thanks Daksh
bhot acha concept tha concept dhanewaaad
Thanks dear..aapko mehnat krte dekh acha feel hota hai..iska revert jaroor milega aapko
@@Innozant ji guru ji bs aaap ki batye rate b sahi say chal paon wo he meri liye guru mantar hoga ..
Bs aaap ka sath chaye muje
Revise kar raha hu sir. now excel seems easy compared to one year ago. Thanks to you 🙏.
I saw below my comment and your reply which is 8 months old.🙂🙏 There is no teacher like you.
Thanks Shrikant.Really means a lot to me..Hope you and your family are fine ,healthy and happy..God bless you mJeeo learning.❤️🙏
Sir your way of delivering lecture is very awesome ❤. You are doing a very great job by helping a lot of people.❤
Thanks.Keep Learning
جزاکم اللّٰہ خیرا کثیرا کثیرا
Aap bahut achha samjaye h
You Beauty sir the one and only in the youtube Mr Innozant ,learn more God bless you outstanding stunning. we learn alot sir before it i watched many vidoes but i didn't find like it so gorgieus....
Really means a lot to me
u r amazing sir bahut acche teacher hai aap
Thanks Ankita ,God bless You dear
Thank you so much Sir
Very good method
This is called teaching with feelings .
Thanks Naresh Ji.. Really means a lot to me
Nice sir..
Thanks Brother, It is so helpful.
I wanted to bring earthquake in my learning through ur teaching. Thanks Rajeev Jee..
Thanks dear..Keep exploring
Bahut achcha lga
Apke caunt,caunta,cauntblank,cauntifs
Our batana kuch excel me
Thanks..Aate rhenge videos dear❤️
Thankyou sir ❤
Thank you.
Pls. Show the details example or another uses.
Smart boy love from Pakistan ♥️
Thanks Nasir sahab
So nice explanation for all levels 👏
Thanks dear
Sir excel pe billing ka bi bta do ik br
Thanks for teaching different different types of formulas.
Thanks Hemant ji
Nice sir
Thanks u
You are Great sir
❤💖💖🙏🙏
Which of them is least time consuming??
The bestest best❤
Thank you sir
Thanks
Very nice video sir g.
Thanks Bhoopi..u r sincere candidate...good
sir data analytics ka video pura bnayiye sir, hum apka video ko details se sikh rha hu, very very thankful sir love you 😘
👍
Thanku sir another most most important explanation for count function. Good night sir
Thanks Satish ji.. Happy learning dear..Nice to see ,you learn everyday
Awesome sir 👌👌👌
Sir, advance excel k liye apki agar sari playlists complete krne k baad koi course lene ki need hogi? Ya ye more than enough h?
Sir aapka vidio dekh kr bahut kuchh sikha excel me bahut achha explain krte ho ..kya VBA ka series hai kya mujhe nhi mila..
Thanks..Abhi VBA series start nhi kiya hai jald krenge
Please sir mai wait kr rha hue!!
Good sir
I was waiting for this video..thank u😊
Acha Ji,in this video I discussed concept only..Wait for more examples to come.
@@Innozant okk.. sir😊
Beautiful 👌🙏
Thanks Arti..Gn
Nice sir
Thanks Chandan ji❤️🙏
Nice explain sir ❤
Thanks Ravi Ji..tc..HV a Great day
NICE VEDIO SIR
Thanks Sathya🙏❤️
Sumif or sumifs ke bare me easy method se sikhiye
Hi
Can u explain countifs function using two sheets
Hi Nidhi you may follow Excel Maharaj series after finishing basic excel playlist
Sir aap jo bhi sikhate hai uska excel sheet bhi video ke saath daale meri aap se request hai
Already diya gaya hai excel sheet dear..kindly aap video description me jaake assignment master download karen ..aapko harek playlist ka excel practice sheet mil jayega
Sir You are Great Teacher. I learnt a lots yours all playlist video. Thank you for your gudidence sir ji.
Thanks Sandeep Ji..keep it up
sir you wow
Badia sir
Thanks dear
Sir how to count coloured cell in given range...
Sir, plz let us know how to count green colored cell in given range of colored cells...
Count function ke upper aur averageifs ke down me jo functions h uske bare me bataye sir 🙏🙏
Sir, how to donot count blank cell which contains spaces in cell , using counta
Ap n jese count,countA,count if sekhaya h isi tarha sum,sumif bhi pori vedio uplodd kr den?
Saare videos sequence wise upload hain basic excel playlist me
Thanks
Sir please share or let us know from where we can collect raw data for using multiple formulas of advanced excel.
Example sheet is there..kindly download assigment master folder fekm video description
I waiting for your upcoming excel video
New video tomorrow.
Dipak R. Rathod . Good. 59 years old
Waiting for your more videos as you said in this one. Every video is precious and unique.
Soon dear..may b today evening 😊
I am from Gujarat city Bhavnagar
U r d best sir... But how to remember all the formulas sir ? Plz tell me some tricks
hahaha.. apnr aap practice ke saath yaad rhne lgega dear
👌👌
sir countifs and sumifs me kitne bar criteria range and criteria select kr skte hai. koi limit hai ya unlimited times.
please reply sir
Sir,
I need your help.
Actually I have a excel sheet of survey done details date wise mentioned in it and I have 11 survey teams.
I want to add a formula in an incentive column as like, on same date if a survey engineer surveyed more than 3 surveys then he get 100rs incentive for his 4th survey and then 5th survey and so on.
If he did survey 1, 2 or 3 then no incentive given to him.
Which function I have to use?
❤️❤️❤️❤️
Tahseel sdm office me operator work k liye kis application pr camand achchi honi chahoye h .word ya excl me . Sir please answer zaroor de dijiyga sir please sir plz answer dijiyga.
Normal Ms office ki knowledge..ms word aur excel both
@@Innozant thank you sir thank u very much sir
Sir aapko fir se preshan karne k liy sorry sir . Sir mera ek or question h sir mujhe ye to aapne bata diya word excl aana chahiye lakin sir mujhe excl me kon kon se function pr jada focus karna h .sir mera marg darshan aap hi kr sakte h. Sir plz reply dijiyga mujhe bhi safal hona h life me
I have a data set where it has Start Date & End Date. I need to count a number of total cells if my Start Date & End Date is same. What formula i should use to get this answer??
Sir main stuck hun ek jagah aapki help chahiye..agar ek column me multiple duplicate words hai aur us har ek duplicate word ka row number chahiye to kya formulae use karenge
Bhut badiya sir, but m practical b krti hu apki vedio k sath, but boolakad hu baar baar bhool jati hu.
bhulakkar nhi hain aap..concept ko samjhke apply krna seekhiye..akne aap yaad rhne lagega jab practice Kroge ek hi topic ko kai baar to
First view😍
Thanks Lokesh ji
Sir hame excel ke sare short cut chahiye
Seprate chaiye apko .wo upload kr denge
Sir how can i remove space count in counta formula.
Use substitute instead
Sir, some people says dat excel is dead.. Better learning R.. I don't know. Which is most useful for learning?
Good Morning Archana,Kindly ask those candidate that in regular office work & mis reporting which application I need to use Excel or R programming?
2nd thing if the person is not from technical background or No interest in programming then what is the use of R programming for those person.
3rd thing tell those person yadi itna hi knowledge hai market ka to phir apka R programming bhi opcilit ho raha hai...Better to learn Python Instead of R programming as it's limited.
Excel never dead dear,this application is the basic need of daily office work .If you want to make career in MIS fields start learning Advanced Excel first.
There are two way to proceed
If you are from Non technical background
Advanced Excel+SQL+VBA+TABLEAU or POWER BI
if you are from Technical background
Advanced Excel+SQL+VBA+R programming or python with data science
Kindly watch this video your doubt may clear with this
th-cam.com/video/Z-ElRbzWL2I/w-d-xo.html
@@Innozant Thank you sir.. Ur information is motivate us..
Start your learning Now.Best of luck.
Good morning. I have a question. How do I count different words from a single column in excel 365.
Im not coward sir i am ready 👍
This is what I expect
Dedicated videos
I have knowledge all formula but i want different different types uses of every formula
Have patience..Thak jaoge aap lekin conceptual video aate rhenge humesha..so be ready 😊👍
Sir agar apni koi excel ki problem aapse share krni ho to kese kr skta hu
if i have data in (Apri-21, March-21, June-21) format in a excel shell if i want to count only Apri-21 then how should i count?
Sir practice file Ka single link share kijiye rather then complete folder very easy to find out and practice 🙏 otherwise folder ok to find out for practice file 🙏 sir for your guidance 👍
Pawan Ji already sabka individual link diya gya tha but somehow broken ho gya hai link..dubara sabka link phirse generate Krna hoga..time dijiye update kr denge kuch din me
@@Innozant 🙏sir
in download files, there are tota, 14 or 15 files under driver, Is this the complete sets of practice ? Or you have some alternative download files sir,
Practice file is there Playlist wise and Video example wise as well.You may find two seprate link in video description
@@Innozant not sure sir, I got only one link, however you are telling there are two seperate links in for practice in all specific videos. This is the problem , can you please tell me where it is , so that i can find it out. As i can see only one download file sir
🎉
Sir please help me kisi particular district k ander kitne team members working h kaise check karenge
Couunif with criteria use kriye Vermaji..
Maine padhaya hai na😊❤️👍
AB0
CN5
AB1
NL0
NL0
NL1
SA3
count of records which
doesn’t contain 0
which formula is fit for this question?
What is there are more than 2 criteria for countifs ?
.. i just know know till 2 conditions
No issue at all..kindly explain your query or connect us via telegram id @innozantofficial
Good morning sir
How to count duplicate
Number of ways to count duplicate value in excel,You may find our video for the same in YT channel
Is there any formula to get 'TRUE' if the value in a particular cell is 'greater than or equal to' twice the value in an another cell? Plz rply. Thank You
How i can download the file for practise for each video
Download assignment master folder from videos description
Sir laptop par kaise freez hota hai please help..
Good Morning Sapna.
Function key(Fn) ke saath F4 press karna laptop me
@@Innozant ok sir thank you
Mere pass bahot data usko bhai ek excell sheet me Dashbord bana na hai ...Daily data pase karne par Dashbord auto update ho
Builder mahesh ramesh aise kitane naam hai woh kaise count kare?
Sir, yeh question thoda off-topic hain. Kya aap bata sakte hain ki new dynamic arrays like Filter function or Unique function k extracted values ko kaisa Sum kar sakte hain? Suppose hum new filter function use kar k kuch data lekar aaye, wahan ek column amount ka hain aur us column ko humain sum karna hain, to kaisa kar sakte hain?
Question explain kijiye ya data share ..waise filtered databko sub krne ke kai approach..using aggregate or subtotal.
@@Innozant Sir suppose, hum filter function use kar k kuch data extract karte hain and there is an amount column. Ab extracted data table ka size change hote rahega according to the given criteria. How to use the sum function in such a situation?
Sir .. Countifs me agar 3 to 4 criteria ho..Ek cell k under To kese kare ge..
hi sir
please count ex ; (12346789) explain this formula number count (8)
If I am having multiple data month wise and need month wise unique count, how do we get?
First we need to identify and segregate month and bases on that find out unique value, ok will add this in upcoming tips nd tricks videos
🥰🥰🥰🥰🥰
Sir, i was using countifs function.
My condition was that i have to count the number of employees from south region and from Hyderabad branch earning more than 30000 rupees. I applied the formula and it gave me the result 4. While in reality there are 6 employees as such when i count them. Why is it so sir?
Dear Mehak,Kindlh show me your formula how you pass it or better you may WhatsApp screen shot..with formula .Will guide you for the same.
@@Innozant sir i sent that query some days before
@@mehakmaini9243 Whatsapp or mail?
@@Innozant sir WhatsApp
اسلام علیکم سر جی کیا حال چال ہے ٹھیک ٹھاک ہو سر میراایک سوال ہے کہ اگر میں ایک کالم میں 1 لکھوں تو دوسرے کالم میں اشاریہ پچاسں لکھا جائے تو ایسا کوئی فارمولا مجھے بتائیں ۔
i want to meet you sir
Dear tell me . I have big data . I need to separate age gender doses . Age 10 to 40 . 40 to60 . And 60 to 100 age factor in this age factors some are male and female and 1st 2nd doses
Frequency function ab Tak clear nahi ho paya hai Sir!
It's very easy function..array paas kariye aur phir data intervals