03 How to Make Attendance Salary Sheet in Excel | Excel Practice Tutorials in Telugu |LEARN COMPUTER

[@rojasreenath6242]

Use this formula to calculate easyly =Countif(range,"P") =Countif(range,"A")

[@chandramohan1285]

Very nice I missed this in my career of 39 yrs

[@sathwikanancy9623]

@@chandramohan1285 excuse Sir, If you don't mind school accountant job ki main ga unde computer work n learning course suggest chesthara please

[@sathwikanancy9623]

Excuse me Sir, if you don't mind school accountant job ki main ga unde computer work n learning course suggest chesthara please suggest

[@karthikvarma4717]

Yes

[@ajayhoney5035]

If u don't mind company accounting chapandi Sir

[@kumarjanardhan888]

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

[@sisira_reddy8369]

U have good sharing skills, it's nice to understand... keep it up sir. It will help to the learning people.👌👌👌👌👌👍👍

[@learncomputerteluguchannel]

Thanks for watching. watch more videos. Like, Share & Subscribe. Thank you.

[@santhoshkumar8168]

​@@learncomputerteluguchannel😢😢ok 😢sir thank you so 😢😢😢😢😢😢😢😢

[@ramprasad187]

Yours explanation is very clearly, neatly, and good voice. నా కు తెలియని విషయాలు చాలా తెలిసినవి. మీకు నా యొక్క ధన్యవాదాలు.

[@learncomputerteluguchannel]

Welcome

[@kotirao9139]

Feeling Good to practice this more confedence

[@vinodkaranam5683]

Very good

[@TonyStark-xb7pe]

Chala baga chepparu okka sari vuntene Naku excell vacchesindhi super ga aradam iyyela chepparu thanks......👍 All the best broo

[@bhaskarkonamki5127]

🙏🙏🙏 Feeling confident by practicing these exercises

[@venky9007]

Nenu course nerchukunna gani vaallu fee kattinchukunnaru mundu em sariga cheppaledu datapro lo.. thanks bro clear ga explain chesinanduku...

[@ahamadkhanpattan5440]

Sharing knowledge is a gret job.... Thanks a lot sir

[@learncomputerteluguchannel]

Your welcome. Keep watching. Like & share

[@MS143MS]

Superb broo...

[@vinayragolu4375]

@@learncomputerteluguchannel sir excel manchi grip ravadaniki ani days padatadii

[@hariuppi4794]

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

[@learncomputerteluguchannel]

All the best

[@srikanthgaddam7174]

Hay sir I'm also today try Good experience

[@adavibidda9394]

సార్ మీ యొక్క ఆన్లైన్ లో తరగతులు చాల చక్కగా అర్థం అయ్యేరీతిలొ చెప్తున్నారు, చాలా సంతోషంగా నేర్చుకుంటున్నాను. సార్ MS EXCEL లో ప్లైట్ సెల్స్ ఎలా చెయ్యాలో ఒక class తయారు చేయండి సార్.

[@kantharaotarala658]

=COUNTIF(A3:AA3,"P") This is the formula to found present days (P). Plz try it.

[@anjametirameshbabu1225]

మీరు చాలా భాగ అర్థమవుతున్నది. ధన్యవాదములు

[@learncomputerteluguchannel]

Thank you. Keep watching. Like & Share my videos.

[@murali121]

చాలా బావుంది సార్. కాని "Half Day " (H) కి కూడా ఎలా వెయ్యాలో చెప్పండి....ఒక సెల్ల్ లో "H" అని ఇస్తే అది కౌంట్ లోకి తీసుకోవడంలేదు.... Kindly let us know how to update half day attendance also.. Thanks

[@learncomputerteluguchannel]

Thank you Murali Krishna. Keep Watching & Share My Videos.

[@murali121]

Ok...But waiting to see your answer for my question ....

[@learncomputerteluguchannel]

టోటల్ హాఫ్ డేస్ అని హెడ్డింగ్ పెట్టి countif ఫంక్షన్ ద్వార halfdays తెలుసోకోండి. తర్వాత హాఫ్ డే శాలరీ అమౌంట్ ఎంతో వేసి టోటల్ శాలరీ తో గుణించండి.

[@tharakaramireddy1060]

@@learncomputerteluguchannel super sir

[@kishoreteluguvlogs7325]

Super bro ne videos chustu nenu roju practical chestunna bro ...meru chala baga cheptunnaru chala thanks bro...👍👍👍👍👍👌👌👌👌👌👍

