Hi, i want a video on excel which will allocate leads to employees evenly among the team. Condition is that leads of same location to be employees of same location by excel formulas.
చాలా బావుంది సార్. కాని "Half Day " (H) కి కూడా ఎలా వెయ్యాలో చెప్పండి....ఒక సెల్ల్ లో "H" అని ఇస్తే అది కౌంట్ లోకి తీసుకోవడంలేదు.... Kindly let us know how to update half day attendance also.. Thanks
సార్ మీ యొక్క ఆన్లైన్ లో తరగతులు చాల చక్కగా అర్థం అయ్యేరీతిలొ చెప్తున్నారు, చాలా సంతోషంగా నేర్చుకుంటున్నాను. సార్ MS EXCEL లో ప్లైట్ సెల్స్ ఎలా చెయ్యాలో ఒక class తయారు చేయండి సార్.
Nenu studies manesi 7 years avubthundhi bro Oka Office run cheyalani dream undhi kani Computer use cheyadam naku chethagale. Mi videos chosthunte nenu kooda nerchukovchu ani oka Hope vasthundhi. Thank u bro
Sir nenu oka office run cheayali ani anukuni. experience kosam li Oka company lo 1 Year contract base meedha job chesa eppudu break avuthunna.., nan office li ela run cheyli ani alochusthunappudu mi videos chusthunna. Heart fully cheputhunna sir Mi video chusthunte nenu pakka oka tension lekunda cool ga businesses cheyagalani anipisthundhi. Thank u sir
Video for attended sheet with salary is very good. But u can explain with short cut keys like ctrl+c, ctrl+d.what shot cut key for paste like above.💯✌🙏
Hi annaa... Chaala baagunnayi mee videos... Im subscribed now. అన్నా నేనిప్పుడే కంప్యూటర్ నేర్చుకోవడానికి ప్రయత్నిస్తున్నా నీ వీడియోస్ నాకు చాలా హెల్ప్ గా ఉన్నాయి. మీకు నిజంగా నా ధన్యవాదాలు. నాకు కంప్యూటర్ ఆపరేటర్ గా చాలా అవకాశాలు వచ్చాయి కానీ భయంతో వెళ్ళలేదు. మీరు నాకు మీ వీడియోస్ తో నాకు హెల్ప్ చేశారు.
🙏🙏🙏 Feeling confident by practicing these exercises
U have good sharing skills, it's nice to understand... keep it up sir. It will help to the learning people.👌👌👌👌👌👍👍
Thanks for watching. watch more videos. Like, Share & Subscribe.
Thank you.
@@learncomputerteluguchannel😢😢ok 😢sir thank you so 😢😢😢😢😢😢😢😢
Super mohan ji, I have just seen your video, it's really good for learners and understanding way you explained thank you sir
Chala baga chepparu okka sari vuntene Naku excell vacchesindhi super ga aradam iyyela chepparu thanks......👍 All the best broo
Hay sir I'm also today try Good experience
Hi, i want a video on excel which will allocate leads to employees evenly among the team. Condition is that leads of same location to be employees of same location by excel formulas.
Superb sir ilane manchi videos cheli nenu job chestunna time lekapoidi meeru utube chusi happy ga feel aiyya ippudu baga telusukunna superb sir inka manchi videos pettandi sir daily duty lo 1 half hours chustunna
Yours explanation is very clearly, neatly, and good voice. నా కు తెలియని విషయాలు చాలా తెలిసినవి. మీకు నా యొక్క ధన్యవాదాలు.
Welcome
Feeling Good to practice this more confedence
Very good
Use this formula to calculate easyly
=Countif(range,"P")
=Countif(range,"A")
Very nice I missed this in my career of 39 yrs
@@chandramohan1285 excuse Sir,
If you don't mind school accountant job ki main ga unde computer work n learning course suggest chesthara please
Excuse me Sir, if you don't mind school accountant job ki main ga unde computer work n learning course suggest chesthara please suggest
Yes
If u don't mind company accounting chapandi Sir
Thank you Mohan sir, iam learning computer with your excellent explanation
Good job sir..
Formulas use chesina daggara farmula bar lo values kanipimchela paste special chesi values vachela kuda cheppundalsindi ee video lo..
Sharing knowledge is a gret job.... Thanks a lot sir
Your welcome. Keep watching. Like & share
Superb broo...
@@learncomputerteluguchannel sir excel manchi grip ravadaniki ani days padatadii
Some times half day absent is also needed to calculate..Then how we have to manage it
Great Information through Telugu Language. God Blessings to you Sir. Please continue. 🙏
Thank you, I will
చాలా చాలా ధన్యవాదాలు అండి ఈ వీడియో ద్వారా నేను excel Basic Attendance నేర్చుకున్నాను
చాలా బావుంది సార్. కాని "Half Day " (H) కి కూడా ఎలా వెయ్యాలో చెప్పండి....ఒక సెల్ల్ లో "H" అని ఇస్తే అది కౌంట్ లోకి తీసుకోవడంలేదు.... Kindly let us know how to update half day attendance also.. Thanks
Thank you Murali Krishna. Keep Watching & Share My Videos.
Ok...But waiting to see your answer for my question ....
టోటల్ హాఫ్ డేస్ అని హెడ్డింగ్ పెట్టి countif ఫంక్షన్ ద్వార halfdays తెలుసోకోండి. తర్వాత హాఫ్ డే శాలరీ అమౌంట్ ఎంతో వేసి టోటల్ శాలరీ తో గుణించండి.
@@learncomputerteluguchannel super sir
supar ideas
+balu ala Thank you.
+LEARN COMPUTER TELUGU CHANNEL TnQ sir Nenu chesedhi cse kors computer VOC so
Nenu course nerchukunna gani vaallu fee kattinchukunnaru mundu em sariga cheppaledu datapro lo.. thanks bro clear ga explain chesinanduku...
Good Explanation sir. Thank you so much for Helping others with your Knowledge
Said,emlopyes,electro sacral ease,weatingce,
is there any difference for months having 31 days and feb. how should we calculate for the same?
నీ పేరు బాగుంది
@@saiduluk9720 Thank you
this queation no answer .pleas tell me answer
Very useful to us Excel commands is good.Everything is working practically thank you sir for great explanation.
Thank you... Keep watching.. don't forget Like Share my videos
Awesome bro... I am nenu miku fan ayyipoyanu. 💞
nice
+srinivas n Thank you. Keep watching.. Like & Share My Videos.
=COUNTIF(A3:AA3,"P") This is the formula to found present days (P). Plz try it.
Wow superb explanation.. Chaala easy ga Ardam Ipoyindi🙏🙏👌👌👌 Thnqq soo much sir
Keep watching.. don't forget Like Share this video.
LEARN COMPUTER TELUGU CHANNEL sure why not.. I'm very much impressed by watching all videos.. Just now I suggested to my frnd's
Sir 1/2 day yela calculate chestaru.& E Attendance sheet ni print ivvalante yela koddiga explain. Cheyandi sir please.
Sir 20 memberski Edina information oktimelo ela evali please explain cheyandi.
సార్ మీ యొక్క ఆన్లైన్ లో తరగతులు చాల చక్కగా అర్థం అయ్యేరీతిలొ చెప్తున్నారు, చాలా సంతోషంగా నేర్చుకుంటున్నాను. సార్ MS EXCEL లో ప్లైట్ సెల్స్ ఎలా చెయ్యాలో ఒక class తయారు చేయండి సార్.
మీరు చాలా భాగ అర్థమవుతున్నది. ధన్యవాదములు
Thank you. Keep watching. Like & Share my videos.
and over Time duty how to calculate in attendance
Can u say to how to letters prepare in Ms word
Many videos I saw but no one said how to prepair to letters
calculation of OTand duty differs from pvt to public sectors ,
its good for me
Sir job worked chapandi
Try this pass count =countif(h2:aj2,p) or absent count =countif(h2:aj2,a)
Sir, your way of explaining is too good !
I learnt more knowledge from us thanku so much sir..
Hello sir I want course complete certificate from you
Sir reply evandee
Sir anni names enduku sir simple ga konne tisukuni deep ga cheptey saripotundi ga sir chala time tisukuntunaru
Total Month salary sheet
Super bro ne videos chustu nenu roju practical chestunna bro ...meru chala baga cheptunnaru chala thanks bro...👍👍👍👍👍👌👌👌👌👌👍
Thank you, keep watching.. dont forge like & share the videos.
THANK YOU
VERY MUCH USEFUL TO WHO DON'T KNOW ABT THIS.........
Lot of thank you brother! Very useful video!
Hai bro...
U teaching was mind blowing nd it was smply osome...
I was never excepted lk dis bro nd
Say sum formulas shortcut method bro....
Thanks sir for your valuable time thanks so much evaru chudaru anukokandi nalantoniki okkanikaina use avtadhi thanks
Its too good.. I learn to you
Thank you Bro...
Please makes some videos on formulas
👌👌👌 feeling very well sir by practice u r classes
Hi brother. Thanks so much for your video. It helped me very much. I learned very well
Good job. Keep watching. Keep learning.
Wow . Nice explain in telugu .thank you sir
Sir,u r way of explaining toooo gud tq so much
Thanks so much for you sir really im so happy because ur best teacher of my life sir thq for going to god 🥰🥰🥰🥰
You're welcome
Thank q so much sir , I learn many things for your video may god bless u
Thank you keep watching don't forget like and share these videos.
Excellent explanation bro
Thank you
Thank you bayya..mi way of teaching is exellent.
Thank you keep watching... Plz Like & Share My Videos.
Meru chala baga chepptunnaru sir. Thank you sir
You're welcome
suuperb sir clear ga explain chesaru thank yo so much
Thank you so much sir.very useful information.Do more videos.Iam waiting for such videos.
Sure 👍
very nice explanation sir ....
nenu chala vedios chusaa excel gurinchi but naku sarigga ardham kaledu .....me vedio chusi chala impress ayyanu sir ....elane manchi vedios pettandi sir .....Excel lo formulas gurinchi vedios pettandi sir☺☺☺
ఎక్సెల్ కు సంబంధించిన అన్ని వీడియోస్ ఛానల్ playlist లో వుంటుంది. చూడండి
Nenu studies manesi 7 years avubthundhi bro
Oka Office run cheyalani dream undhi kani Computer use cheyadam naku chethagale. Mi videos chosthunte nenu kooda nerchukovchu ani oka Hope vasthundhi. Thank u bro
All the best
Love u Sir, You are amazing. Lakh Lakh Pranaam
Sir nenu oka office run cheayali ani anukuni. experience kosam li Oka company lo 1 Year contract base meedha job chesa eppudu break avuthunna.., nan office li ela run cheyli ani alochusthunappudu mi videos chusthunna.
Heart fully cheputhunna sir
Mi video chusthunte nenu pakka oka tension lekunda cool ga businesses cheyagalani anipisthundhi. Thank u sir
I saw your vedios it's very useful to me thank you sir
Chala bagundi sir ... Thank you so much
Brother nenu mi videos chusi practice chestunna super ga chepparu
Thanku
Sir super teaching.we learning clearly.thank u very much.
Thank u for ur comment.
Hi sir I'm very weak in computers bt when I'm listening ur class it'is very easy to learn and it will be helpful to me tq so much sir
Attendance sheet total GA oke page lo landscape mode lo ravali ante ela cheyyali.
Thank you brother anni videos chala baga cheptunnaru
Your teaching is excellent sir , Thank you
+Lalitha Kv Thank you. Keep watching. Plz Like & Share my videos.
Bro meru baga chayparu sir all the best for your channel
Sir thank you for nice info plz tell how to convert vertical items to horizontally in excel sheet
Simply superb explanation sir
Bro good information nenu practice chesthunna bro
Sir, we are learning.Thanks alot
Super sir
Vedeo chusi nenu intlone nerchukuntunna.
V nice video ..it will knowledge sharing info.....we need much more from u...do urs best
Thank you. Keep watching. Don't forget Like & Share videos.
Anna super ga cheppav
More than videos upload cheye
Video for attended sheet with salary is very good. But u can explain with short cut keys like ctrl+c, ctrl+d.what shot cut key for paste like above.💯✌🙏
Tq bro chala opigga arthavanthamga cheppinandhuku dhanya vadhamulu
welcome. keep watching..
Chaala tqs bro....Chaala clarity icharu
very useful information. keep posting videos like this
Thank you. Keep watching..
Chala baga chepparu sir..thanQ so much
feeling is very good sir ..thanking you sir
Thank you sir I am learning good experience
very very use full classes thanks sir ..
supper sir! AND thank u very much sir!
IM IMPROVE VERY WELL THIS VIDEO SIR!
Keep it up
Very very very useful information Thank U
Good sir chala baga cheparu simple methods lo
Thank you. keep Watching. Dont forget Like & Share the videos.
Super sir chala baga explain chesaru
Hi annaa... Chaala baagunnayi mee videos... Im subscribed now. అన్నా నేనిప్పుడే కంప్యూటర్ నేర్చుకోవడానికి ప్రయత్నిస్తున్నా నీ వీడియోస్ నాకు చాలా హెల్ప్ గా ఉన్నాయి. మీకు నిజంగా నా ధన్యవాదాలు. నాకు కంప్యూటర్ ఆపరేటర్ గా చాలా అవకాశాలు వచ్చాయి కానీ భయంతో వెళ్ళలేదు. మీరు నాకు మీ వీడియోస్ తో నాకు హెల్ప్ చేశారు.
Epudu nundi Mee as bhayam potundi. Don't worry. But systematic ga nerchukunnaru funding.
Eppati nundi meeku aa bhayam potundi. But systematic ga nerchukuntene...
Super sir and thank you mee valla ms excel nerchukunna
good. Thank you for watching. Keep Like & Share My Videos.
Nice brother easy and clear explanation Thank you
Thank you. Keep watching.. Like & Share.
Thank you sir it is useful for me
thanks anna, class lo kuda inta deatail ga chepparu. thank u anna
Keep watching. Don't forget to Like Share this channel..
Chala baga ardam ieyindi sir tq
Super sir very interesting
Okavela holidays vasthe
Good bagundhi...nice explanation
Thank you. Keep watching.. don't forget Like & Share this video.
Excellent chepparu sir superb sir tq....
Thank you.
I just interested to learn excel.. anyway thank u sir good explanation
చూస్తూవుండండి లెర్న్ కంప్యూటర్ తెలుగు ఛానల్ ని.. ధన్యవాదాలు🙏
Super bayya baagaa ardamaindi
Tq very much for this good information
Sir super ga ardham avthindhi sir
Thank you sir good explanation 🎉
Bro super bro
excel lo em daut lekunda chesav osm
nen niku fan aipoya
Thank you. Keep watching. Like & Share Videos.