Household Admin Workbook: Bill Calendars, Shared Costs, Subscriptions & Home Inventory
Run a fictional household like a small office: bill due dates and month-end totals, a fair income-based cost split, a subscriptions audit, meter readings, a meal plan turned into a shopping list, a home inventory for insurance, a warranty tracker and a one-screen dashboard, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this beginner course you organise a fictional couple's household in one workbook. You calculate next due dates for monthly, quarterly and yearly bills with EDATE, total what is due by month end with EOMONTH and list upcoming bills with FILTER. You split shared costs by income and work out the one transfer that settles the month, audit subscriptions by cost per use, and turn irregular meter readings into kWh per day, period costs and a year-over-year check. You scale a meal plan into a shopping list of whole packs, value a home inventory for insurance with DATEDIF, track warranties with traffic-light statuses and finish with a one-screen household dashboard.
Lessons
- A Bill Calendar: Next Due Dates, Month-End Totals and What Is Due Soon Pro
- Shared Household Costs: Equal Split vs Income Split and the Monthly Transfer Pro
- Subscriptions Audit: Annual vs Monthly Plans, Cost per Use and What to Cancel Pro
- Meter Readings: Consumption, Cost per Period and the Year-over-Year Check Pro
- Meal Plan to Shopping List: Quantities, Whole Packs and Cost Pro
- Home Inventory for Insurance: Age, Current Value and Totals by Room Pro
- Warranty and Document Tracker: Expiry Dates, Days Left and Traffic Lights Pro
- Capstone: A One-Screen Household Dashboard Pro