excel组合汇总

Welcome back, and I hope you enjoyed your holiday break! It's taking most of my brain power to type 2016, instead of 2015, so this will be a short roundup, to get things rolling again. If you subscribe to my newsletter, the next issue will be sent on January 12, 2016.

欢迎回来，希望您度过了一个愉快的假期！我的大部分脑力都在输入2016年而不是2015年，所以这将是简短的综述，以使事情重新开始。如果您订阅我的新闻通讯，下一期将在2016年1月12日发送。

1.上下文网站 (1. Contextures Website)

Over the holidays, I cleaned up some of the older pages, and added a new page with Check Box macros. Thanks to Dave Peterson, for his contributions!

在假期中，我清理了一些较旧的页面，并添加了一个带有Check Box宏的新页面。感谢Dave Peterson的贡献！

Also, the table of contents page was getting way too long, so I changed a few of the topics into drop down lists. If a topic has a plus sign beside it, click it to see the related page links.

另外，目录页面太长了，因此我将一些主题更改为下拉列表。如果主题旁边有加号，请单击它以查看相关的页面链接。

2. VisiCalc (2. VisiCalc)

In The Guardian, John Naughton explains why "VisiCalc was a ‘killer app’ years ahead of its time, and still says much about the way we understand computers".

约翰·诺顿(John Naughton)在《卫报》中解释了“为什么VisiCalc是比其时代早几年的“杀手级应用” ，而且仍然对我们理解计算机的方式有很多说明”。

3.数据清理 (3. Data Cleanup)

Ben Richardson shows how to use formulas when working with website data, for Search Engine Optimization (SEO). His tips are useful for most other types of data too, so take a look, even if you don't know what SEO is.

本·理查森(Ben Richardson)展示了如何在处理网站数据时使用公式进行搜索引擎优化(SEO)。他的技巧对大多数其他类型的数据也很有用，即使您不知道SEO是什么，也请看一下。

4. Excel日历 (4. Excel Calendar)

If you forgot to buy new calendars for 2016, you can download the "create your own calendar" file from The Analyst Cave. Then, enter a few settings, add a list of holidays, and enter any special dates, such as family birthdays. Finally, click the Generate button, to build the calendar.

如果您忘记购买2016年的新日历，则可以从The Analyst Cave 下载“创建自己的日历”文件。然后，输入一些设置，添加假期列表，然后输入任何特殊日期，例如家庭生日。最后，单击“生成”按钮以构建日历。

5.功率查询 (5. Power Query)

Ken Puls explains 3 more join types that you can use in Power Query – Inner Join, Left Anti Join and Right Anti Join. Download the sample file, and follow along with the steps.

Ken Puls解释了可以在Power Query中使用的另外 3 种联接类型 –内部联接，左反联接和右反联接。下载示例文件，并按照步骤进行操作。