Comprehensive Excel Task Management System

Заказчик: AI | Опубликовано: 11.04.2026

I am looking for a highly skilled Excel expert to design and develop a comprehensive, user-friendly task management and performance tracking system in Microsoft Excel. The solution should allow efficient allocation, tracking, and reporting of staff tasks across departments, with both daily and monthly visibility. Key Requirements: 1. Task Allocation & Tracking Monthly view of all tasks assigned to each staff member Daily task tracking with progress updates Task allocation based on hourly workloads Track: Department Employee name Task description Standard task completion time Number of tasks assigned Tasks completed per day Pending task list 2. Performance Monitoring Automatic calculation of task completion percentage (daily & monthly) KPI tracking for each employee and department Monthly performance summary dashboard 3. Dashboard & Visual Reports Interactive monthly dashboard with: KPI achievement graphs Task completion trends Department-wise performance Clean and visually appealing charts and summaries 4. Leave Management Track leave accruals for each employee Monthly leave balance calculation Integration with task tracking (to reflect availability) 5. Task Management Features Ability for managers to: Add/edit tasks Include notes and comments per task Easy data entry with dropdowns and validations Automated calculations and minimal manual input