You've got a project. Maybe twelve tasks, maybe two hundred. Three people involved, maybe ten. Deadlines that keep shifting because the client changed their mind on Tuesday. Someone needs to track all of this — and someone, somewhere, is going to ask if you can just do it in Excel.

The honest answer is yes. Excel handles project tracking surprisingly well for small-to-mid teams. You get task lists, owners, statuses, dependencies, conditional colors that flag overdue work, and a dashboard that summarizes the whole thing on one tab. No subscription fees. No vendor lock-in. Everything lives in one file you can email, share to OneDrive, or pin to a Teams channel.

What Excel won't do is replace Asana for a 50-person agency or Jira for a software engineering org. But for the manager running 3 internal projects, the small business owner tracking a renovation, or the team lead juggling deliverables across two clients — Excel is genuinely good enough. This walk-through shows you both routes: grab Microsoft's pre-built templates in two clicks, or build a tracker from scratch with the exact columns your team needs.

Before you open Excel, decide what you actually need to track. The smallest viable tracker has five columns — task name, owner, status, due date, and notes. That's enough for a freelancer juggling client work. A mid-size tracker adds priority, start date, percent complete, and dependencies. Eight to ten columns total. The big-team version layers in budget, hours logged, risk level, milestone flag, and links to deliverables.

Don't over-engineer it. The single biggest reason Excel trackers fail isn't Excel — it's that someone built a 22-column monster and nobody on the team wants to fill in 22 fields per task. Start with the minimum. Add columns only when the team genuinely asks for them. Empty columns become noise; noisy spreadsheets get ignored.

One more decision before you build. Are you tracking one project at a time, or running a portfolio? Single-project trackers live on a single tab — tasks down the rows, attributes across the columns. Portfolio trackers need a project name or ID column so you can filter by project. Same skeleton, just one more field. Pick whichever fits your reality now; you can always extend later.

If you're brand new to setting up spreadsheets like this, Excel for the web (free with a Microsoft account) handles all of it. Desktop Excel is faster for big tables and gives you Power Query for refreshable data, but every method below works in browser Excel too. The Mac version is identical except for a few keyboard shortcuts — substitute Cmd for Ctrl and you're set.

The fastest start is to skip building anything and let Microsoft do the work. Excel ships with several project templates that cover most use cases.

Open Excel. Click File > New. In the search box at the top, type project tracker and hit Enter. You'll see options like Simple Project Tracker, Project Tracker by Vertex42, Agile Gantt Chart, and a few task list variants. Click any thumbnail to preview, then click Create to open a fresh copy. Excel downloads it from Office.com instantly.

The Simple Project Tracker is the best starting point for most teams. It comes with a task list tab, a Gantt chart tab, and a dashboard. Pre-built formulas for percent complete, days remaining, and overdue flags are already in place. Just type your tasks into the rows and the rest updates automatically. Editable colors. Resizable columns. Everything's unlocked.

If you don't see what you want in the built-in templates, try Microsoft's template gallery at create.microsoft.com/en-us/templates. Search "project" there and you'll find dozens more — agile sprint trackers, construction project schedulers, marketing campaign planners. All free. All editable. Some are bare-bones; some are gorgeously designed. Pick one that feels close to what you need and customize from there.

Templates are great until they're not. Maybe yours uses jargon your team doesn't speak. Maybe the columns are wrong. Maybe the dashboard tracks budget when you don't have a budget. At some point you'll want to build your own — or at least gut a template down to its bones.

Open a blank workbook. On Sheet1, type your column headers in row 1: Task ID, Task Name, Owner, Priority, Status, Start Date, Due Date, % Complete, Dependencies, Notes. That's ten columns and covers about 95% of small-team tracking. Format row 1 as bold, give it a fill color, freeze the top row via View > Freeze Panes > Freeze Top Row.

Select your whole data range — say A1:J100 — and convert it to a Table with Ctrl+T. Check "My table has headers" and click OK. Now you've got a proper Excel Table: filter dropdowns, banded rows, auto-expand when you type a new row at the bottom, and structured references for any formulas. Tables are a force multiplier in trackers. Use them every time.

Next step — make the data entry stupid-proof. People will paste in the wrong status, type "Mike" when the owner is "Michael", and forget to update percent complete. Data validation cuts most of that off at the source.

Click the Status column header. Go to Data > Data Validation. Pick List from the dropdown. In the source field, type Not Started,In Progress,Blocked,Complete,On Hold. Click OK. Now every cell in that column shows a dropdown arrow — pick from the list, can't type anything else.

Do the same for Priority — Low,Medium,High,Critical. For Owner, type the team's real names: Sarah,Marcus,Priya,Devon,Jordan. If you've got a longer team, point the source to a range on a separate tab (something like =Teams!$A$2:$A$20) so adding a new person doesn't require editing every validation rule.

