The Spending Tracker: Totals by Category and Month with SUMIFS and Overspend Flags
This lesson is part of the course
In this lesson
You total two months of Jonas's fictional spending log by category and month with SUMIFS and date limits, compare November with the budget and highlight every big single spend.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Your Cost Inventory: One-Off, Monthly, Semester and Yearly Costs as Monthly Equivalents Locked
- Housing Options Compared: Student Residence, Shared Flat or Living at Home Locked
- Where the Money Comes From: Family Support, an Invented Grant and Part-Time Pay Locked
- Work vs Study: A Weekly Hours Budget, the Wage You Need and a Study-Hour Limit Locked
- Spreading the Big Bills: Fees, Books and a New Laptop as Monthly Savings (DAYS, EDATE) Locked
- The Monthly Budget: Categories, a Buffer, a Savings Target and the Gap Locked
- The Spending Tracker: Totals by Category and Month with SUMIFS and Overspend Flags Locked
- Capstone: What-If Scenarios for Rent, Work Hours and the Phone Plan, with a Chart Locked