Excel Productivity Dashboard Automation
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I’m looking to add two Excel automation specialists to my agency so we can turn raw task-tracking spreadsheets into clear, interactive dashboards that instantly show how the team is performing. Most of our client files arrive as regular Excel workbooks (sometimes Google Sheets), and they all ask the same questions: Who’s on schedule? Which milestones are slipping? Where are our productivity gaps?
Here’s what you’ll be doing with each project:
• Build an automated dashboard that updates at the click of Refresh, summarising workload, completion status, time spent, and overall productivity.
• Keep the layout clean and agency-branded so we can hand it straight to the client.
• Provide a one-page setup guide so any analyst on our side can maintain the file.
Advanced formulas, Power Query, pivot tables, VBA macros, or Google Apps Script (when Sheets is involved) are all fair game—as long as the end user never touches code.
If you have a track record of transforming spreadsheets into real-time insights, I’d love to see a sample or brief walkthrough of a similar dashboard you’ve built. Let’s make our clients’ teamwork data instantly actionable.
Payment system.. commission based
Here’s what you’ll be doing with each project:
• Build an automated dashboard that updates at the click of Refresh, summarising workload, completion status, time spent, and overall productivity.
• Keep the layout clean and agency-branded so we can hand it straight to the client.
• Provide a one-page setup guide so any analyst on our side can maintain the file.
Advanced formulas, Power Query, pivot tables, VBA macros, or Google Apps Script (when Sheets is involved) are all fair game—as long as the end user never touches code.
If you have a track record of transforming spreadsheets into real-time insights, I’d love to see a sample or brief walkthrough of a similar dashboard you’ve built. Let’s make our clients’ teamwork data instantly actionable.
Payment system.. commission based
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.