calculate branch wise amount etc.... change PDF in excel -- 2
Budget: ₹1,250 – ₹2,500 INR
I need an Excel spreadsheet to effectively monitor and record employee attendance.
Key Features:
- Data Entry: The spreadsheet must accommodate employee name, ID, department, and dates of attendance/absence.
- Automated Status: It should have drop-down menus for selecting "Present," "Absent," or "On Leave."
- Summary Section: Formulas should calculate each employee's total working days, days present, absent, and on leave.
- Conditional Formatting: It must highlight absences that exceed five in a month.
- Search Functionality: Include filters to search by date range.
- Error Validation: Use data validation rules to prevent duplicate entries.
The ideal freelancer for this project should be proficient in Excel and have prior experience creating similar data tracking tools. I'm looking for someone who can help me build this efficiently and effectively.
Key Features:
- Data Entry: The spreadsheet must accommodate employee name, ID, department, and dates of attendance/absence.
- Automated Status: It should have drop-down menus for selecting "Present," "Absent," or "On Leave."
- Summary Section: Formulas should calculate each employee's total working days, days present, absent, and on leave.
- Conditional Formatting: It must highlight absences that exceed five in a month.
- Search Functionality: Include filters to search by date range.
- Error Validation: Use data validation rules to prevent duplicate entries.
The ideal freelancer for this project should be proficient in Excel and have prior experience creating similar data tracking tools. I'm looking for someone who can help me build this efficiently and effectively.