Excel Trackers: Habit, Task, Expense & Goal Trackers with Formulas
Build the trackers people actually use: a habit grid with streaks, a to-do list with overdue flags, an expense tracker with SUMIFS and budget vs actual, reading and savings goals with pace and months to goal, a workout log with personal bests, a mini-Gantt with formula rules and a dashboard, in 8 hands-on labs.
The first 2 lessons are free — no account needed.
About this course
An Excel trackers course that builds the trackers people actually use, for one fictional freelance designer, Maya, who runs her week from one workbook. You count the days each habit was done with COUNTIF and build a running streak counter with IF and the longest streak with MAX, add days left, overdue flags and % done to a to-do list, total an expense log by category and month with SUMIFS and flag the categories over budget, measure a reading goal by pages and the pace needed per day, find personal bests in a workout log with MAXIFS, shade a mini-Gantt timeline with a formula rule, track a savings goal with a running balance and the months still needed, and pull every tracker into a one-screen dashboard with a budget vs actual chart. The first two labs are free.
Lessons
- Habit Tracker: x Marks, COUNTIF per Habit & a Streak CounterFree
- To-Do & Task Tracker: Status, Due Dates, Overdue Flags & % DoneFree
- Expense Tracker: Categories, SUMIFS by Month & Budget vs Actual Pro
- Reading Goal Tracker: Progress %, Pace Needed per Day & On Track? Pro
- Workout Log: Volume, Week Numbers, Weekly Totals & Personal Bests (MAXIFS) Pro
- Mini-Gantt Project Timeline: Durations & Formula Rules that Shade the Weeks Pro
- Savings Goal Tracker: Running Balance, Progress % & Months to Goal (with a Chart) Pro
- Tracker Dashboard: KPIs from Every Tracker & a Budget vs Actual Chart Pro