I will create an excel gantt chart template with dependencies and dashboard
Financial Accounting, Reporting, Modeling, Automation
Nivel 2
Ha cumplido con los criterios de alto rendimiento y tiene un historial comprobado de cumplimiento de las expectativas de los clientes.
Acerca de este Servicio
Tired of messy project spreadsheets? I will build a professional Excel Gantt Chart that plans, tracks and reports your project automatically. No macros, no subscriptions. Choose your style:
STYLE 1: SMART GANTT PLANNER (Cell-based)
- Task list with auto end dates, dependencies, owners & priority
- Skips weekends/holidays you choose
- Colour-coded bars, red "today" line, 6 auto statuses
- Executive Dashboard: 10 live KPI cards + status chart
STYLE 2: EXCEL CHART GANTT (PLAN vs ACTUAL)
- Planned vs actual bars with % completion shading
- Dependency connector lines & current-date marker
- Working-day end dates using your holiday list
- Updates instantly when dates change
PERFECT FOR
Project managers, agencies, construction, IT teams, marketers, event planners, students.
ALSO INCLUDED
Your branding, phases & colours, sample data, How-to-Use guide.
️ Built for desktop Excel (Windows/Mac), not Google Sheets.
Message me your project details before ordering!
Dominio:
Negocios
Sector:
Construcción
•
Software
Idioma:
Inglés
Clientes con los cuales he trabajado
Olive Glow Esthetics
Created a fully automated Excel/VBA payroll workbook for a commission-based spa. Features per-staff service tracking, automatic earnings calculations, branded printable pay stubs, and year-to-date totals. Includes monthly/annual summaries, performance dashboard with charts, retail commission tracking, and a tax estimate calculator — all in a color-coded, professional layout.
may 2026-may 2026
Mi porfolio
FAQ
Does it work in Google Sheets or Excel Online?
No. It's built for desktop Excel (2016, 2019, 2021, 365, Windows & Mac). The weekday checkboxes and some formatting don't carry over to Google Sheets or Excel Online, so please check this before ordering.
Do I need macros, VBA or add-ins?
No. Everything runs on standard Excel formulas (Excel 2007+ functions), so there are no macro warnings or add-ins, and it's safe to share with your team or clients.
How does the automatic scheduling work?
Enter the first start date, each task's duration and its dependency (Task ID). Start and end dates calculate automatically, skipping the rest days you tick. Change a duration and dependent tasks and Gantt bars shift.
How is task status decided?
Type each task's % progress on the Gantt sheet. Status (Not Started, On Track, At Risk, Overdue, Complete, Started Early) updates from progress and dates, then feeds the Task List and the dashboard.
Can you add more than 30 tasks?
Yes. The template has 30 pre-built rows, and the guide shows how to extend the Task List and Gantt together. I can also extend it for you to the size your project needs.
Can you customize phases, colours and branding?
Yes. I can replace the default phases (Planning, Design, Development, Testing, Launch) with yours, add your logo, project title and company name, and match your brand colours.
What do I need to send you to get started?
Your task list (or a rough outline), project start date, working days, phases/categories, and any logo or brand colours. No data yet? I'll set it up with sample data you can overwrite.
3 comentarios sobre este Servicio
| (3) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Desglose de calificaciones
- Nivel de comunicación del Freelancer
- Calidad de la entrega
- Valor de la entrega
Ordenar por
C christinaly_

Reino Unido
Yasir was an absolute professional to work with! His attention to detail and proactive communication made the entire process seamless. Highly impressed with his timely delivery—would happily collaborate again!
USD 50-USD 100
$
4 días
Tiempo
Y 
Respuesta del Freelancer
Útil?D dlsimmons40

Estados Unidos
Colaboración continuaGreat working with you again. Satisfied repeat customer
USD 50
$
1 día
Tiempo
Y 
Respuesta del Freelancer
Útil?D dlsimmons40

Estados Unidos
Colaboración continuaGreat to Work with
USD 50-USD 100
$
4 días
Tiempo
Y 
Respuesta del Freelancer
Útil?
3 comentarios sobre este Servicio
| (3) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Desglose de calificaciones
- Nivel de comunicación del Freelancer
- Calidad de la entrega
- Valor de la entrega
Ordenar por
C christinaly_

Reino Unido
Yasir was an absolute professional to work with! His attention to detail and proactive communication made the entire process seamless. Highly impressed with his timely delivery—would happily collaborate again!
USD 50-USD 100
$
4 días
Tiempo
Y 
Respuesta del Freelancer
Útil?D dlsimmons40

Estados Unidos
Colaboración continuaGreat working with you again. Satisfied repeat customer
USD 50
$
1 día
Tiempo
Y 
Respuesta del Freelancer
Útil?D dlsimmons40

Estados Unidos
Colaboración continuaGreat to Work with
USD 50-USD 100
$
4 días
Tiempo
Y 
Respuesta del Freelancer
Útil?

