Advanced Excel Task Management System

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

Project ID: 40364442