I will create custom excel dashboards and automated spreadsheets
About this Gig
Tired of tracking projects in messy spreadsheets? I'll give you a clean, ready-to-use Excel Project Tracker with an automatic dashboard, customized to the way your team works.
WHAT YOU GET
- Tracker sheet: project name, owner, status (Open / Progress / Revision / Done), dates, deadline, target vs. actual progress, notes
- Automatic columns: progress gap, days left, and a condition flag (Completed, Overdue, Behind target, Due soon, On track)
- Self-updating dashboard: status cards, summary by status and owner, nearest-deadline list, and 2 charts
- Dropdowns and input validation to keep data clean
- Built-in "How to use" guide
WHY IT WORKS
- No macros, no add-ins, no subscription. Just Excel
- Formulas only, so it recalculates instantly
- Room for 100 projects out of the box
PERFECT FOR
Office teams, operations, HR, finance, admin, small business owners and freelancers.
HOW IT WORKS
1. Pick a package and order
2. Send me your columns or branding (Standard and Premium)
3. I deliver your Excel file, ready to use
Questions? Message me before ordering.
Analysis type:
Diagnostic analysis
Expertise:
Statistics
•
Automation
Programming language:
Python
Tools:
Microsoft Excel

