excel组合汇总_Excel汇总20140120

excel组合汇总

If you’ve ever been disgruntled with your bank, you might enjoy Ben Orlin’s vision of how he would run a bank, on his Math With Bad Drawings blog. Instead of annual compounding, he’ll offer other options, such as:

如果您曾经对银行不满，可以在他的Math With Bad Drawings博客上欣赏Ben Orlin 关于他将如何经营一家银行的愿景。 除了提供年度收益外，他还将提供其他选择，例如：

• Compounded Madoff-ly: After years of dubiously high interest, it will come out that I’m just typing random numbers into the spreadsheet.

  复合Madoff-ly ： 经过多年的高度怀疑后，结果就是我只是在电子表格中输入随机数。

• Compounded sporadically: Your balance grows whenever I remember to update the spreadsheet.

  偶尔复合 ： 每当我记得要更新电子表格时，您的余额就会增加。

Each option is illustrated with a bad drawing, like this one.

每个选项都用一个不好的图来说明，就像这样。

语境帖子 (Contextures Posts)

Here’s what I posted last week:

这是我上周发布的内容：

• Use a macro to link worksheet check boxes to specific cells, so you can track the responses.

  使用宏将工作表复选框链接到特定的单元格，以便您可以跟踪响应。

• Then, assign a macro to each check box, so it enters the current date when checked.

  然后， 为每个复选框分配一个宏 ，以便在选中时输入当前日期。

• Change a pivot table layout to see which customers have not purchased your products.

  更改数据透视表布局以查看哪些客户尚未购买您的产品。

• Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

  最后，要幽默地窥视其他人对Excel的看法，请在我的Excel Theater博客上阅读本周的Excel推文集 。

其他Excel文章 (Other Excel Articles)

Here are a few of the Excel articles that I read last week, that you might find useful:

以下是我上周阅读的一些Excel文章，您可能会发现它们很有用：

• On the Digital Forensics Stream blog, Jason Hale shows how to find the last saved location of an Excel 2013 file.

  在Digital Forensics Stream博客上，Jason Hale显示了如何查找 Excel 2013文件的最后保存位置 。

• At the Daily Dose of Excel blog, Jeff Weir makes a case for investing in corporate Excel training, and you can add your opinion in the comments.

  在Excel的Daily Dose博客上，Jeff Weir提供了对公司Excel培训进行投资的理由，您可以在评论中添加您的意见。

• Alex Roe, in the Italy Chronicles blog, wonders if Excel can save Italy, as one of their political leaders suggested.

  意大利纪事报博客中的亚历克斯·罗伊(Alex Roe)怀疑Excel是否可以如其政治领导人之一所建议的那样拯救意大利 。

• If you’re looking for an art project to keep you busy this winter, see what they created at Maison H & H – a wall hanging based on an Excel worksheet.

  如果您正在寻找一个艺术项目来让这个冬天忙碌，请查看他们在Maison H＆H创作的作品- 基于Excel工作表的壁挂式作品 。

• Instead of creating a long concatenation formula, Chandoo shares a quick trick for combining the values in multiple cells.

  Chandoo没有创建一个长的串联公式，而是分享了一个快速技巧，可以将多个单元格中的值组合在一起 。

• Dennis Wallentin recommends that every serious Excel developer should read the VBA Enumeration Database article that’s in the CodeProject newsletter.

  Dennis Wallentin建议每个认真的Excel开发人员都应阅读 CodeProject新闻通讯中的VBA枚举数据库文章 。

• Winston Snyder couldn’t find a pivot table style that he liked, so he wrote a macro to format specific ranges in the table.
  Winston Snyder找不到他喜欢的数据透视表样式，因此他编写了一个宏来格式化表中的特定范围。

即将开设的课程 (Upcoming Courses)

No matter how long you’ve been using Excel, there’s always something new to learn.

不管您使用Excel多久，总会有一些新东西要学习。

• Sign up for one or more of the free Business Analytics webinars offered in the 24 Hour PASS series, sponsored by Microsoft, Cisco and Dell. Topics inlclude: "Advanced Analytics in Excel 2013", "Querying in DAX", and"Predictive Analytics for Absolute Beginners". The online sessions run on Feb 5th and 6th, and you can see the schedule here: 24 Hour PASS Schedule

  报名参加由微软，思科和戴尔赞助的24小时通行证系列中提供的一项或多项免费的Business Analytics网络研讨会。 主题包括：“ Excel 2013中的高级分析”，“ DAX中的查询”和“绝对初学者的预测性分析”。 在线会议于2月5日和6日举行，您可以在此处查看时间表： 24小时通行证时间表

• Mynda Treacy’s Excel Dashboard course is open for registraion, and I highly recommend this online course, which has excellent content, and great student support from Mynda. Click the banner below, for more information.
  Mynda Treacy的Excel Dashboard课程已开放注册，我强烈推荐此在线课程，该课程内容丰富，并得到Mynda的大力支持。 单击下面的横幅，以获取更多信息。

你读了什么？ (What Did You Read?)

If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.

如果您想在上周阅读其他有趣的Excel文章，请在下面添加评论。

Please include a brief description, and a link to the article.

请提供简短说明和文章链接。

翻译自: https://contexturesblog.com/archives/2014/01/20/excel-roundup-20140120/

excel组合汇总