Splitting the Wedding Budget: Shares, Remaining Amounts & Over-Budget Flags
This lesson is part of the course
In this lesson
You turn Nora and Jonah's total budget into planned amounts per category, compare them with the quotes they already have and flag every category that is over budget.
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
- Splitting the Wedding Budget: Shares, Remaining Amounts & Over-Budget Flags Locked
- The Guest List: RSVPs, Plus-Ones & the Catering Headcount Locked
- Cost per Guest: Tiered Catering Prices with XLOOKUP and Bar Package vs Consumption Locked
- Choosing Vendors: a Weighted Scoring Matrix with SUMPRODUCT and RANK.EQ Locked
- The Payment Schedule: Deposits, Due Dates with WORKDAY & EDATE, and What Is Still Open Locked
- Seating: Tables Needed with ROUNDUP, Guests per Table & Empty Seats Locked
- The Savings Plan: Months to Go with DATEDIF and the Monthly Amount with PMT Locked
- The Wedding Dashboard: Spend vs Budget, RSVP Progress & Open Payments Locked