Data entry
Budget: ₹100 – ₹400 INR
I need a precise, easy-to-maintain Excel workbook that lets me stay on top of project tasks. The sheet’s main job is straightforward task tracking, so please structure it with these essentials in mind:
• Task table where I can enter task name, owner, start date, due date, priority, and status.
• Drop-down list for status (Not Started / In Progress / Completed) and conditional formatting that flags overdue or soon-due tasks.
• Quick summary at the top that counts how many tasks are open, in progress, and completed.
• Filterable and sortable columns that remain intact if I add new rows or copy the file.
No macros or external add-ins—pure Excel formulas and standard features only, so the file stays sharable across our team’s Microsoft 365 environment.
Deliverable: one .xlsx file plus brief cell notes explaining any formulas or rules you set up. I’ll confirm everything works by adding sample tasks and checking that filters, counts, and formatting respond correctly.
• Task table where I can enter task name, owner, start date, due date, priority, and status.
• Drop-down list for status (Not Started / In Progress / Completed) and conditional formatting that flags overdue or soon-due tasks.
• Quick summary at the top that counts how many tasks are open, in progress, and completed.
• Filterable and sortable columns that remain intact if I add new rows or copy the file.
No macros or external add-ins—pure Excel formulas and standard features only, so the file stays sharable across our team’s Microsoft 365 environment.
Deliverable: one .xlsx file plus brief cell notes explaining any formulas or rules you set up. I’ll confirm everything works by adding sample tasks and checking that filters, counts, and formatting respond correctly.