தமிழ் உச்சரிப்பும், சிறு குழந்தைக்கும் புரியும் படி நீங்கள் சொல்லித்தரும் விதமும், முடிவில் எவருக்கும் எந்த சந்தேகமும் இல்லாமல் மனதில் பதியும் படி தாங்கள் விவரித்த விதம் மிக மிக மிக மிக அருமை.. வாழ்த்துக்கள் மற்றும் நன்றிகள் ஐயா🙏🙏🙏
Thankyou for all your videos about excel,you help to make me a excel known person in my ofc and also me offering by another software company as a MIS analysis ...all prouds goes to you....🙏🙏🙏🙏🙏
Hii brother.. I learned many things from your videos..Thanks a lot for that.. I have one question..in excel how to highlight a column automatically if it's current week/month in a particular data.
Ji...ippo tan neenga innum xlookup panla nu ninaichem,ippo tan innoru CZcams channel pathen.Before I complete watching that CZcams channel U uploaded here...thanks ...BRO
hi sir.. ur informations are highly useful i need form a table with customer having two or products and also having different quantily.. now i want to consolidate aswellas filter the based on total limits
Sir Thanks for your excellent teaching. I am vermuch interested in VBA programming and want to learn macro. Kindly guide me. If you are organising online class pl let me know. Thanks
Hi Sir, I have been watching your video past few days it’s great experience. Help me with formulas like automatic reflecting in Google sheet, Seems Connected or Not Connected calls one tab to another tab!
Super brother. Can you teach how combine formula works. Like inserting more formula.= Vlookup,iferror,sumif. This types of combinations in one cell. How to use it. Please teach.....
Sir I need to learn daily excel..but I need some advise ... today onwards I started watching your videos...v look up how to use .what is v look up..how to prepare data by using v look up
Superb series anna! I've a doubt in this video What if Mary black had 2 entries (hypothetically), will xlookup return the sum of both values or only the first value?
Total count of employee with Salary >10 Lacs Total count of employee with Salary between 13 Lacs & 15 Lacs Find Duplicate Name in Employee names Pivot Table Gender Wise employee Count Pivot Table Gender Wise employee Count Graph Indha 5question excel apadi pandrathu oru video podunga sir
Hi, Thanks for your presentation. It was very useful. I have a question. I tried this function in excel, but it showed an error. In the formula section, I searched for this but could not found. Can you advise in which version this formula is available.?
Sir I have one problem in excel , in excel I have input the date in US style now I want to change all in Indian style in easy method. Please explain in a short video are comment . Thanks
Oru doubt bro....Last method la if not found function la example No data kudukuren list ilatha name kudutha no data crt results varudhunga bro ...ana Month list ilatha month kudutha apa no data varala bro .... rendume ilatha kudutha if not function kudukura words varanumna enna pannanum bro ....
Don’t Forget to Follow me:
twitter.com/EndlessKnowled1
facebook.com/enlessknowledge
instagram.com/end_less_knowledge
Guru Ji.... All are saying Excel is a Sea but U only teaching how to swim.... ❤️ Thanks
True
Ahaa
Super boss..na en ofzla ipo oru periya excel genius girl agiten..ellla perumaiyum unglukuthan
தமிழ் உச்சரிப்பும், சிறு குழந்தைக்கும் புரியும் படி நீங்கள் சொல்லித்தரும் விதமும், முடிவில் எவருக்கும் எந்த சந்தேகமும் இல்லாமல் மனதில் பதியும் படி தாங்கள் விவரித்த விதம் மிக மிக மிக மிக அருமை.. வாழ்த்துக்கள் மற்றும் நன்றிகள் ஐயா🙏🙏🙏
U r world best teacher...
Really superb sir, even ungalai vitta vera yaralum intha explanation thara mudiyathu sir👍👍🙏
Your explanation is very clear bro keep your great job God bless you.
Va thala va thala va ❤️ ithuku tha kathutu irundha 👍
You arë one and only best teacher tamil online Open platform thanks for your Service
Thankyou for all your videos about excel,you help to make me a excel known person in my ofc and also me offering by another software company as a MIS analysis ...all prouds goes to you....🙏🙏🙏🙏🙏
You're very welcome!
I m 26. But I don't know basics in excel.. but ur video makes me brilliant 👍🙏🙏🙏🙏 tq sir
Hi brother, god bless you brother, ungala mattum than ennoda work la high posting ku promote aiiruken , thank you so much, god bless you more,
Hii brother..
I learned many things from your videos..Thanks a lot for that.. I have one question..in excel how to highlight a column automatically if it's current week/month in a particular data.
Ji...ippo tan neenga innum xlookup panla nu ninaichem,ippo tan innoru CZcams channel pathen.Before I complete watching that CZcams channel U uploaded here...thanks ...BRO
Sir - I keep referring your excel classes again and again for my doubts. Good job👏👏👏
Glad to hear that...
Awesome.bro..
Please help me to understand..match mode clearly..
How it works.. please.. Tell me.
So much useful. Keep up the good work😇brother, we are here to support you😇
hi sir.. ur informations are highly useful i need form a table with customer having two or products and also having different quantily.. now i want to consolidate aswellas filter the based on total limits
❤Your teaching is super anna🥰
Thank you so much 🙂 my brother... Keep learning more about excel important functions czcams.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Realy your help is more useful for self improvement
Thanks bro for your valuable educational videos.
Thank you so much sir it's a big opportunity to enhance our skills .
Thank you for your detailed information about Xlookup ❤️
Sir Thanks for your excellent teaching. I am vermuch interested in VBA programming and want to learn macro. Kindly guide me. If you are organising online class pl let me know. Thanks
Hello 👋 I like ur way to teaching style...
Very useful and easy to understand.. i like your lecturing style as well.. keep it up
Explanation is crystal clear.
may I get practice file of this video.
Unga teaching super bro... 👌👌
Most of the time I think to use lookup value but I did filter mode on topic and finish 😊
vinayagar moolai ha ha ha laddu won by you only not muruga
Hi, Can we use this function to sum up if it contains multiple values for same name, like sumif function. Pls explain
Vera level bro
Nalla Solli Tharinga
Thanks 👍
👍👍🦾no words, firsts time i see good teacher
sir!!! ne enaku kaduvulave thonurenga sir
thank you sonna pathathu....
neega nalla irupinga sir
Everything god's grace 🙏
Teaching vera level bro... Very helpful video......
Leaning many think and very useful for us thank you bro ....😊
Welcome 😊 brother... Keep learning more about excel important functions czcams.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Hi bro,
It would be more advantageous if the arguments can be focused once the function command is given in the cell.
Ur msg very interesting thank you
How to insert mobile number in pivot colum section
Your teaching style is Great.Pls upload VBA Full course in Tamil
Sure I will... Keep Learning more about Excel czcams.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
@@EndlessKnowledge sure ...i following your channel for excel since 2 years
Hi Sir, I have been watching your video past few days it’s great experience. Help me with formulas like automatic reflecting in Google sheet, Seems Connected or Not Connected calls one tab to another tab!
Wow super really you are awesome
Teaching skills changes less
Can you please create playlist for VBA
Nice way of explanation, easy to understand🙏
Hey ur voice is soo good
Super Learning Brother
Super brother. Can you teach how combine formula works. Like inserting more formula.= Vlookup,iferror,sumif. This types of combinations in one cell. How to use it. Please teach.....
sure... in a dedicated video...
May I know your name please, all your excel related videos are suoerb and I am using them at my eork place
Sir I need to learn daily excel..but I need
some advise ... today onwards I started watching your videos...v look up how to use .what is v look up..how to prepare data by using v look up
Your a excel expert 👌👌👍👍👍
absolutely no my friend... i'm Just a Noob..
Sir your amazing thank you
Thala neenga vera level ponga ❤
Sir, how to use xlookup function, if the same name repeated more than once in the column?
Thanks for your teaching
Fantastic video to understand, thanks.
Excellent explanation sir.Thank you
Excellent teaching by Endless knowledge
Ctrl + f kuduthaa find tab varume bro easy yaaroda name venumo type pani eduthukulaame 😅 just fun
superb explainations bro.
i have one Doubt,
if my lookup array different column means how to do.?
Super Anna
First comment.....I learn about ms office from your videos.....could you possible post videos for windows batch file script
Fantastic teaching 👏
Unkada cls laam ilakuvaa vilankuthu sir...,
Sir word and powerpoint basic clslaam poadunka sir pls..
Bro, superb, please send me the xlookup function work file.xls
Hi bro, how to use xlookup if I have return value in b column and h column
Ji..pls make a video... count unique values using multiple criteria...
very good thambi
Very well explanation .Thanks a lot bro..
good explain bro... Thanks
Superb series anna! I've a doubt in this video
What if Mary black had 2 entries (hypothetically), will xlookup return the sum of both values or only the first value?
advanced xlookup video will be uploaded soon nanba... i hope you will find your solution there...
Because, names are Vertical and months are horizontal
So we are using 2 lookups
V lookup and h lookup
Total count of employee with Salary >10 Lacs
Total count of employee with Salary between 13 Lacs & 15 Lacs
Find Duplicate Name in Employee names
Pivot Table Gender Wise employee Count
Pivot Table Gender Wise employee Count Graph
Indha 5question excel apadi pandrathu oru video podunga sir
Wonderful teaching 👌👌👍👍👍
glad you liked it...
Thank Brother useful vedeyo 👏
Sir please reply it which version this xlookup formula support
Hi Bro, excellent but Its unable to work on Mac kindly explain me how to do the same thing on Mac book
excellent eplanation bro
Glad you liked it brother... Keep Learning more about Excel czcams.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Hi, Thanks for your presentation. It was very useful. I have a question. I tried this function in excel, but it showed an error. In the formula section, I searched for this but could not found. Can you advise in which version this formula is available.?
It is available only in new version...
It mean excel 2013
Thanks bro 🎉
can we pivot table instead of xlookup for easy result
Excellent Bro
Sir I have one problem in excel , in excel I have input the date in US style now I want to change all in Indian style in easy method.
Please explain in a short video are comment . Thanks
pl put the video that how to download the adobe photoshop CC 2020
Awesome Class, Could u pls send the Excel Attachment
I am getting an error while trying to fetch dual values(region and sales). Please help.
Thank you friend..!
Always welcome my friend... Keep learning more about excel important functions czcams.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Many thanks sir, very good and intersting.
Sumifs, or filter option use pannalam
Hi sir..
It's very useful for me.. thanks 😊
Sir im using Excel 2019. X look-up option is not there. How to enable x look-up sir?
Superb Ji. Thank you.
Bro practice file attach panna helpful ah irukun
Super explain sir excellent
Super Sir, clear explanation
Oru doubt bro....Last method la if not found function la example No data kudukuren list ilatha name kudutha no data crt results varudhunga bro ...ana Month list ilatha month kudutha apa no data varala bro .... rendume ilatha kudutha if not function kudukura words varanumna enna pannanum bro ....
Hi Bro Google Sheets pathi basics ans Complete video podunga
Excellent Sir,
Super sir vera level ❤
Excellent teacher 🙏
Bro how to solve repeat name issue please tell about that.
sir please send practice sheets in your videos
Thalaiva u r great😊
Same Person sales in diff region but result get only one region ,other region how to get pls explain bro
Thanks bro