@@Innozant yes facing worst Dell service issue 😏 it been 21 days n still not resolved..Feeling irritated..😣 I m also worried abt my practice..Thanks sir n gud to see, u seem concerned about ur students..
@@aakankshasrivastava9497 Ohh.Call Customer care or send someone to talk with them and resolve whatever issue is asap and need to see you back on track soon.
@@Innozant I called many times n spent almost 2 3 hrs on customer care call..Talked with tech support executive n his or her manager still...Not getting proper response Pathetic service..😩
Sir school ka report card mai 3 term exam. hai Lakin student ek paper mai absent hai to average kaise nikalenge. Please help me as soon as possible Thank you.
Sir in this section while using averageif , output is coming for unit but for sales its showing #DIV/0! . and i am still not cleared in freeze where to use double $ and single $, so pls explain in this comment section.
But if multi criteria in same column with another column then it's not work so what the solution example name of person Neeraj And Sohan in same column and second column product name Soap and Shampoo so how to solve
sir, I dont know your email id for writing queries and concerns, I have a big concern regarding the downloading files, I am not able to find where are the particular files stored in which file, Lets suppose I want to practice on the date and time function, then I am not able to determine where will i go in your practice download file, .
why you are confused..everything is categorized.. drive.google.com/drive/mobile/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P/1ip6kBf6ATmuaZOUdC0LfaqTKxpwgEONi?usp=sharing&sort=13&direction=a follow this link..complete basic excel Playlist assignments are there
Sir ager hamara maal kisi din 100 rupees bik 50 kg kisi din bika 5 kg bika 150 rupees or kisi din bika 100 kg 70 rupees to hame quantity k sath rate ka average kase niklega pure month ka
Dublicat remove krne pr cell bhi remove ho gata hai mgr mujhe remove krne ke dad cell black dekne ke liye kaise dublicat ho remove kr skte hai please sir bata dijiye
Dear Bhawna ,Aap khud batayen kinki baat mane,Pehle Sirf Voice over video hi bnate the to student ka dwman aane laga ki sir live video bnayen isse interaction jyada acha rehta hai and I hope ye sahi bhi hai..that's why ab interactive videos banane ki koshish.Aappko yadi kam samajh aaya hai to dubara recap lein video kaa aayega samajh..Don't worry
@@Innozant sir...you are great...maine ye full video dekhi...or bhoot kuch sikhne ko mila...you are awesome sir... thanks again...m average bilkul aache se sikh gyi☺️☺️
83.84 74.19 55.81 43.97 42.9 27.05 Sir, I have above 6 numbers only in column or row, but I need only those three numbers out of above 6 numbers that give me average of 50 or nearby 50 (+5 or -5) I want those three numbers, highlighted or separated automatically.
Kitne gajab ke language use Kiya hai aapne Teacher ke liye ,Galti ho gya Koushal sahab aapka kaafi time kharab hua hoga,Aur bht se channel hain jinme excel ke Jadoo wale video mil jayenge,Wahan se seekhen😊 Kaushal sir teacher pagal nahi hai us waqt editing nahi aata tha ,kripya latest video dekhen,aapke ye bhavwa language badal jayenge,😊Thanks for this greate respect.Gid bless You dear ❤️
Aditya Ji.Thanks for your suggestions.Sayad ye pehla comment aaya hai apke tarafse abtak jisme apko problem ho rahi hai,Dear waise mera koshish sirf content par hi rehta hai,Aisa lag raha hai Innozant family me new member aaye hain aap..Pehle kuch videos dekhiye..Phir feedback jaroor dein.🙏🙂❤️
@@Innozant mujhe jo video dikha uska feedback dunga na. History me thodi jaunga bhai. jab aap screen fully show kroge tabhi log thik se dekh paenge na. abhi mujhe koi value dekhni hai aur beech me aap dikhoge toh it looks weird. aap bottom right me apne aap ko adjust kar skte ho. aur best toh yahi rahega ki aap apni voice use kro bas.
Aditya Ji Sabhi viewers ke view aur mindset alag alag hote hain..Ap ydi mere start ke video dekhen to Sirf voice hi hota tha mera.but viewers ko wo interactive nahi lagta tha tabhi Live aana start kiya main.Anyways thanks for your suggestion,Will keep your words and try to deliver as per audience requirement.Happy Learning.🙏❤️🙂
Always try to be polite and respectful to your teacher and second thing he is sharing valuable things with no fee, be thankful for that too..... This is just polite advice don't take me otherwise
Great Sir Aise Hi Koi Samjhaye To Time Nhi Lagta Sikhne Mein..
Thanks dear
प्रणाम सर जी | सर आपने Statistical Function बहुत अच्छे से समझाया | AVERAGEA Function मैने आज नया सिखा धन्यवाद सर जी |
Good . Happy Learning dear and share with your friends
❤️❤️ Thanku so much sir itne acche se sikhane k liye ❤️❤️
Thanks Mohit Ji.. Happy learning dear
thanks aaj mera excel ka practical hai kafi help mili
Best of luck 👍
Sir You are Great Teacher .... Your all Videos is Mind-blowing .. Your Teaching Style is Awesome
Thanks Ahsan Ansari Sahab for such a wonderful and valuable feedback ♥️🙏
I really enjoy your classes....informative, great learning, practical and well presented.
Thanks Anup ji.Happpy Learning
bahot he acha samajaya sir aaap nay tu
thanks dear..Kyushu Rhiye aur seekhna Jaari rakhiye
Excellent way of teaching🥰
Thank you sir Very helpful
Very nice teaching sir ji
Thank u so much for your enormous efforts and making the things so simple
Thanks Mahi for your valuable appreciation. Really means a lot to me ❤️❤️❤️
Great information sir tq
you earned it.
Subscribed mate
Thanks for being part of Innozant Family.Happy Learning Tauzi Ahmad Shahab❤️
Excellent Sir, The way you explained it's seems too good
Thanks dear..Happy learning
Thanks Sir!
Thank you Sir
Thanks for this video 🔥
Thanks Vikas Ji..Happy Learning dear❤🙏
thanks al lot sir
Thank you sir❤
Very well explained 👏
Sir You are doing amazing but
You should focus to zoom in the sheet which will be more visible...
Thanks Wahid..It was old videos,There is no issue in latest videos
Amazing guru ji ❤️❣️
Mzaa aagya sir
Wow sir 🤩 u r great 👍
MAst Sir ... Kya baat hain .....
I want to know the formula for last produced quantity and date of particular product. Can you please tell me?
Thnx🙏
Amazing video
Thanks dear
Can we average the data by different dates
Sir, kindly do the Power BI complete course videos.Can you do for us.
Will start this series after a month
Sir kya conditional formating me whild card use kar sakte h
10qu sir❤
Depth of water nikalni ho to 1 number 0 aye to divide me 1number kam se divide krenge ya nhi
Amazing sir good night .
Gm, Thanks satish
Kasam Se Sir Aapki Class Me Maja Aa Gya 😊
Thanks dear👍❤️
Suppose,the range of average is dynamic and we need to average of a specific range of cells.How will you do then?
Then select the specific range only
Very Nice
Thanks Bhoopendra ji..
Thnq sir
Thanks Gaurav ♥️🙏
Sir excel mei jo bhi excel se related word aate unka Hindi mei matalab kya hota i mean word ko Hindi mei kya kahte hai ex . Summrize, separated,
Teaching method kafi acha tha. Bus dikkat ye thi ke aapne khud ko jyada space diya hua h screen pe.
Video editing me ye issue rha hoga..latest videos me ye issue face nhi kr rhe honge aap
Nice video 👌
Thanks dear..happy learning
Hi Sir...how to find out values from average
Average se value kaise nikale
Awsome video
Thanks dear❤️❤️🙏
Suprb sir👍
Gm, Thanks
Phir Laptop kharab krke to nhi baith gye hain..It seems again stop practice.😊
@@Innozant yes facing worst Dell service issue 😏 it been 21 days n still not resolved..Feeling irritated..😣 I m also worried abt my practice..Thanks sir n gud to see, u seem concerned about ur students..
@@aakankshasrivastava9497 Ohh.Call Customer care or send someone to talk with them and resolve whatever issue is asap and need to see you back on track soon.
@@Innozant I called many times n spent almost 2 3 hrs on customer care call..Talked with tech support executive n his or her manager still...Not getting proper response Pathetic service..😩
Sir school ka report card mai 3 term exam. hai Lakin student ek paper mai absent hai to average kaise nikalenge.
Please help me as soon as possible
Thank you.
AverageIfs functions me Text error resolve kaise kre(Div error).
Amazing
Thanks Jai🙏❤️
@@Innozant welcome sir🙏
What if i don't to consider Zero as a value?
Where ?
Sir agr bhut sara name Or uska bhut sara rate or quantity ho to average rate kaise niklenge
Average of odd number from sr number
Yes boss
Sir in this section while using averageif , output is coming for unit but for sales its showing #DIV/0!
. and i am still not cleared in freeze where to use double $ and single $, so pls explain in this comment section.
and Averageifs me #DIV/0!
me error aa raha
But if multi criteria in same column with another column then it's not work so what the solution example name of person Neeraj And Sohan in same column and second column product name Soap and Shampoo so how to solve
please tell me sir
3:35 / 12:51 not with 12 bz of text 11
Sir i have one question 1 cell mai 1 se 8 tk ginti h uska sum kese krege
Un values ka sum chaiye kya aapko...?jo 1 to 8 tak hai?
@@Innozant yes sir
& iske badle concatenate use kiya kro plz
Kahan lagwa rahe hain concatenate Virender ji..batayen?
Concatenate jab tak likhenge tab tak to & - ampersand se kaam khatam kr denge sir ji..kaam ki productivity badhaiye
@@Innozant You are Right Sir
sir agar aapke video pehle dekhe hote mere paise barbaad nhi hote
Thanks Dhiraj itna trust show karne ke liye ❤🙏
@@Innozant sir maine course k liye aapke no pe bhi call kiya tha lekin kisi ne pick nhi kiya
sir, I dont know your email id for writing queries and concerns, I have a big concern regarding the downloading files, I am not able to find where are the particular files stored in which file, Lets suppose I want to practice on the date and time function, then I am not able to determine where will i go in your practice download file, .
why you are confused..everything is categorized..
drive.google.com/drive/mobile/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P/1ip6kBf6ATmuaZOUdC0LfaqTKxpwgEONi?usp=sharing&sort=13&direction=a
follow this link..complete basic excel Playlist assignments are there
Sir ji true likhne par 1 ho gya to ab kitne sankhya me divise karne par ye corect aayega
Kaunse function me Aftab ji?
@@Innozant samgh me agya sair
@@Innozant Excel me formula tab ka ek puri video bnaiye sair
Ho sake to ek ek grou ka alag alag video
State government GIS calculation ki Excel sheet hai
Wildcards ka imp abhi samaj aaya 😅😅😅
Sir ager hamara maal kisi din 100 rupees bik 50 kg kisi din bika 5 kg bika 150 rupees or kisi din bika 100 kg 70 rupees to hame quantity k sath rate ka average kase niklega pure month ka
Dublicat remove krne pr cell bhi remove ho gata hai mgr mujhe remove krne ke dad cell black dekne ke liye kaise dublicat ho remove kr skte hai please sir bata dijiye
Aisa ho skta hai ki nhi
Advance filter se kijiye unique list extract dear
Bhai video zoom karke banaya karo
Ye pehle ke videi hain dear jab itna gyan nhi tha youtube video ka❤️ thanks for suggestions
🙏
SHAANDAR
ture ki value ko 1 kyu leta hai avragA
Sir mujhe. Filter ke video bhej do
Filter ke complete playlist available hain channel par
Aaj bhoot late vedio aayi h srji
Agape vedeo me Kya batao he use me agreji pad Gaye tum😅😅😂😂
Sir video dundhula dikh raha hai
Ohh ..
Arey sir poori screen pe toh aap hi hai arey sir side mai aao aur distraction kam karo
Help
Aapne aapko mat dikhaya kro video m....kuch smjh nhi aaya
Dear Bhawna ,Aap khud batayen kinki baat mane,Pehle Sirf Voice over video hi bnate the to student ka dwman aane laga ki sir live video bnayen isse interaction jyada acha rehta hai and I hope ye sahi bhi hai..that's why ab interactive videos banane ki koshish.Aappko yadi kam samajh aaya hai to dubara recap lein video kaa aayega samajh..Don't worry
Ok sir....vaise aacha smjha rhe ho...
Thanku sir ☺️
@@bhawnaprajapati8819 abhi to aapne aagaz kiya hai..Aap Step by step seekhte jayen phir kuch months baad batana aapka experience kaisa rha😀❤️
@@Innozant sir...you are great...maine ye full video dekhi...or bhoot kuch sikhne ko mila...you are awesome sir... thanks again...m average bilkul aache se sikh gyi☺️☺️
@@bhawnaprajapati8819 Thanks Bhawna.Happy Learning.God Bless You dear
Video sahi se nhi dikh raha hai
It's showing fine
0:26 😂😂😂
83.84
74.19
55.81
43.97
42.9
27.05
Sir, I have above 6 numbers only in column or row, but I need only those three numbers out of above 6 numbers that give me average of 50 or nearby 50 (+5 or -5) I want those three numbers, highlighted or separated automatically.
Kindly share excel sheet @innozantofficiap telegram id .will see
pagal insan puri video me to tu hi dhikh rha he , table to dhik hi nhi rhi
Kitne gajab ke language use Kiya hai aapne Teacher ke liye ,Galti ho gya Koushal sahab aapka kaafi time kharab hua hoga,Aur bht se channel hain jinme excel ke Jadoo wale video mil jayenge,Wahan se seekhen😊
Kaushal sir teacher pagal nahi hai us waqt editing nahi aata tha ,kripya latest video dekhen,aapke ye bhavwa language badal jayenge,😊Thanks for this greate respect.Gid bless You dear ❤️
bhai saab screen dikhao khud ka chehra nahi
Aditya Ji.Thanks for your suggestions.Sayad ye pehla comment aaya hai apke tarafse abtak jisme apko problem ho rahi hai,Dear waise mera koshish sirf content par hi rehta hai,Aisa lag raha hai Innozant family me new member aaye hain aap..Pehle kuch videos dekhiye..Phir feedback jaroor dein.🙏🙂❤️
@@Innozant mujhe jo video dikha uska feedback dunga na. History me thodi jaunga bhai. jab aap screen fully show kroge tabhi log thik se dekh paenge na. abhi mujhe koi value dekhni hai aur beech me aap dikhoge toh it looks weird. aap bottom right me apne aap ko adjust kar skte ho. aur best toh yahi rahega ki aap apni voice use kro bas.
Aditya Ji Sabhi viewers ke view aur mindset alag alag hote hain..Ap ydi mere start ke video dekhen to Sirf voice hi hota tha mera.but viewers ko wo interactive nahi lagta tha tabhi Live aana start kiya main.Anyways thanks for your suggestion,Will keep your words and try to deliver as per audience requirement.Happy Learning.🙏❤️🙂
Always try to be polite and respectful to your teacher and second thing he is sharing valuable things with no fee, be thankful for that too..... This is just polite advice don't take me otherwise
@@vasimuddinsheikh7478 I also gave him a polite advice. Read the comment first.
Thank you sir
Thank you Sir.
amazing
Sir i have one question 1 cell mai 1 se 8 tk ginti h uska sum kese krege