The % Complete column gets number validation — between 0 and 1 if you're using percentage format, or between 0 and 100 for whole numbers. Just makes sure nobody types 150% by accident. Tiny details, but they keep the data clean enough that your formulas and dashboard don't lie.

Plain text statuses are forgettable. Color tells the story at a glance. Conditional formatting is what makes a tracker actually useful — overdue rows go red, in-progress rows turn yellow, completed rows fade to gray. You scan the sheet and your eyes go straight to the trouble.

Select the whole table — click the corner of cell A1 and drag down to your last column and row. Go to Home > Conditional Formatting > New Rule. Choose "Use a formula to determine which cells to format". For overdue items, the formula is: =AND($G2<TODAY(),$E2<>"Complete"). That checks two things — due date in column G is before today, and status in column E isn't "Complete". Set the format to red fill, white text. Hit OK.

Add a second rule for at-risk items — anything due in the next 3 days that isn't done. Formula: =AND($G2<=TODAY()+3,$G2>=TODAY(),$E2<>"Complete"). Format that one with an amber fill, dark text. Tasks due this week glow orange.

One more rule — completed tasks. Formula: =$E2="Complete". Format with light gray fill and strikethrough text. Done items still appear in the list but visually recede. Your eye skips past them to the active work.

The order of conditional formatting rules matters. Excel checks them top to bottom and applies the first match. Drag "Complete" to the top, then "Overdue", then "At Risk". That way a finished task can't accidentally show as overdue. Manage the order via Home > Conditional Formatting > Manage Rules.

Dates are the engine of any tracker. Get the date formulas right and the rest follows. Wrong, and your "days remaining" column lies to everyone.

Add a column called Days Remaining next to Due Date. Formula: =IF(E2="Complete",0,G2-TODAY()). If the task is complete, days remaining is zero. Otherwise it's the difference between due date and today. Negative numbers mean overdue. Positive numbers mean time left.

Want a friendlier display? Wrap it: =IF(E2="Complete","Done",IF(G2<TODAY(),ABS(G2-TODAY())&" days late",G2-TODAY()&" days left")). Now you see "5 days left", "Done", or "2 days late". Reads naturally. Costs nothing to compute.

For working days only — skipping weekends — use NETWORKDAYS. =NETWORKDAYS(TODAY(),G2) returns the count of Monday-through-Friday days between now and the due date. Add a third argument with a holiday list (a named range like Holidays) and it skips those too. Crucial for construction, manufacturing, or any project where weekends genuinely don't count.

Two more useful columns. Slipped Days: how many days late a completed task ended up being. Formula: =IF(AND(E2="Complete",H2>G2),H2-G2,0) where H2 is your Actual Completion Date column. Duration: =G2-F2+1 gives total days from start to due. These two columns feed any post-project retrospective directly from the tracker.

A dashboard is what turns your tracker from a list into a tool. Even a basic one — five numbers in big bold font on a second tab — answers the questions stakeholders ask: How many tasks left? How many overdue? Who's most loaded? What percent done overall?

Create a new tab. Call it Dashboard. The key formulas all use COUNTIF and COUNTIFS against your task table. Total tasks: =COUNTA(Tasks[Task Name]). Tasks complete: =COUNTIF(Tasks[Status],"Complete"). Tasks overdue: =COUNTIFS(Tasks[Due Date],"<"&TODAY(),Tasks[Status],"<>Complete"). Overall percent done: =COUNTIF(Tasks[Status],"Complete")/COUNTA(Tasks[Task Name]), formatted as percentage.

Layout matters. Put each metric in its own large cell — merge a 2×3 area, font size 36, bold, centered. Label below in font size 11, gray. Five tiles across the top. Beneath them, add a small pivot table breaking down tasks by status (Not Started, In Progress, Blocked, Complete, On Hold). Pivot tables let you click and drill into the underlying tasks. Add another pivot below it by owner — instant view of who's holding the most work.

For workload distribution, you might also add SUMIFS — total estimated hours per person, or count of high-priority tasks per owner. The formula pattern: =COUNTIFS(Tasks[Owner],"Sarah",Tasks[Priority],"High"). Drag the formula across columns and rows to build a matrix. Color-scale conditional formatting turns it into a heatmap — anyone overloaded shows up bright red.

Sparklines are the secret weapon. Tiny in-cell charts that show trend without taking real estate. In a tracker, the killer use case is the burndown sparkline — a mini line chart showing tasks remaining over time.

You need a small helper table. Add a new tab called Burndown. Column A is a list of dates from project start to project end (one row per day, or one per week — your call). Column B is the count of incomplete tasks on each date. The formula for column B is =COUNTIFS(Tasks[Status],"<>Complete",Tasks[Due Date],">="&A2) or any variant that fits how you define "remaining".

