How to Create an Automated Attendance Sheet with Salary Calculation in Excel

How to Create an Automated Attendance Sheet with Salary Calculation in Excel
This video explains how you can prepare Fully Automated Attendance Sheet in Excel. It is also explained that how to prepare Salary Calculation Sheet along with attendance sheet.

So watch the video and if you find it valuable please subscribe our channel:

You can download our file:
==============================
==============================

Related Videos:
1. Drop Down List In Excel Hindi
2. If Function in Excel in Hindi
3. COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi

---------------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel

2. Advanced Excel Formulas

3. Awesome MS Word Videos

Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.

#attendancesheet
#powerexbyjitendra
#excel

Subscribe on Telegram:

Contact Us:

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, and research.

Fair use is a permitted by copyright statute that might otherwise be infringing.

Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[maeraquiza]

I couldn’t understand a word but I managed to make this whole thing. Thank you! Very easy step by step process

[arunpatel]

Sab alag aur sabse saral aap ne explain kiya hai... Thxs for support

[dhanarajsivagnanam]

Very good work, even i don't know hindi, but i understood your guidelines. Thank you

[puvbkvm]

Awesome video. But The values entered for a month will remain same even if we change the month, right ? Is there any way to make the cell values dynamic like if we change the month, also need the entries to be updated for respective month. Thank you again for the video !

[santhaligirl__]

Sir, I need your help. Maine September month ki attendance bnaya to wo attendance saare month me show ho rha hai. Aesa kyun sir. Please help

[WasimKhan-mgfm]

Absolute teaching skills thanks very much

[sanjaysingh-unrf]

Sir.... Your teaching method is very nice.. 🙏🙏🙏

[vlogwithyatishkandhari]

Sir, excellent video. Sir also tell in case employee is on half day casual leave, then how to calculate attendance

[anupganguly]

Bhai.. agar Saturday nd Sunday dono off ho to data validation ke formula kaise use kare ..plz suggest..

[kavindrasingh]

jitendra ji maan lo kisi employee ki joining hi 15th of that month hui to usey 15th se pehle aaye week offs ki salary kyu denge. aur na dene ke liye formula kaise work karega fir ?

[anilscorner]

Good info agar humne 26 se 25 tak ki dates ke andar ki time sheet banani ho tab koun sa formula use karna hoga

[amirakram]

Gr8 superb is attandance sheet mn agr date wise attandance alter krny k liay koi data entry form ki video bna dain tu kamal ho jy thanks

[academyoflearning]

Thank you for a such nice vedio. But if u don't mind how can we add gazetted holidies like sunday.

[Urvii_fullylive]

Really helped me a lot and the way you explained everything was so clear

[bittu]

Thank you very much here are some new functions for me.

[dilipchauhan]

I impressed with your video..i like it.

[lalitpatil]

Agar kisi ek date ko holiday hai to uska total days add hona chahiye yes or no, agar ha to uska formula kaise hona chahiye... please bataye

[kyfparacha]

Nice vdo. I have a question. The month that are 31 and enter data, my sheet is working. But when I go to the month with less then 31 days, my entries do not delete automatically, How to fix this issue.🤔

[Amarjit]

Excellent but if how to Holidays can be applied like 15 Aug, 26 Jan etc

[prateekgoyal-dqzx]

Plz tell aap months drop down box banane k liye last cell XFD3 per kaise gye.