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

నమస్కారం.. ఈ ట్యుటోరియల్ నుండి "యమ్ స్ ఎక్సెల్ " లో Practical Exercises నేర్చుకోబోతున్నారు. కావున వీడియో ని పూర్తిగా చూసి నేర్చుకోగలరు. నచ్చితే like మరియు share చేయగలరు. ధన్యవాదాలు.
Friends..in this tutorial i will explained Ms Excel 2007 Practical Tutorials with Real Examples. If you like this video please hit "Like-Share-Subscribe. Thank you.
Topics In This Tutorial:
How to Make Attendance Salary Sheet in Excel 2007 in Telugu using count if function
````````````````````````````````````````````````````````````````````````````````````````````````
Download Excel File :
www.mediafire....
```````````````````````````````````````````````````````````````````````````````````````````````
Apply Now! 👇🏿
📌𝗕𝘂𝘆 𝗔𝘅𝗶𝘀 𝗖𝗿𝗲𝗱𝗶𝘁 𝗖𝗮𝗿𝗱 - ekaro.in/enkr2...
•Buy One Get One free on movie tickets with Paytm
•40% off on food delivery with Swiggy
•Discounts on Ajio shopping and many more
📌𝗔𝘅𝗶𝘀 𝗙𝗹𝗶𝗽𝗸𝗮𝗿𝘁 𝗖𝗿𝗲𝗱𝗶𝘁 𝗖𝗮𝗿𝗱 - ekaro.in/enkr2...
📌𝗦𝗕𝗜 𝗦𝗶𝗺𝗽𝗹𝘆 𝗖𝗹𝗶𝗰𝗸 𝗖𝗿𝗲𝗱𝗶𝘁 𝗖𝗮𝗿𝗱 - ekaro.in/enkr2...
~~:Microsoft Excel Exercises:~~ 🎯
▶️Make Attendance Salary Sheet - • 03 How to Make Attenda...
▶️Bill Entry in Excel - • Bill Entry in Excel |...
▶️Excel VLookup Function with Example - • Excel VLookup Function...
▶️Make CCE Promotion Register - • How To Make CCE Promot...
▶️Prepare Employee Salary Pay Slip - • 13 How To Prepare Empl...
▶️Make Salary Sheet - • 01 How to Make Salary ...
▶️Make Computerized Invoice - • 17 Make Computerized I...
▶️Make Financial Data - • 04 How to Make Financi...
▶️Make Inventory Stock Details - • 02 How to Make Invento...
➡️Ms Excel 2007 Tutorials in Telugu :
• Ms Excel in Telugu Par...
➡️Advanced Ms Excel 2007 Tutorials in Telugu:
• Ms Excel in Telugu Par...
All Computer Course Tutorials Link of This Channel Available In This Below:
Computer Basics, Windows 7 Operating System, Microsoft Word, Microsoft Excel, Microsoft Power Point, Internet Tips, Computer Tips etc.. click this link...
/ @learncomputerteluguch...
Join In To Facebook:
/ learncomputerintelugu
Thank you.
---------------------
#excel #learnexcelintelugu #msexcel #excelintelugu
Tags:
countif,sumif,count,excel funcitons,formulas,excel practice tutorial,in telugu,exel tutorials,excel exercises,telugu video tutorials,how to make,excel 2007,ms excel in telugu,real time practicles,ms excel exercises for students,assignments,microsoft excel exercises,excel practice exercises,ms excel 2007 in telugu,computer basics in telugu,paytm telugu,learn computer in telugu,online training in telugu,learn ms excel,2016,how to do,advanced ms excel
Disclaimer
-------------------------------------------------------------------------
Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.

[@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

[@PraveenKumar-hf7gh]

Meru chala baga chepptunnaru sir. Thank you sir

[@learncomputerteluguchannel]

You're welcome

[@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

[@anjametirameshbabu1225]

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

[@learncomputerteluguchannel]

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

[@bhaskarkonamki5127]

🙏🙏🙏 Feeling confident by practicing these exercises

[@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

[@srikanthgaddam7174]

Hay sir I'm also today try Good experience

[@adavibidda9394]

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

[@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

[@TonyStark-xb7pe]

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

[@sasimca39]

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

[@lalithakv8345]

Your teaching is excellent sir , Thank you

[@learncomputerteluguchannel]

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

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

[@d.lokanadharaju6546]

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

[@learncomputerteluguchannel]

Thank you, I will

[@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

[@ronankirammohanrao3553]

Super mohan ji, I have just seen your video, it's really good for learners and understanding way you explained thank you 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

[@venky9007]

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

[@singarajrakesh6864]

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

[@chanduchandu9548]

Tq bro chala opigga arthavanthamga cheppinandhuku dhanya vadhamulu

[@learncomputerteluguchannel]

welcome. keep watching..

[@kantharaotarala658]

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

[@dasarisriramulu2144]

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

[@sivakumar-gg8cz]

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

[@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

[@dhinakaraprasad4275]

Said,emlopyes,electro sacral ease,weatingce,

[@lakshmanvaduguri8064]

DANYAVADALU ayya maaku Chala Baga upayogapadindhi

[@baluala4405]

supar ideas

[@learncomputerteluguchannel]

+balu ala Thank you.

[@harishilovesong4492]

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

[@dharani2703]

Chala bagundi sir ... Thank you so much

[@margamsandhya9232]

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

[@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

[@Manchala1561]

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

[@pittaissaku7734]

Total Month salary sheet

[@venkyvenky7503]

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

[@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

[@mynuddin222]

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

[@learncomputerteluguchannel]

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

[@swamys7601]

Hello sir I want course complete certificate from you

[@swamys7601]

Sir reply evandee

[@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 లో వుంటుంది. చూడండి

[@durgaprasadvittanala5503]

Super sir chala baga explain chesaru

[@durgamrajeshwer7996]

Brother nenu mi videos chusi practice chestunna super ga chepparu

[@learncomputerteluguchannel]

Thanku

[@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

[@sanathanacreations3661]

Wow . Nice explain in telugu .thank you sir

[@nareshd2093]

Chala cliear ga chepav sir thanks a lot

[@travelwithshaiks8712]

Good sir chala baga cheparu simple methods lo

[@learncomputerteluguchannel]

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

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

[@artistprasadtelugu3755]

Super bayya baagaa ardamaindi

[@nelsonnelaparthi999]

Bro meru baga chayparu sir all the best for your channel

[@santoshim7726]

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

[@Ranjithbommarathi]

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

[@HHaribabu-rx7uk]

I am learning through video

[@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

[@arunaanala4201]

Chala baga chebutunaru bro

[@annavenaprashanth377]

Bro good information nenu practice chesthunna bro

[@luckylakshmi8417]

Chala Baga chepparu Baga ardam indhi

[@learncomputerteluguchannel]

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

[@vijaypoorni8314]

Tq very much for this good information

[@cjanardhan7460]

Thanks sir

[@talarijagan6794]

Sir super ga ardham avthindhi sir

[@koteswararaokoti8201]

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

[@sakilejayalakshmi8412]

Thank you brother anni videos chala baga cheptunnaru

[@SANDEEPLAL8333]

NYC EXPLANATION 👌

[@rameshsure1705]

Sir baga explain chesaru sir

[@dileep243]

Super ga cheppavu bro

[@evangelinepinky825]

Good explanation we learn it

[@santhoshbhonagiri9939]

Excellent chepparu sir superb sir tq....

[@learncomputerteluguchannel]

Thank you.

[@krishnaballanki4869]

Thank you sir good explanation 🎉

[@lasyan-vx9hi]

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

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

[@vijayayadavlaxmiyadav6924]

TQ sir...nenu nerchukunttunaa

[@thankuall2804]

Super super super very useful to us tq so much brother

[@learncomputerteluguchannel]

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

[@rajaniravi5685]

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

[@zainmohammad8520]

THANK YOU VERY MUCH USEFUL TO WHO DON'T KNOW ABT THIS.........

[@govindjadav575]

Super sir Vedeo chusi nenu intlone nerchukuntunna.

[@rangaswamy4249]

Very useful to me thankyou sir

[@kvishal3580]

Chaala tqs bro....Chaala clarity icharu

[@vijayradhika9287]

tq soo much sir chala clear ga chepparu tq soo much

[@learncomputerteluguchannel]

Welcome

[@vsuribabu9813]

Thanks for good information

[@mohanrao9408]

Good bagundhi...nice explanation

[@learncomputerteluguchannel]

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

[@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

[@ramucreatedchanalmrgp1045]

Thanks Anna edi naku Chala us avutundi

[@learncomputerteluguchannel]

Welcome. Do well practice

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

[@govindamuda8308]

Really very good service

[@saisripada9857]

Sir great explanation

[@navyaangel4958]

sir me classes anni chala baunnai sir i lik vey much

[@learncomputerteluguchannel]

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

[@santhubommena5946]

Excellent sir ....tq u tq u so much sir

[@kilarichamani5274]

It's very helpful sir

[@srikanthsri8327]

Tqsm sir I learned a lot

[@gollapallikishore9048]

Chala bagundi bro super

[@nareshbattini5351]

Super Anna I want this type of explanation pls more videos

[@learncomputerteluguchannel]

Watch more videos on "Learn computer Telugu channel"

[@rupaivaturi9958]

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

[@kasurajyalakshmi1183]

Nice chala thanks sir

[@sweetymani5113]

Good explanation and tq sir

[@rajkumarjarpula9249]

Chala baga chepparu sir..thanQ so much

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

[@rameshdhanyakula6039]

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

[@learncomputerteluguchannel]

Sure 👍

[@sammaiahv2672]

Anna super ga cheppav More than videos upload cheye

[@rajaramsuresh2795]

Very very very useful information Thank U

[@manijamanija9481]

Tq very much sir........ It helped me a lot

[@learncomputerteluguchannel]

Most welcome

[@tejad4666]

Excellent sir and tq

[@manishupadhyay7731]

Love u Sir, You are amazing. Lakh Lakh Pranaam

[@kolanbharathkumar601]

Tqs sir challa easy ga chepparu

[@learncomputerteluguchannel]

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