Plan a Wedding by the Numbers: Budget Split, Guest List, Seating & Vendor Payments
Keep a wedding on budget from the first quote to the last vendor payment – budget shares and over-budget flags, RSVP counts, tiered catering prices, a vendor scoring matrix, deposit and balance due dates, seating, a savings plan and a one-page dashboard – 8 hands-on labs for one fictional couple, 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 plan a complete wedding in a spreadsheet that checks itself. You split a total budget into category shares and flag overspending, count RSVPs, children and plus-ones with COUNTIFS, look up tiered catering prices with XLOOKUP and compare an open-bar package with paying per drink. You score photographers with a weighted matrix and rank them, schedule deposits and balances with WORKDAY and EDATE, work out tables and empty seats with ROUNDUP, plan the monthly saving with DATEDIF and PMT and finish with a dashboard and chart of budget against commitments.
Lessons
- Splitting the Wedding Budget: Shares, Remaining Amounts & Over-Budget Flags Pro
- The Guest List: RSVPs, Plus-Ones & the Catering Headcount Pro
- Cost per Guest: Tiered Catering Prices with XLOOKUP and Bar Package vs Consumption Pro
- Choosing Vendors: a Weighted Scoring Matrix with SUMPRODUCT and RANK.EQ Pro
- The Payment Schedule: Deposits, Due Dates with WORKDAY & EDATE, and What Is Still Open Pro
- Seating: Tables Needed with ROUNDUP, Guests per Table & Empty Seats Pro
- The Savings Plan: Months to Go with DATEDIF and the Monthly Amount with PMT Pro
- The Wedding Dashboard: Spend vs Budget, RSVP Progress & Open Payments Pro