[@learncomputerteluguchannel]

Thank you, keep watching.. dont forge like & share the videos.

[@sasimca39]

Some times half day absent is also needed to calculate..Then how we have to manage it

[@sureshkumarpangi7619]

Hi annaa... Chaala baagunnayi mee videos... Im subscribed now. అన్నా నేనిప్పుడే కంప్యూటర్ నేర్చుకోవడానికి ప్రయత్నిస్తున్నా నీ వీడియోస్ నాకు చాలా హెల్ప్ గా ఉన్నాయి. మీకు నిజంగా నా ధన్యవాదాలు. నాకు కంప్యూటర్ ఆపరేటర్ గా చాలా అవకాశాలు వచ్చాయి కానీ భయంతో వెళ్ళలేదు. మీరు నాకు మీ వీడియోస్ తో నాకు హెల్ప్ చేశారు.

[@learncomputerteluguchannel]

Epudu nundi Mee as bhayam potundi. Don't worry. But systematic ga nerchukunnaru funding.

[@learncomputerteluguchannel]

Eppati nundi meeku aa bhayam potundi. But systematic ga nerchukuntene...

[@bollina07]

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.

[@hariuppi4794]

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

[@kundanamnimitha3780]

is there any difference for months having 31 days and feb. how should we calculate for the same?

[@saiduluk9720]

నీ పేరు బాగుంది

[@kundanamnimitha3780]

@@saiduluk9720 Thank you

[@dsyblogs3413]

this queation no answer .pleas tell me answer

[@sivakumar-gg8cz]

Try this pass count =countif(h2:aj2,p) or absent count =countif(h2:aj2,a)

[@yousefgo7603]

Attendance with salary sheet gurunchi mottam chusi maku chala santosham kaligindi sir ekkada waka vishayam na idea entante absent simbol A write chesinappuda automatic ga color rawalante ela cheyyalo cheppa galara please nenu mee daggara excel course chala telusu ko walanukuntunna pu me cheppe speech chala bagundy thank you so much.

[@singarajrakesh6864]

Sir 1/2 day yela calculate chestaru.& E Attendance sheet ni print ivvalante yela koddiga explain. Cheyandi sir please.

[@gayathritamiri5089]

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☺☺☺

[@learncomputerteluguchannel]

ఎక్సెల్ కు సంబంధించిన అన్ని వీడియోస్ ఛానల్ playlist లో వుంటుంది. చూడండి

[@margamsandhya9232]

Sir 20 memberski Edina information oktimelo ela evali please explain cheyandi.

[@rajaniravi5685]

The Highlight of your video is uploading the Practice sheet. No channel do like this. Thank you very much.

[@Manchala1561]

Sir anni names enduku sir simple ga konne tisukuni deep ga cheptey saripotundi ga sir chala time tisukuntunaru

[@pittaissaku7734]

Total Month salary sheet

[@dasarisriramulu2144]

చాలా చాలా ధన్యవాదాలు అండి ఈ వీడియో ద్వారా నేను excel Basic Attendance నేర్చుకున్నాను

[@baluala4405]

supar ideas

[@learncomputerteluguchannel]

+balu ala Thank you.

[@harishilovesong4492]

+LEARN COMPUTER TELUGU CHANNEL TnQ sir Nenu chesedhi cse kors computer VOC so

[@p.venkataratnam4446]

video fine. While teaching, you should tell the months at actuals only. January is with 31 days. Your video and telling is fine.

[@learncomputerteluguchannel]

Thank you.

[@dhinakaraprasad4275]

Said,emlopyes,electro sacral ease,weatingce,

[@durgamrajeshwer7996]

Brother nenu mi videos chusi practice chestunna super ga chepparu

[@learncomputerteluguchannel]

Thanku

[@cp01aaccounts29]

and over Time duty how to calculate in attendance

[@alimuhammed397]

Can u say to how to letters prepare in Ms word

[@alimuhammed397]

Many videos I saw but no one said how to prepair to letters

[@dvrm13579]

calculation of OTand duty differs from pvt to public sectors ,

[@pittalakumardeekshitha882]

its good for me

[@madhurakavidinakar3001]

Sir job worked chapandi

[@saicharansanju3434]

Wow superb explanation.. Chaala easy ga Ardam Ipoyindi🙏🙏👌👌👌 Thnqq soo much sir

[@learncomputerteluguchannel]

Keep watching.. don't forget Like Share this video.

[@saicharansanju3434]

