A ready-to-use project Gantt chart in Excel for project managers, team leaders, consultants and small businesses that need to plan and track a project schedule. The header holds the project name, project manager, company, project start date, status date and the week shown on the timeline. Tasks are grouped into phases, and each row records the WBS number, task name, owner, type, priority, start and end dates and the percentage completed. Calendar days and working days are calculated automatically, excluding weekends and the dates listed on the Holidays sheet. Phase rows roll up their start and end dates and a progress figure weighted by working days from the tasks beneath them. The status of every task is calculated against the status date as Complete, On Track, Behind, Overdue, In Progress or Not Started. A 12-week timeline draws progress bars that split each task into completed and remaining work, shows phases as summary bars and milestones as diamonds, and shades non-working days. The status date is marked on the timeline, and changing the display week scrolls the chart forward through the project. Summary tiles show the total number of tasks, completed, in-progress and overdue tasks, the overall progress and the planned finish date. Drop-down lists, data validation and an Instructions sheet make the template easy to fill in, and it is set up to print on A3 landscape.
Mint Offer, Blue Horizon, Bold Beacon, Citrus Clean, Classic Ledger, Evergreen Edge, Fresh Current, Luminous Lines, Midnight Pop, Nocturne, Prism Point, Skyline Blue, Soft Touch, The Ledger, Violet Standard
Excel template, spreadsheet, small business, gantt chart, task tracker, project plan, project schedule, milestones, project management, project timeline, percent complete, project dashboard, automatic calculations, skyline blue, blue horizon, bold beacon, citrus clean, classic ledger, evergreen edge, fresh current, luminous lines, midnight pop, mint offer, nocturne, prism point, soft touch, the ledger, violet standard, progress tracking, project phases, work breakdown structure, task status, overdue tasks, working days, holidays, weekly timeline, planning, project manager, printable A3, website redesign