Excel Trackers: Habit, Task, Expense & Goal Trackers with Formulas

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn a two-week habit grid into a live tracker: days done per habit with COUNTIF, a running streak counter with IF, the longest streak with MAX and green ticks with conditional formatting.
• Add days left, an Overdue flag, the share of finished tasks and an overdue count to Maya's task list.
• Add a month column to Maya's expense log, total it by category and month with SUMIFS, compare March with the budget and flag the overspent categories.
• Measure Maya's 12-book reading goal by pages: progress per book, overall progress, the pages per day she now needs and whether she is on track.
• Add training volume and week numbers to Maya's lifting log, total the volume per week with SUMIFS and find each exercise's personal best with MAXIFS.
• Build a mini-Gantt for Maya's website project: task durations, a formula rule that shades every week a task runs, the project length and a marker on the current week.
• Track Maya's laptop-and-trip fund: a running balance with an expanding SUM, progress towards the goal, the months still needed at her average pace and a line chart of the balance.
• Build Maya's one-screen April dashboard: % of tasks done, % of budget used, her best habit with INDEX/MATCH and a budget vs actual chart.