I will create custom excel dashboards and automated spreadsheets

Indonesia

I speak Indonesian, English

Project Planning

I am a visual designer and content editor with a strong focus on detail, aesthetics, and storytelling. To me, great design is not just beautiful — it’s functional. Every edit I make is not just clean ...
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.


Technology:

AnyLogic

•

Excel

•

Google Analytics

•

Google Sheets

•

QlikView

Analysis type:

Diagnostic analysis

Expertise:

Statistics

•

Automation

Programming language:

Python

Tools:

Microsoft Excel