Excel假期计划工作簿

Long ago, I created a Christmas planner in Excel, and it has evolved over the years. Well, tomorrow is the first of December, so you've probably finished your planning for this year. But, if you haven't, this year's new and improved version of the workbook might help. Now it's an Excel Holiday Planner – you can pick any date as your holiday, instead of being Christmas themed.

很久以前，我在Excel中创建了一个圣诞节计划器，多年来它一直在发展。 好吧，明天是12月1日，因此您可能已经完成了今年的计划。 但是，如果您还没有，今年的工作簿的新版本和改进版本可能会有所帮助。 现在，它是一个Excel假期计划程序–您可以选择任何日期作为假期，而不必以圣诞节为主题。

开始使用 (Get Started)

When you download the workbook, a PLAN tab will appear on the Excel Ribbon. Use the button there, to navigate to the different sheets in the workbook.

当您下载工作簿时，“计划”选项卡将出现在Excel功能区上。 使用那里的按钮，导航到工作簿中的不同工作表。

Do you like the custom icons that I created? If I can do that, with my non-existent art skills, you can too!

您喜欢我创建的自定义图标吗？ 如果我可以做到，用我不具备的艺术技能，你也可以！

There are details on my website, if you want to create a custom tab for the Excel Ribbon.

如果要为Excel功能区创建自定义选项卡 ，则在我的网站上有详细信息。

输入假期信息 (Enter the Holiday Info)

On the Start sheet in the Excel Holiday Planner, enter the current year, your holiday date, and the number of weeks before the holiday that your plan should include.

在“ Excel假期计划器”的“开始”表上，输入当年，您的假期日期以及您的计划应包含在假期之前的星期数。

You could enter December 25th, if you're celebrating Christmas, or December 23rd for Festivus, or any other holiday you want to celebrate.

如果您要庆祝圣诞节，则可以输入12月25日；如果要庆祝Festivus ，则可以输入12月23日，或者您要庆祝任何其他节日。

填写假期计划 (Fill in Holiday Plan)

Next, go to the different sheets, and fill in your holiday plans.

接下来，转到不同的表格，然后填写您的假期计划。

• There is a budget sheet, and another sheet where you can track your spending.
  有一个预算表，另一个是可以跟踪支出的表。
• There's a separate sheet for gifts – list all your gift ideas, and enter the final costs when you buy each gift.
  有单独的礼物表–列出您所有的礼物想法，并在购买每份礼物时输入最终费用。
• Enter your holiday events too, and see them on a calendar.
  也输入您的假期活动，并在日历上查看它们。

There are more instructions on the Holiday Planner page on my Contextures site

我的Contextures网站上的Holiday Planner页面上有更多说明。

见总结 (See the Summary)

On the Home sheet, there's a summary of your spending, plus a countdown of the days until the holiday arrives.

在首页上，您可以看到支出的摘要以及假期到来之前的倒数计时。

下载Excel假期计划器 (Download the Excel Holiday Planner)

To get a copy of the Excel Holiday Planner, go to the Holiday Planner page on my Contextures site. Scroll down to the Download section, and click the link to get the free workbook.

要获取Excel Holiday Planner的副本，请转到我的Contextures网站上的Holiday Planner页面 。 向下滚动到“下载”部分，然后单击链接以获取免费的工作簿。

The zipped file is in xlsm workbook, and contains a few simple macros for navigating through the workbook.

压缩文件位于xlsm工作簿中，并包含一些用于在工作簿中导航的简单宏。

翻译自: https://contexturesblog.com/archives/2017/11/30/excel-holiday-planner-workbook/