List your tasks and the Gantt chart draws itself: working-day dates, predecessors, milestones, workload, risks and a live dashboard. Excel and Google Sheets.
$11.99
Buy on Etsy- Excel and Google Sheets
- Blank and filled-in example
- Instant download
- Secure checkout on Etsy
Plan your project once and watch the Gantt chart draw itself. List your tasks with a duration in working days, an end date or a predecessor, and the spreadsheet works out every date, skips weekends and holidays, colours each bar by status and keeps the dashboard up to date.
What’s inside
- Dashboard: overall % complete (weighted by working days), tasks done, in progress, overdue and not started, working days to finish, planned finish vs your target date, next 5 milestones, overdue tasks and a progress-by-phase chart
- Tasks: up to 150 tasks with phase, owner, start date, duration in working days or end date, predecessor, % complete and milestone flag. Status fills in by itself: Not started, In progress, Done, Overdue or Milestone
- Gantt: a 26-week timeline. Bars colour by status, the darker part shows what’s done, milestones show as diamonds and this week is highlighted
- Daily Gantt: 90 days, day by day, with weekends and holidays shaded and today marked
- Workload: working days and tasks per person per week, with overbooked weeks shown in red
- Risks & Issues: likelihood × impact score, colour-coded rating and a 5 by 5 risk matrix
- Setup: project name, owner, start and target dates, status rules, team members, phases and holidays
- Start Here guide, plus a filled-in example: a small-business website launch with 35 tasks across 6 phases
How it works
- Download the files after purchase
- Open in Excel, or upload to Google Drive and open with Google Sheets (share it with your team so everyone can update their progress)
- Add your start date, team and phases on Setup, then list your tasks. Type only in the yellow cells. Everything else updates by itself
Good to know
- Works in Excel 2016 or newer, Excel for Mac, Microsoft 365 and Google Sheets
- Working days are Monday to Friday, minus the holidays you add
- Link a task to the one before it and its dates move when that task moves
- Statuses use today’s date, or a status date you choose for reports
- This is a digital download. Nothing will be shipped
- For your own projects, personal or business. Please do not share or resell the files
- Need help? Message us on Etsy and we’ll get you set up
Made by YellowCellStudio, a product of QSE Advisory. Every formula is tested in Excel and Google Sheets, and every file is checked by QSE Advisory experts before release.
Questions
Do I need Excel?
No. It works in Microsoft Excel 2016 or newer, Excel for Mac, Microsoft 365 and free Google Sheets.
How do I get the file?
Buy on Etsy and the download link appears straight away. Nothing is shipped.
Is it hard to use?
You only type in the yellow cells. Totals, dashboards and charts update by themselves, and a Start Here tab explains each step.
What if something doesn’t work?
Message us on Etsy. We fix errors fast and will help you set up the file.