LEARN COMPUTER TELUGU CHANNEL sure why not.. I'm very much impressed by watching all videos.. Just now I suggested to my frnd's

[@swamys7601]

Hello sir I want course complete certificate from you

[@swamys7601]

Sir reply evandee

[@svenki301]

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

[@comedyclips5282]

Attendance sheet total GA oke page lo landscape mode lo ravali ante ela cheyyali.

[@d.lokanadharaju6546]

Great Information through Telugu Language. God Blessings to you Sir. Please continue. 🙏

[@learncomputerteluguchannel]

Thank you, I will

[@sai-qj9ly]

Sir chala బాగుంది సూపర్ sir,half-day attendance unte ela sir

[@lakshmanvaduguri8064]

DANYAVADALU ayya maaku Chala Baga upayogapadindhi

[@mynuddin222]

Thank you bayya..mi way of teaching is exellent.

[@learncomputerteluguchannel]

Thank you keep watching... Plz Like & Share My Videos.

[@kranthikumar2549]

Super Anna.. But present, absent tharvatha overtime duty ki Formula chepandi konchem

[@chindhamadhar3659]

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....

[@dharani2703]

Chala bagundi sir ... Thank you so much

[@ronankirammohanrao3553]

Super mohan ji, I have just seen your video, it's really good for learners and understanding way you explained thank you sir

[@krishnakishore7848]

good to learn. title kuda ani pages ke ravalantay aah concept chepandi bro

[@Ranjithbommarathi]

Thanks sir for your valuable time thanks so much evaru chudaru anukokandi nalantoniki okkanikaina use avtadhi thanks

[@santoshim7726]

Good Explanation sir. Thank you so much for Helping others with your Knowledge

[@PraveenKumar-hf7gh]

Meru chala baga chepptunnaru sir. Thank you sir

[@learncomputerteluguchannel]

You're welcome

[@govindjadav95]

Super sir Vedeo chusi nenu intlone nerchukuntunna.

[@nagendraraodasari8337]

thanks anna, class lo kuda inta deatail ga chepparu. thank u anna

[@learncomputerteluguchannel]

Keep watching. Don't forget to Like Share this channel..

[@sammaiahv2672]

Anna super ga cheppav More than videos upload cheye

[@chandrachandu8526]

Thanks so much for you sir really im so happy because ur best teacher of my life sir thq for going to god 🥰🥰🥰🥰

[@learncomputerteluguchannel]

You're welcome

[@koteswararaokoti8201]

Good job sir.. Formulas use chesina daggara farmula bar lo values kanipimchela paste special chesi values vachela kuda cheppundalsindi ee video lo..

[@nelsonnelaparthi999]

Bro meru baga chayparu sir all the best for your channel

[@lasyan-vx9hi]

Sir,u r way of explaining toooo gud tq so much

[@kvishal3580]

Chaala tqs bro....Chaala clarity icharu

[@travelwithshaiks8712]

Good sir chala baga cheparu simple methods lo

[@learncomputerteluguchannel]

Thank you. keep Watching. Dont forget Like & Share the videos.

[@annavenaprashanth377]

Bro good information nenu practice chesthunna bro

[@lalithakv8345]

Your teaching is excellent sir , Thank you

[@learncomputerteluguchannel]

+Lalitha Kv Thank you. Keep watching. Plz Like & Share my videos.

[@friendscomputerzone8967]

Bro super bro excel lo em daut lekunda chesav osm nen niku fan aipoya

[@learncomputerteluguchannel]

Thank you. Keep watching. Like & Share Videos.

[@venkyvenky7503]

Thank you Mohan sir, iam learning computer with your excellent explanation

[@rameshdhanyakula6039]

Thank you so much sir.very useful information.Do more videos.Iam waiting for such videos.

[@learncomputerteluguchannel]

Sure 👍

[@pravinshahapure2936]

Hello sir , I really appreciate your teaching style but i'm belongs to maharashtra so i don't know telugu. this videos available in either English OR Hindi then its easy for for understanding to us.

[@learncomputerteluguchannel]

Thank you for watching. but i dont know hindi & eng clearyly. Keep watching...

[@NadipiposhettyBuddabali]

Hlo sir Thank you for your teaching Am learning ms office in mobile Sir if you don't mind please Inka computer course mobile lo evaina apps to practice cheyyacha

[@supriyamakkala6331]

Super sir very interesting Okavela holidays vasthe

[@sakilejayalakshmi8412]

