Advanced Excel Task Management System

Job ID: 40364442

Budget: $30 – $250 USD

I am looking to develop a professional Excel-based system to manage and track daily, weekly, and monthly tasks across multiple departments within our company.

Departments include:
- Human Resources
- Finance
- Logistics
- Projects
- Administration

The system should be user-friendly and designed to support management-level monitoring and decision-making.

Key Requirements:

1. Main Dashboard:
- Total number of tasks
- Completed tasks
- Delayed tasks
- Tasks in progress
- Task distribution by department
- Completion rate per department

2. Central Task Input Sheet:
Should include the following fields:
- Department name
- Task title
- Short description
- Assigned person
- Start date
- End date
- Priority (High / Medium / Low)
- Status (Not Started / In Progress / Completed / Delayed / On Hold)
- Completion percentage
- Notes

3. Separate Sheets for Each Department:
Each department should have a dedicated view of their tasks.

4. Automated Reports:
- Daily report
- Weekly report
- Monthly report

5. Additional Features:
- Drop-down lists for consistency
- Conditional formatting for overdue tasks
- Filtering options by department, employee, and date
- Clean and professional layout
- Protection of formulas from accidental editing

Preferred Qualifications:
- Proven experience in Excel dashboards or task management systems
- Ability to design a management-level dashboard

Deliverables:
- Fully functional and professional Excel file
- User guide (PDF or short video)
- Willingness to make minor revisions after delivery