Anna when i took data in bulk from last year to this year the date formate is incorrect means last year date formate is like 1-2-2018 this year formate is like 2/02/2019 when i put filter its showing incorrect formate how to correct that in right formate plz help me
Anna create one playlist in English also because I'm not able to share with my frnds as they don't knw tamil and reason behind asking you is that no such playlist is good in my perspective so kindly requesting you yo create one🙏🙏🙏
Sir, ipo entire column kum Namma data validation panna drop-down list varanum nah enna pannanum, entire column nah select pannitha akanuma,???ila vera option Iruka...pls help me sir..next one cell values la kodutha name ah delete pannanumna epdi?
Hi sir, Nan, Price &Qty ya =ran bet()Formula use pani poten, But Nan total Podumpothu =sum if () formula use panen finala enaku qty automatic ah change aguthu sir. What is the problem happen here sir.
Sometimes vlookup formula is not working in excel sheet. Do I have to change column format like, text, number, etc? Sometimes it is working without any problem. What mistake I do
sir drop down list is easy while in this vedio can you help to teach suggestion list while typing the first ONE or TWO or THREE letters in the cells and suggestion showing option
Ennoda job ku indha vedio useful aa irundhadhu.thank you bro
Your way of teaching is ver appreciable
Line by line I am following your speech very clear Thank you sir...
You are Welcome
Yaru thala ne..semma tutorial
Thanks lot sir, very usefull for my job !!!🙏🙏🙏
super bro . your teaching is easy
Thank you sir. Your teaching is awesome
By using vlookup we can avoid retyping.. it is interesting
Thank You
And your classes very helpful to me
Nice video. Watching one by one.Sir can you pls share practice sheet .
பயனுள்ள தகவல் நன்றி
sir ur each and every clasd is very very useful thank you so much.....and please upload source code of school manajement stytem project plzzzzzzzzz
You can download
github.com/TutorJoes-Stanley/School-Management-System-Project.git
Very useful. Thank you so much 🥰
BEST TEACHER
Your all videos super
Very helpfull video. Thanks a lot
You are Welcome
Anna when i took data in bulk from last year to this year the date formate is incorrect means last year date formate is like 1-2-2018 this year formate is like 2/02/2019 when i put filter its showing incorrect formate how to correct that in right formate plz help me
send your format
Super bro... Please explain about Xlookup function
Still I didn't get excel update I will so soon
Anna create one playlist in English also because I'm not able to share with my frnds as they don't knw tamil and reason behind asking you is that no such playlist is good in my perspective so kindly requesting you yo create one🙏🙏🙏
NA very much useful, thanks a lot
Sir, ipo entire column kum Namma data validation panna drop-down list varanum nah enna pannanum, entire column nah select pannitha akanuma,???ila vera option Iruka...pls help me sir..next one cell values la kodutha name ah delete pannanumna epdi?
Superb... Boss 🙏
I have one doubt. In my same product but price will be change on daily wise so you have any idea.
I have multiple tax rates how to set ..
Hi sir, Nan, Price &Qty ya =ran bet()Formula use pani poten,
But Nan total Podumpothu =sum if () formula use panen
finala enaku qty automatic ah change aguthu sir.
What is the problem happen here sir.
Super sir data multiple sheet connection link functions and pivot table link data functions konjam teach pannuinga sir please please please sir
Very useful bro..
Sir ,one doubt how 2,0 comes first column s.no, 2nd column item,3rd column rate so it comes 3,0 only
mugesh nsrgm enakum athey doubt than. Stanley Sir plz comment
You have to count from the columns you have selected. Not all the columns
super thalaiva
SIR, how did you created that template? from existing form or can we use blank sheet and type ourself?
Sometimes vlookup formula is not working in excel sheet. Do I have to change column format like, text, number, etc? Sometimes it is working without any problem. What mistake I do
View this video's Vlookup In Excel Tamil: th-cam.com/play/PL4unWLKFsZfdkQcWWwPfUv71CXKh1QJBH.html
sir drop down list is easy while in this vedio
can you help to teach suggestion list while typing the first ONE or TWO or THREE letters in the cells and suggestion showing option
Sure I will do
@@tutorjoes thanks
Bill podumbothey innoru sheet la date oda bill amt save aganum ..... panna mudiuma sir
Clear explanations
Bro, How to create "unique id" like roll no. from Excel data? Because ippo unique no's illama irukka excel file la yepdi vlookup achieve panrathu?
Super very useful
Hello sir good evening I don't know how to clear the items,look,pass and table names in the name box so could you please tell me sir
IN CASE 100 PRODUCTS AVAILABLE HOW TO SELECT IF ANY SEARCH BOX POSIBLE PLEASE REPLY
Nice work...
I try it it throw error like #spill , what the problem sir.
Well sir easy to understand thank u 🙏🙏
Sir, if error la , 0 pathila empty a varanum ,athu epdinu sollunga
Could you please also add a scenario where Approximate Match would be used
Thanks a lot sir..
how to be use a stock maintain in a stores.......purchase & sale ,debit & credit pathi sollunga sir
Ithula sgst cgst and offers athula ebdi podrathu sir
For your referenceth-cam.com/video/HWoeyVGHWy8/w-d-xo.html
One workbook la vera vera sheet la irukura data ku missing data eapdi find panalam sir
Finding missing values
th-cam.com/video/0tuAYvrbkn4/w-d-xo.html
Thank you sir...
Dropdown List Tamil font eappade use pandrathu sir
Circular reference error varuthu bro enna pandrathu
VLOOKUP(look,table,2,0) here i couldn't understand how the 0 comes. Can u tell bro? Anyone else?.
Nice one .
Thank You
Thanks Sir
How to do date wise sales
Thanks
Sooper sir
Thank you
You are Welcome
Sir,how to remove #ref error.please upload a video of type of errors in excel and how to fix it
user this formula
th-cam.com/video/j6ETkXyYZqM/w-d-xo.html
Bro (e-library) PHP project madiri ennoru project podunga waiting bro...
Sure
Thanks jee
You are Welcome
how to add new itam
Weekly course bootstrap latest version tutorial upload pannuga sir plz...
Sure We will Upload it Soon
Thanz sir
You are Welcome
According to vlookup day 9 video
In 2m 34 sec Alt + Down Arrow List out Drop Down
Explain Hlookup
CELL
how to be use a stock maintain in a stores.......purchase & sale ,debit & credit pathi sollunga sir
Thanks 👍
Thank you