Fantastic way of explaining Microsoft Excel. You are the sole teacher in RUclips who explains the topic so easily and bound to make us the fan of MS Excel 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Hi brow regularly I am waching your videos. Your explanation is very good. But Your videos are in Hindi only. But I don't know Hindi. If in English is it good 👍.
Sir mere windows b 7 hai aur ms office b 2007 hai toh agar muje excel upgrade karna ho toh konsa wala lena chahiye. Note: my laptop is also too old, m just using it for practice purpose.
Sir ur teaching is fantabulous....salute from India I have a doubt can u solve this please. Say, for subject ...external passing is 18 out of 60 and internal passing is 12 out of 40 and min passing is 40 out of total 100. So there are 3 conditions here. For eg. Now I take English subject...a person got External 40 Internal 10 Therefore Total is 50 Now looking into 3 condition he has failed in internal I.e. 10. Now he repeats the exam Now he gots External 45 Internal 20 And therefore total 65. What i want to find is sir that external that changed from 40 to 45(which should not change because he has already passed in the 1st attempt) should be highlighted!!! So that I know if there are any changes in the data Can u pls help me with this sir!!
Hello sir. What according to you gives a precise result.. OR/XOR? I mean if i get both the hard drive and ram of my choice within my budget then i will go for it.. Hence result is True in this case.
Sir ji samajh me to bahut acche se aa gya lekin won and loss bale example me theesra match khelna compulsory ho phir chahe bo third match haare ya jeete to aisi condition aa gyi tab kya karenge sir ji..
Galat kar re hain dear..kaide use kar re haij xor ye btaiye aap? Watch video again..koi prob nhi aata hai Xor ke case me ydi 2 condition true ho aur result false karana ho to xor use karen
IN THIS WHILE USING XOR IF MANUALLY INSERTING XOR AND XIRR AFTER WRITING THE CONDITION IT SHOWS ERROR #NAME? .I HAVE COPIED THE SAME FORMULA AS IT IS , STILL IT SHOWS #NAME?. SO PLS CAN U SHARE THE FORMULA IN THE COMMENT
learning without boring, you teach in a unique and amazing way.
Thanks Monty For your wonderful feedback,Hope you enjoy the session and learn to enhance your skills.Keep learning and share with others too
@@Innozant Sir, what i have to do if i want to learn sql or vba from you? Any Contact number?
Very well explained Sir. No One has explained this function in such a simplified manner. Thank You.
Thanks Rajeev Ji..Happy learning
Xor condition ....u did explain very well sir...
Explanation was very good..
Bahut achhe se samjh me aaya धन्यवाद सर जी
Thanks Sharmaji
@@Innozant you welcome sir I always support you
Sir VBA, CSS, python ka complete tutorial basic to advanced bhi build kijiye because hamein aapka teaching style accha lagta hai and good night sir
Fantastic way of explaining Microsoft Excel. You are the sole teacher in RUclips who explains the topic so easily and bound to make us the fan of MS Excel 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks Sumya Ranjan sahab
really means a lot to me 👍❤️
Very good explain all videos
I am not your student till now but big fan of your explanation and presentation skils .No one get bored.
wa so nice koi jawab nhe hai aaaap ka ssir la jawab ho aaap
Thanks Dear..Really means a lot to me
Aap ne bhut acchi video banai hai
Sir Or ex video banaiye please 🙏🙏🙏
Thanks dear..Happy learning ❤️
Very good explan and with example
Thanks Kundan ji..Keep supporting..tc..hv a nice day
good explained sir 🙏🙏🙏👍🏻👍🏻👍🏻
Hi brow regularly I am waching your videos. Your explanation is very good. But Your videos are in Hindi only. But I don't know Hindi. If in English is it good 👍.
Thanks Dear,This channel is dedicated to Hindi audience.Will try to add caption
Sir mere windows b 7 hai aur ms office b 2007 hai toh agar muje excel upgrade karna ho toh konsa wala lena chahiye. Note: my laptop is also too old, m just using it for practice purpose.
wonderful
TQ...SIR...🙏🙏
awesome video
Thanks Dubey Ji
Thank you very much Sir ji. I never heard of XOR logical function. do you have more test assignment for Xor ?
Best explaination
Sir ye konsa version hai excel ka ??
Thanks a lot
Thnq sir its new xor
Thanks Gaurav...Aap mehnat Kar re ho..M happy for you... Proquest Checkpoint Ka solution karke jaroor bhejiye
@@Innozant sir maine attach kar di thi file question ko karkar maine Saturday ko upload kardi thi sheet apke google form par sir
Thanks sir
Sir samjh me to sab aa gaya.. Lekin masla ye hai.. XOR ko hum kab kese use karenge..
Sir aap ne sirf 2 hi consider kr rhe h by the way ..us se jyada conditions apply krna ho o kaise krege please sir reply
Nice video
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
thnx sir
Thanks ❤
Sir ur teaching is fantabulous....salute from India
I have a doubt can u solve this please.
Say, for subject ...external passing is 18 out of 60 and internal passing is 12 out of 40 and min passing is 40 out of total 100.
So there are 3 conditions here.
For eg. Now I take English subject...a person got
External 40
Internal 10
Therefore Total is 50
Now looking into 3 condition he has failed in internal I.e. 10.
Now he repeats the exam
Now he gots External 45
Internal 20
And therefore total 65.
What i want to find is sir that external that changed from 40 to 45(which should not change because he has already passed in the 1st attempt) should be highlighted!!! So that I know if there are any changes in the data
Can u pls help me with this sir!!
Sir ji, Xor function aise khonse business scenario me lage ga?
Kai situation me jab opposite Krna ho condition ko
Hello sir. What according to you gives a precise result.. OR/XOR?
I mean if i get both the hard drive and ram of my choice within my budget then i will go for it.. Hence result is True in this case.
Yes if it is in your budget then fine..kindly note that in case of both result true our xor function will return false as result.
@@Innozant got it sir.. Thank u :)
Sir iss example me agar "OR" And "XOR" me If laga kr check krege to rusult alag aaega?
Haan bilkul alag aayega or ke case me true true true hi rehta h jbki xor me wo false
aap small latter me likhte hai automatic capital kse ho jta hai
Sir ji samajh me to bahut acche se aa gya lekin won and loss bale example me theesra match khelna compulsory ho phir chahe bo third match haare ya jeete to aisi condition aa gyi tab kya karenge sir ji..
phir to custom requirement hua na..formual apse requirement ke hisab se apply krenge
Sir it's request you can you please provide us tally class tutorial which is very helpful to me 🙏🙏
Abhi to nhi kara rge hain Tally hut in future jaroor karenge uplaod tally videos
@@Innozant 🙏🙏sir for your guidance god bless you stay fit stay healthy
Thanks
sir plese give me some excersize of these Function :if ,or,and ,xor sumif ,sumifs,sumifwild card,
It is there in folder ..kindly check video description
Dear sir, XOR function apply karne #NAME? Error aa raha hai
Galat kar re hain dear..kaide use kar re haij xor ye btaiye aap?
Watch video again..koi prob nhi aata hai
Xor ke case me ydi 2 condition true ho aur result false karana ho to xor use karen
IN THIS WHILE USING XOR IF MANUALLY INSERTING XOR AND XIRR AFTER WRITING THE CONDITION IT SHOWS ERROR #NAME? .I HAVE COPIED THE SAME FORMULA AS IT IS , STILL IT SHOWS #NAME?. SO PLS CAN U SHARE THE FORMULA IN THE COMMENT
Which version you are using ..XOR is available in 2013 version
Kindly explain
pls correct your pronounciation
Ok..will take care ..Keep learning..Keep exploring ❤️
Xor, ka use smj nhi aa rha shi se, kuch or b example btayiye Sir, jisse mere bheje m kuch ghuse
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
thnx sir
Thanks Rinku Ji ❤ Happy Learning
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen