00:00Hi there! Today I'll show you how to use the Wedding Planner template,
00:04available for purchase on our website spreadsheetshub.com.
00:08This template helps you organize your wedding, plan your budget, track expenses,
00:13manage vendors and bookings, and keep all your wedding details in one convenient place.
00:19Before getting started, take a moment to read the instructions on the first page.
00:23They'll guide you through how to use the template effectively.
00:27The first step shows how to specify the budget plan and main categories.
00:33The second and third steps show how to enter information about the wedding budget and analyze it.
00:40This step shows how to fill in the contact list information.
00:45Below is how to fill out the catering menu which helps you stay organized and ensure nothing is
00:50forgotten for your big day. This step shows how to fill in the information on the venue search sheet.
00:56This sheet is important for comparing venues, organizing key details, and choosing the
01:01best option for your wedding. It shows how to fill out the guest list and analyze it.
01:08This step shows you how to fill out the checklist, helping you stay organized, track tasks,
01:14meet deadlines, and make sure nothing is forgotten for your wedding day.
01:18Next, it shows you how to fill out the seating plan, helping you organize guests, avoid confusion,
01:24balance tables, and ensure everyone enjoys your wedding day comfortably.
01:29This step shows you how to write a detailed plan for your wedding day.
01:34Go to the settings sheet. Enter your wedding budget.
01:41In the expenses categories block, list all the types of wedding expenses you plan to track.
01:47For example, stationary, attire, rings, decorations, food, rehearsal dinner, beauty, ceremony.
01:55You can also include any other costs you expect for your big day to keep your budget complete and organized.
02:08In the team block, list all the people involved in planning and supporting your wedding.
02:13For example, mom, dad, brother, sister, best friends, yourself, and your partner.
02:20This helps you keep track of responsibilities, coordinate tasks, and ensure everyone knows their role for a smooth celebration.
02:36In the menu setup block, list all the dishes and drinks you plan to serve at your wedding.
02:41This helps you organize your catering choices, track quantities and costs,
02:46and ensure a balanced and enjoyable menu for your guests.
03:05You can specify about 1,000 categories in each block.
03:11Go to the wedding budget sheet.
03:14The expenses should be entered in the tables below.
03:19Enter the date.
03:21Specify the description.
03:27Select the category.
03:29The drop-down list is generated based on the data specified on the settings sheet.
03:35Enter the budget and the actual amount.
03:41Specify the amount that has already been paid.
03:43The data in the outstanding column is calculated automatically.
03:47Let's specify more data.
04:02To make things easier for you, the input cells are highlighted in light blue and the formula cells that update
04:08automatically are marked in light pink.
04:10It's best not to change the formula cells as this could disrupt the calculations.
04:16These cells are also locked for protection.
04:18If you still decide to modify a formula, just enter your data and click OK when prompted.
04:27The formula will be updated.
04:29In the Excel version, you can unlock the sheet without a password if needed, but we recommend leaving the formulas
04:35untouched to ensure everything functions correctly.
04:39Moving on to the analysis section.
04:41The model is in English by default, but if you want to translate the tables into another language, you can
04:47use our Translate Hub tool.
04:48It's quick, accurate, and super easy to use. You'll find the link in the description below.
04:54Let's return to the model.
04:57The summary budget data is shown here, budget, actual, and left to spend, helping you track your spending, stay within
05:04budget, and make informed decisions for your wedding.
05:07The expense distribution chart shows the structure of expenses by category.
05:13This chart shows how much of the budget has already been spent.
05:17With this chart, you can analyze budgeted and actual expenditure amounts, helping you spot overspending, stay on track, and make
05:25smarter financial decisions for your wedding.
05:27The top 10 expenses chart can be used to analyze the top expenses.
05:33Go to the contact list sheet.
05:36This helps you keep all your vendor information organized, easily accessible, and ensures smooth communication for your wedding.
05:45Specify the vendor or venue.
05:48Select the category.
05:50The drop-down list is generated based on the data specified on the settings sheet.
05:56Enter the contact's name, email, and phone number.
06:06Mark contract agreed.
06:08If necessary, specify notes.
06:10Let's specify more data.
06:21Go to the catering menu sheet.
06:24Filling out the catering menu sheet is important to organize your menu choices, track costs accurately, and ensure a seamless
06:31dining experience for your wedding guests.
06:34Specify the table and guests.
06:38The drop-down list for the columns Starter, Main, Dessert, and Drink are generated based on the data specified in
06:45the settings sheet.
06:51Let's enter more data.
07:04You may also indicate any additional guest requests, such as dietary requirements.
07:11You can specify about 1,000 guests.
07:14Go to the venue research sheet.
07:17This is important for comparing venues, tracking details, and making an informed decision for your perfect wedding location.
07:24Specify the venue.
07:28Upload the photo.
07:36Specify the contact's name, email, and phone number.
07:43Enter the rate.
07:45Specify the capacity and preference.
07:49Let's enter more data.
08:05You can include 16 examples.
08:09In this block, you need to specify the selected location.
08:22Using the cost comparison chart, you can compare prices for locations and make the best decision.
08:28In the notes section, you can enter notes about the location, which will help you keep track of important details.
08:38Mark the completed task.
08:40Go to the guest list sheet.
08:42This sheet is essential as it contains the complete guest list.
08:47Information should be entered into the table below.
08:50Enter the table.
08:52Specify the envelope.
08:55Enter the guest name.
08:57If necessary, you can specify the address.
09:01Mark the guest status.
09:02Enter the number and email address.
09:10Marking children.
09:12Select the guest category.
09:16Choosing who to be a guest for the newlyweds.
09:20If necessary, check gift received and thank you.
09:24Let's enter more data.
09:42The guest breakdown chart shows the structure of guests by category.
09:48The total number of guests is calculated automatically.
09:51Only guests who have been sent an invitation are counted.
09:56The chart shows the number of guests by invitation response.
10:01In the block, you can write down notes and tasks so that you don't miss anything.
10:11Mark the completed task.
10:15Go to the checklist sheet.
10:18This sheet helps you track all wedding tasks and make sure nothing is missed.
10:31Select the person responsible and set a completion date.
10:35The blocks are divided into periods ranging from 12 months to 1 week.
10:40Let's enter some examples.
10:42Enter the task.
10:46Select the responsible persons.
10:48The drop-down list is generated based on the data specified in the settings sheet.
10:54Select the date.
11:05Once the task has been completed, check the box.
11:08You can specify 15 tasks in each block.
11:12Go to the seating plan sheet.
11:14This sheet is important for organizing guest seating and ensuring everyone has an assigned place.
11:19The sheet consists of 20 blocks and each block can accommodate 20 guests.
11:24You need to specify the place and the guest.
11:31Using this sheet helps ensure a well-organized seating arrangement and a comfortable experience for all guests.
11:37Go to the wedding day sheet.
11:39In this table, you can plan and organize events for up to three days.
11:44Specify the time, duration, description of the activity, and location for each event.
11:50In the day one table, list all events and activities planned for the first day of the wedding celebration.
11:56For example, guest arrival and welcome drinks, engagement party, and dinner with close family.
12:03You can also include other activities such as a welcome speech, icebreaker, games,
12:08or a short group photo session to capture the first day's moments.
12:19In the day two table, list all events and activities planned for the second day of the wedding celebration.
12:25For example, wedding ceremony, group photo shoot, and reception with dancing and entertainment.
12:31You can also include other activities such as cake cutting, speeches or toasts,
12:36and any special performances planned for the evening.
12:46In the day three table, list all events and activities planned for the third day of the wedding celebration.
12:53For example, post-wedding brunch, farewell gathering with guests, and guest departures.
12:59You can also include other activities such as a short sightseeing tour,
13:04gift distribution, or a relaxed family gathering before the guests leave.
13:11You can list all important events for each day to create a clear and well-organized timeline for the wedding
13:18celebration.
13:18And one technical point. If you're using the Excel version of this report, we recommend using Excel 2021 or later
13:26to ensure all formulas work correctly.
13:29Also, please avoid opening the Excel file in Google Sheets.
13:33If you prefer working in Google Sheets, we suggest using the dedicated Google Sheets version of the report instead.
13:40Enter your own wedding details to see how easy it is to plan and organize your special day.
13:45The template is available for download via the link in the description.
13:50For more personalized solutions, our team can build custom tables tailored to any level of complexity.
13:56We also offer templates with resale rights along with an open affiliate program for those interested.
14:02Thanks for watching, and have a productive day!
Comments