Thank you brother anni videos chala baga cheptunnaru

[@rupaivaturi9958]

I saw your vedios it's very useful to me thank you sir

[@jenimajenijeni1085]

Tq sr 4 ur explanation. Nd also explain how to calculate with 1/2 day.

[@learncomputerteluguchannel]

Thank you. keep watching. Like & Share videos.

[@uppi3238]

I don't know

[@artistprasadtelugu3755]

Super bayya baagaa ardamaindi

[@softwaretrainingvideostelu7865]

Very useful to us Excel commands is good.Everything is working practically thank you sir for great explanation.

[@learncomputerteluguchannel]

Thank you... Keep watching.. don't forget Like Share my videos

[@krishnappamv5123]

I can understand but we change days easily so we calculate easily thank you sir we native place tamilnadu state district krishnagiri taluk hosur but i don't know English flulantily

[@chanduchandu9548]

Tq bro chala opigga arthavanthamga cheppinandhuku dhanya vadhamulu

[@learncomputerteluguchannel]

welcome. keep watching..

[@sanathanacreations3661]

Wow . Nice explain in telugu .thank you sir

[@vijayayadavlaxmiyadav6924]

TQ sir...nenu nerchukunttunaa

[@luckylakshmi8417]

Chala Baga chepparu Baga ardam indhi

[@learncomputerteluguchannel]

Thank you. Keep watching. don't forget Like & Share the videos.

[@kulasekharp1921]

V nice video ..it will knowledge sharing info.....we need much more from u...do urs best

[@learncomputerteluguchannel]

Thank you. Keep watching. Don't forget Like & Share videos.

[@khabib8313]

sir mee attandence video chala bagundi naku chinna dout undi formulas bar insert function undi daanni ela use cheyaly

[@vteju8188]

Chala baga cheptunaru sir

[@learncomputerteluguchannel]

Thank you. Keep watching.

[@raghutalla1251]

Sir, It's an easy tutorial for beginners and experts. So I am Happy to clarify doubts of Attendance sheet with salary

[@raghutalla1251]

Please tell more Examples

[@lakakulakash1162]

Sir super teaching.we learning clearly.thank u very much.

[@learncomputerteluguchannel]

Thank u for ur comment.

[@talarijagan6794]

Sir super ga ardham avthindhi sir

[@rajaramsuresh2795]

Very very very useful information Thank U

[@ngk5014]

Chala baga ardam ieyindi sir tq

[@kakarema9668]

Good explanation, it is very easy to learn to me.

[@learncomputerteluguchannel]

Thank you

[@navyaangel4958]

sir me classes anni chala baunnai sir i lik vey much

[@learncomputerteluguchannel]

Thank you. Keep watching. Don't forget like, share.

[@akhiledits7284]

Super sir and thank you mee valla ms excel nerchukunna

[@learncomputerteluguchannel]

good. Thank you for watching. Keep Like & Share My Videos.

[@nareshbattini5351]

Super Anna I want this type of explanation pls more videos

[@learncomputerteluguchannel]

Watch more videos on "Learn computer Telugu channel"

[@rajkumarjarpula9249]

Chala baga chepparu sir..thanQ so much

[@durgaprasadvittanala5503]

Super sir chala baga explain chesaru

[@santhoshbhonagiri9939]

Excellent chepparu sir superb sir tq....

[@learncomputerteluguchannel]

Thank you.

[@manishupadhyay7731]

Love u Sir, You are amazing. Lakh Lakh Pranaam

[@ManiJavvdi]

Sir all formulas telugu explained cheyandi one video cheyandi sir sum all function if function count and all functions telugu lo a time lo formulas tesukovali ani cheyandi sir

[@shaikriyas4760]

Anna namaste anna ekkadanna nu entha risk work ki solution ecchav nu nu super anna

[@anandpaga2380]

Excellent vedio. Very useful

[@mohanrao9408]

Good bagundhi...nice explanation

[@learncomputerteluguchannel]

Thank you. Keep watching.. don't forget Like & Share this video.

[@bollarammahesh8142]

Super annnna This is mahesh i am big fan of u

[@learncomputerteluguchannel]

Thank you. Keep watching. Like. & Share my videos.

[@arunaanala4201]

Chala baga chebutunaru bro

[@dileep243]

Super ga cheppavu bro

[@Trytosomethingnew]

Super super super very useful to us tq so much brother

[@learncomputerteluguchannel]

Keep watching. Don't forget Like & Share videos.