Once that mini-table is populated, click an empty cell on your dashboard. Go to Insert > Sparkline > Line. Pick the range from your burndown helper as the data range. Excel draws a one-cell line chart. Resize the cell to make it bigger. Done — anyone glancing at the dashboard sees the project burning down (or not).

You can add sparklines for individual owners too. One mini-chart per row in your dashboard's "by owner" breakdown — shows each person's task load trending over the past four weeks. Suddenly you can see who's stuck. Color the sparkline red for declining trends, green for improvement. Tiny details, big readability win.

Dependencies are the trickiest piece. Real projects have task chains — "we can't start design until the brief is approved", "QA can't begin until dev hits feature freeze". Capturing that in Excel takes a little setup but pays off massively.

Add a column called Predecessor. Each cell holds the Task ID of the task that must finish first. For example, Task 7 has Predecessor "3" — meaning task 3 must complete before task 7 can start. Use comma-separated IDs for multiple predecessors ("3,5").

Now add a helper column called Can Start?. Formula: =IF(I2="","Yes",IF(COUNTIFS(Tasks[Task ID],I2,Tasks[Status],"Complete")=1,"Yes","Blocked")) where I2 is your Predecessor column. Translation: if there's no predecessor, Yes. Otherwise, check whether the predecessor row's status is Complete. If yes, this task is unlocked. If no, mark Blocked.

Pair the Can Start column with conditional formatting — Blocked rows get a light blue fill — and the whole team can see at a glance which tasks are waiting on something upstream. Couple this with the conditional Status formatting you already set, and the sheet becomes self-prioritizing. Owners look at the tracker, find their first row tinted neither red nor blue, and that's the next thing they should work on.

For visual planning, hook a Gantt-style timeline onto your task list. The basics: each task gets a horizontal bar showing start-to-finish. Excel doesn't ship with a native Gantt chart type, but you can fake one perfectly using a stacked bar chart, or build one with conditional formatting across a date-column grid.

The grid method is fastest. Add columns to the right of your existing tracker — one per day of the project. Say columns L through ZZ, each header is a date. In cell L2 (the first date column for task 1), use a formula like =IF(AND(L$1>=$F2,L$1<=$G2),1,0). That returns 1 when the date in the column header is between the task's start and due dates. Apply conditional formatting to color any cell containing 1 with a solid fill. Drag the formula across your date grid and down through your tasks. Instant timeline.

If you want a more polished view, build the dedicated chart-based version on a separate tab using a stacked bar chart trick — there's a full breakdown of that build in our Excel Gantt chart guide. For this tracker, the conditional-formatting grid is simpler to maintain and lives inline with your task data.

Either approach pairs well with the dependencies you set up earlier. Hover any task, see who owns it, what status it's in, and where it sits in the project timeline. That's the difference between a list and an actual project management system.

At some point you'll hit Excel's limits. Maybe your project has 400 tasks, 20 people, and three teams across different time zones. Maybe version control turns into emailing v17_FINAL_revised.xlsx around. That's when dedicated tools start to look attractive.

Asana, Monday.com, ClickUp, Jira, Smartsheet — they all handle multi-user collaboration without merge conflicts. Mobile apps, automation rules, integrations with Slack/Teams, audit trails. Excel doesn't have most of that without significant lift.

What Excel gives you back is total customization. Up to five people, one or two active projects, mostly internal work — Excel wins on speed and cost. Beyond ten people, or external client visibility needed — paid tools usually justify the spend. The middle ground is Excel plus OneDrive co-authoring, letting a 6-8 person team collaborate in real time.

A few habits will save you hours over the life of a project. Save versions — after every meaningful update, do File > Save As with a date in the filename. Or use OneDrive's version history, which tracks every save automatically.

Protect the formulas. Unlock only cells users should edit, then Review > Protect Sheet with a password. Now anyone can edit data but not break the dashboard. Worth ten minutes of setup.

Real-world example. Say you're running a website redesign — 6 weeks, 4 team members, 38 tasks. Task ID auto-numbered 1 through 38. Tasks grouped logically using a Phase column. Owners assigned. Due dates spread across the timeline. Predecessors set so dev can't begin until design is approved.

Conditional formatting flags overdue in red, at-risk in amber, blocked in blue. The dashboard tab shows: 38 total tasks, 12 complete, 8 in progress, 3 overdue, 71% on schedule. A sparkline shows tasks-remaining trending down — except for two flat days where design stalled. The pivot by owner shows Marcus with 14 active tasks while Devon has 3, so next standup you re-balance.

That skeleton — tasks, owners, dates, statuses, predecessors, colors, dashboard — adapts to whatever your project looks like. Build the bones once. Reuse forever.