Contact person: Multi-Project Management Excel Workbook Development

Phone:Show

Email:Show

Location: Malé, Maldives

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I am looking for an experienced Excel developer to create a project management workbook that allows me to manage multiple projects in a single sheet and have a dashboard sheet to track all projects in one place.

Requirements:

Ability to track:
Project name & ID
Tasks & subtasks
Timeline (start date, end date, and duration)
Task status (e.g., Pending, In Progress, Completed)
Costing & revenue
Progress percentage per task and per project
Dashboard:
Summary of all projects in a single sheet
Graphs/charts for progress, cost vs revenue, and timelines
Automatic updates from the project data sheet
Clean, professional, and user-friendly design
Preferably automated with formulas, pivot tables, and/or macros where needed

Deliverables:
Excel workbook with:
Project Sheet – for entering and updating multiple projects with all required details
Dashboard Sheet – for a visual overview of all projects at once
Instructions on how to update and maintain the sheet

Skills Required:
Advanced Excel (formulas, charts, pivot tables, conditional formatting)
Experience with project management templates
VBA/Macro knowledge is a plus" (client-provided description)