EXCEL ERROR WORLD -Part 1 | LIVE EXAMPLES
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- Excel Errors Explanation with Live Examples
1. Incompatible Cell Address-#NULL!
2. 1/0 Gives divide by Zero error-#DIV/0!
3. Incompatible data Involved in Formula-#VALUE!
4. Incorrect cell reference-#REF!
5. Incorrect name of a cell or other defined names- #NAME?
Number range cannot supported by Excel-#NUM!
Incorrect argument used on formula-#N/A
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#excelerrorworld #errorinexcel#Innozant #error.typeinexcel
Apne Hume Bhut kuch sikha diya sir Tq❤
I get error knowledge is first time by your channal its very knowledgeable channal and Till date nobody has told all this seriously thank u so much
Thanks Dear Lokesh..These feeback really motivate me a lot🙏♥️
Bahut badhiya sir
Nothing better than that to know about errors.
Thanks Hemant ji..Soon more videos on error handling.🙏♥️
@@Innozant thanks you sir
Awesome kahu ya excellent kuchh samaj nahi aata per jo kahu dil se kahu you are great
Thanks Kishor..Excel sheet practise link are there in description.please rehearse it
Sir very nice information about in excel formula errors with
error code I clear all code symbol
Thanks Pramod Ji.Tc.Have a nice day.🙏🙂Hope you learn from Error video
best video....types of error and reason cleared now...thanks sir
Sir I must say that there are no errors in the way you explain these tricks and your output really helps people like us in learning and implementing new things..Thanks and please keep going like this
Thanks Abhishek Ji,Hope you start learning Now and able to understand the training methodology
We welcome you to experience the taste of success.Happy Learning 🙏♥️🙂
Excellent
True Guru of this ERA.
Thanks Sujata for your valuable appreciation .God bless you.. Happy Learning dear❤️
Bigg Boss of Excel world, thanks sir
🙏♥️Thanks dear ..hv a nice day.tc
Thanks for making this video I am waiting for all kind of error occurs in excel. thanks, sir ji 🙏
Thanks..More videos in Error type ..reson of occurance and error handling 🙏♥️
Best Video About Errors
Thanks Pawan..Aur bhi hain video errors ke wo dekhiye
@@Innozant Yeah! I Have Just Seen.
सर EXCEL ERROR के बारे मै आपने बहुत ही अच्छा सिखाया आपने कॉसेप्ट क्लियर कर दिये | सर आपकी प्रैक्टिस फाइल का लिंक नहीं है और गूगल ड्राइव मै भी नहीं मिल रहा है |
Thanks..Link are there in Description.Please find it now.
Thank you so much
Error World
Very useful video
Thanks Vinay Soni Sahab.🙏♥️
Informative, Inspiring, Revealing, Thought Provoking. Fantastic
Speechless🙏♥️ Thanks Sir for such a wonderful feedback..Will always try to make some awesome content.
@@Innozant I appreciate your enthusiasm, zeal, vigour, dexterity & grit. Keep it up.
thanks a lot
I must say sir the way you explain each and every concept is just unmatchable!
May lord Shiva bless you with good health and happiness 🤗
#Innozant
#DilipSir🙏🙏
Thanks Anoop Ji for your valuable appreciation.Keep Learning ❤️ Keep Exploring ❤️👍
Without error we don't learn anything in life or excel thanku very much sir good night.
Thanks Satish Ji..Soon more videos on error handling..🙏♥️
It's very important topic I can understand that where getting mistake by me
Thanks Lokesh ji,Hope you like the video and error explanation
Sir ji motivation students chaiye aap ko nahi.. like tho hamesha bantha hai.
Sir, You are truly a master.. Hat's off you👍
Thanks Yogesh Ji,Hope you learn from.this video.Gn.
Yes of course, you are ease to teach every topics very well.. Keep it up sir
Sir, unbreakable space, substitute से हटाकर उस डाटा को sum करने की कोशिश कर रहे हैं तो #value error आ जाता है कृपया उपाय बताए सर please, 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍
U r amazing 😊
good explain sir 🙏👍🏻
Thanks Karan.🙏♥️Good Night
Wow master ji
Thanks Sarthak.Hv a nice day..
🙏🙏🙏
U r also a good actor
Thanks Japleen..Must watch Jatadhari Special Learning with Fun Episode ❤️❤️❤️
Love you sir
Thanks dear
nice error concept🙏
Thanks Sandeep,Good night.🙏♥️
Nice #Sir
Thanks Prabhu
dear sir! offset function mien value error aa raha hai. jab mein ctrl=shif=enter karta hun tu dropdown list kam karna band kr deti hai. us mein koi mistake nahi hai. mein ne bar bar check kia
Awesome👍
Thanks Sushil hi,🙏❤️Happy Learning 👍
Well explained sir 👍keep enlightening us
Thanks Anand ji,Keep Supporting.Good Night..tc
nice video sir
Thanks Yameen..Practice file link are there in description.Download it and do practice for the same.
👍
its interesting😉
Thanks Pavan..Tc.Gn..Hope you enjoy the Error video.
❤️❤️❤️
Sir mere kehne ka matlab he data tab me advanced filter me criteria me color ko filter karna he or no fil color ko filter karna he
Use filter by color option..from filed list drop down.
Or custom filter by using color code.
Nice
Thanks..Practise link are there ..rehearse it
@@Innozant ok sir
Please start with vba aswell
Sure dear
Sir yadi mere pass pure month ki date h or mai usme se kisi especific day ki date ko unme se extract ya colour ya highlight krna chahta hu tao vo kese kr sakta hu.
Please give me solution
Extract karna chahte hain to auto filter use krke ya advanced filter use krke us date ko kariye extract aur color karna hai to conditional formatting me jis date ko karna hai color uske liye condition apply kriye.
Kuch specific requirement hai to data share kijiye kya karna chahte h. Telegram id -@innozantofficial
Conditional formatting me us date k weekday ko desired day se compare karwa k color kr skte ho
Kya haal hai sir
Theek hu..aap kaise haij.Ravi sahab.🙏♥️
@@Innozant achha hu sir
SIR i am about to finish the basic excel series of 73 videos, please advise me what I need to see serial wise after this . please advise me the right series to go with
Watch latestVideos description (videos in sequence) Playlist are there ,You need to watch step by step from there..or you just watch training process video from Playlist upcoming notification
Sir मैंने 73 सीरीज बेसिक एक्सेल का देख लिया है, अब इसके बाद कौन सा देखना है, सीरियल वाइज मुझे बता दीजिए, क्या क्या देखना है right order में आपके प्लेलिस्ट से।
@@Innozant i am not able to see, please advise correct sequence.
th-cam.com/video/2935505X3yU/w-d-xo.html
Hare latest video ke description me videos in sequence Playlist share Kiya gya hai
⭐⭐⭐⭐⭐
Thanks Tarjit🙏♥️
How to calculate total weeks in month in excel with formula
Example
Date Week
1/Oct/20 Week 1
4/Oct/20 Week 2
11/Oct/20 Week 3
Multi method you may use..either using logica manually or weeknum or divide it into 4 quarter and apply if formula ti findout weeknum.
Still isssue..You may send your query sheet on telegram id-@innozantofficial
@@Innozant sir yadi mughe pure month ki date mai only Sunday ko hiligt/colour karna ho tao kese krenge
Sir, aapka email address kya hai ?? Mai aapse Excel ka ek problem ka hal janana chahata hu. Dhanyawad.
@innozantofficial -Telegram id pat bhej dijiye. .Time milega to jaroor haal dekhnege apke question. Ka😁♥️😆
@@Innozant Sir G, maine @innozantofficial -Telegram id par post kar diya hai. Plz reply kijiye Thanx..
Supppp
Isse achha kuch bhi nahi
Thanks..🙏♥️