Advanced Project Tracking Spreadsheet Design

Job ID: 37884602

Budget: $30 – $250 USD

I am seeking a skilled Excel specialist to create a sophisticated and intuitive spreadsheet that serves as a project management tool.

The spreadsheet must include the following specific features:

- Project Tracking: The main feature I need is the ability to track the progress of multiple projects.

Main Aspects:

- Milestone Achievements: The spreadsheet must enable tracking of various project milestones. It should notify when a milestone is due and when it is achieved.

- Task Deadlines: Deadlines for each task must be clearly displayed and flag whenever a task deadline is approaching or missed.

Visual Representation:

- Progress Bar: The progress of each milestone contained within a project should be visually represented using a progress bar.

- Color-Coded Cells: Milestones and tasks should have color-coded cells that reflect their status.

Ideal candidates should have advanced Excel knowledge, experience in project management, and the ability to interpret project tracking needs into a usable tool. Please provide examples of similar work in your proposal.
Related categories: Data Entry Excel Visual Basic for Apps