Excel tutorial: build a small task tracker from a blank workbook

This Excel tutorial builds a small task tracker so each basic action has a clear purpose. You will enter rows, calculate a simple total, filter a table and save a usable workbook. The example uses English-language Excel and ordinary worksheet features, not macros or a particular subscription-only tool.

Start with a blank workbook and save a working copy. Desktop and web editions can place commands differently, so use the named feature rather than assuming every ribbon looks identical.

Enter one record per row

In row 1, enter Task in A1, Owner in B1, Planned hours in C1 and Status in D1. Enter three example tasks in rows 2–4, using simple whole numbers for hours and consistent status words such as Open or Done. These are demonstration records, not real employee data.

Keep one task per row and one type of information per column. Do not put a subtotal, a second heading or a blank separator row between ordinary task records. A consistent rectangular range is easier to filter and extend.

Calculate before formatting

Click C6 and type =SUM(C2:C4), then press Enter. If the three entered hour values are 2, 3 and 4, the expected total is 9. Compare the displayed result with that manual check.

A formula starts with an equals sign. The colon identifies the continuous range from C2 through C4. If Excel shows the formula itself rather than a result, check that the cell is not formatted as Text and re-enter the formula appropriately. Regional language and separator settings can affect function names in other installations.

Turn the records into a table

Select A1:D4 and choose Insert → Table, or the equivalent Format as Table command. Confirm the range and that the first row contains headers. The table should include only the records and their headings, not the separate total in row 6.

A table supplies a consistent structure and filter controls. Add a new task immediately below it and check whether the table extends as intended. Do not assume that a separate range-based formula outside the table always expands to cover every new row; inspect its references.

Sort whole records and use filters

Use the table’s Status filter to show only Open tasks, then clear the filter. The rows are hidden by the view, not deleted. Check the record count before assuming data has disappeared.

Sort Planned hours using the table control. Confirm that Task, Owner, Hours and Status move together. Sorting a single loose column independently can separate a task from its owner and create an internally inconsistent tracker.

Make the workbook readable

Widen columns enough to show headings, use a simple number format for hours and avoid merged cells inside the data area. If a task description is long, wrap its text rather than inserting several separate records for the same task.

Name the worksheet clearly and document what the hours represent. A tracker containing planned effort should not be presented as a record of actual hours unless those values have been collected separately.

Check the finished example

Change one hour value and confirm the formula changes. Add a row and check both the table boundary and the total. Filter and clear again, then reopen the saved workbook to confirm the result persists.

You now have a small, testable workflow: structured input, a calculation and a useful view. Add charts or more complex functions only when there is a question the current tracker cannot answer.

Sources and further information

Microsoft: formulas, operators and cell references.

Microsoft: structured Excel tables, headers and table features.