Work Plan Template: Layout, Excel Build Steps and a Filled-In Example

The layout: what goes where

A good work plan has two parts on one sheet. At the top, a summary block of about eight rows that anyone can read in 30 seconds. Below it, the task table that the team updates every week.

Keep it to one sheet. If people have to switch tabs to understand the plan, they will not read it. Put risks in a small block next to the summary, or in a second tab only if the list is long.

• Summary block (rows 1-8): project name, objective with a date, sponsor, project lead, scope in, scope out, overall status (green, amber or red) and last update date.
• Risks block (next to the summary): risk, owner, fallback, three to five lines at most.
• Task table columns: ID, Phase, Task, Owner, Start, End, Duration (days), Depends on, Status, % complete, Milestone (yes or no), Notes.
• Status values: Not started, On track, At risk, Late, Done. Use one color for each and nothing else.
• Phase rows: a bold, shaded row above each group of tasks with the phase name and its milestone.

How to build it in Excel

These steps work in recent versions of Excel on Windows and Mac. Start with a blank workbook and build the task table first, then add the summary block above it.

Once built, save it as a template so every new project starts from the same layout. Go to File, Save As, and choose Excel Template as the file type.

• Leave rows 1 to 9 for the summary block. In row 10, type the column headers listed above.
• Select the headers and the empty rows under them, then use Home, Format as Table, and tick My table has headers. New rows will keep the formatting.
• In the Duration column, use =NETWORKDAYS(Start, End) with the cell references for that row, so weekends do not count.
• Select the Status column, go to Data, Data Validation, choose List and type the five status values separated by commas.
• With the Status column still selected, use Home, Conditional Formatting, Highlight Cells Rules, Text that Contains, and set a fill color for At risk and for Late.
• Select row 11 and use View, Freeze Panes so the headers in row 10 stay visible when you scroll.
• For a simple timeline, add one column per week to the right of the table and use Conditional Formatting with a formula rule that fills the cell when the week falls between Start and End.

How to build it in Google Sheets

The layout is the same in Google Sheets. The main advantage is that every owner can update their own rows in the same file, and you can see the version history if something changes by mistake.

Share the sheet with edit access for owners and view access for stakeholders. Protect the summary block so only the project lead can change it, using Data, Protect sheets and ranges.

• Type the headers in row 10 and use View, Freeze, Up to row 10.
• Select the Status column and use Insert, Dropdown, then add the five status values with a color for each.
• Use =NETWORKDAYS(E11, F11) in the Duration column, adjusting the cell references to your Start and End columns.
• For the weekly timeline, add week columns and use Format, Conditional formatting with Custom formula is, so cells fill when the week falls between the task dates.
• Use Data, Create a filter so each owner can show only their own tasks.

Example: a filled-in work plan for an office move

Picture an operations manager moving 120 staff to a new floor in 12 weeks. The objective in the summary block reads: all 120 staff working from the new office, with IT and phones live, by Friday of week 12. Out of scope: new furniture purchases beyond the approved list.

Each phase row below is shown as it would look in the table, with the owner and the milestone. The tasks under each phase sit in the rows beneath it.

• Phase 1, Plan (weeks 1-2), owner operations manager: confirm headcount, floor plan with seat map, approved budget. Milestone: seat map signed by department heads.
• Phase 2, Prepare the space (weeks 3-6), owner facilities lead: cabling, furniture delivery, access badges, signage. Milestone: floor ready and inspected.
• Phase 3, IT setup (weeks 5-9), owner IT lead: network, Wi-Fi, printers, meeting room screens, test desks. Depends on: cabling done. Milestone: 10 test desks working end to end.
• Phase 4, Communicate and pack (weeks 8-11), owner HR business partner: staff briefing, moving guide, packing crates, move day schedule per team. Milestone: every team has a move slot.
• Phase 5, Move and close (weeks 11-12), owner operations manager: move weekend, day-one support desk, snag list, lessons learned. Milestone: all staff working from the new office.

Who owns what

The plan works only when ownership is clear. Every task row gets one name. If two people share a task, split it into two rows.

The project lead owns the plan as a document, but not every task in it. Their job is to keep it current and raise problems early.

• Sponsor: approves the objective, scope and milestones, decides when the plan must change.
• Project lead: builds the plan, runs the weekly check-in, keeps status and risks current.
• Task owners: deliver their tasks, update status and flag risks before deadlines pass.
• Stakeholders: read the summary and give input at kickoff and milestones.

How to present it to a sponsor

Do not present the full task table in a meeting. Copy the summary block and a phase-level view onto one slide in PowerPoint or Google Slides: five phase bars across a 12-week timeline, a diamond for each milestone, and the overall status color in the top corner.

Under the timeline, list the next two milestones, the top three risks with owners and any decision you need from the sponsor. Bring the full sheet as a backup if someone asks about a specific task. In weekly updates, change only the status colors, the dates that moved and the decisions needed.