Student Budget for University Life: Semester Costs, Rent & Shared Flats, Part-Time Income, Study vs Work Hours, Savings Targets & a Monthly Plan
Make your money last the whole semester. You will list semester and monthly costs, compare housing options, plan part-time work against study hours, spread one-off costs like fees and books, build a monthly budget with a buffer, track spending against it and test what-if changes, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course builds a complete student budget for one fictional first-year student, step by step. You turn monthly, semester, yearly and one-off costs into monthly equivalents with XLOOKUP, compare a residence, a shared flat and living at home including travel and move-in cash, convert an hourly wage into net monthly pay and apply an invented grant rule, plan work hours against study time with ROUNDUP, spread fees and a laptop over the months with DAYS, EDATE, YEAR and MONTH, build a monthly budget with a buffer and a savings target, track spending by category and month with SUMIFS and finish with what-if scenarios and a chart.
Lessons
- Your Cost Inventory: One-Off, Monthly, Semester and Yearly Costs as Monthly Equivalents Pro
- Housing Options Compared: Student Residence, Shared Flat or Living at Home Pro
- Where the Money Comes From: Family Support, an Invented Grant and Part-Time Pay Pro
- Work vs Study: A Weekly Hours Budget, the Wage You Need and a Study-Hour Limit Pro
- Spreading the Big Bills: Fees, Books and a New Laptop as Monthly Savings (DAYS, EDATE) Pro
- The Monthly Budget: Categories, a Buffer, a Savings Target and the Gap Pro
- The Spending Tracker: Totals by Category and Month with SUMIFS and Overspend Flags Pro
- Capstone: What-If Scenarios for Rent, Work Hours and the Phone Plan, with a Chart Pro