excel组合汇总_Excel汇总20150525

excel组合汇总

In this week's roundup, see how to reverse last and first names, pin a shape to a chart point, learn some Solver history, and more.

在本周的综述中，了解如何反转姓氏和名字，将形状固定到图表点，了解一些规划求解历史，以及更多。

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

如果您最近阅读或撰写了其他有趣的Excel文章，或者即将举行Excel活动，请告诉我。 谢谢！

1.上下文帖子 (1. Contextures Posts)

In case you missed them, here are the articles that I posted recently:

如果您错过了它们，这是我最近发布的文章：

• This short video shows 7 ways to count in Excel -  you can count numbers, all data, based on criteria + more

  这段简短的视频展示了7种在Excel中进行计数的方法 -您可以根据标准和更多信息对数字，所有数据进行计数

• For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

  要幽默地窥视其他人对电子表格的看法，请在我的Excel Theater博客上阅读最新的Excel推文集 。

2.颠倒名字和姓氏 (2. Reverse First and Last Names)

Ben Kusmin uses find and replace, and a formula, to reverse first and last names in a column. If you're using Excel 2013, you could use the Flash Fill feature, to quickly reverse the names.

Ben Kusmin使用查找和替换以及一个公式来反转column中的名字和姓氏 。 如果您使用的是Excel 2013，则可以使用Flash Fill功能来快速反转名称。

On my Contextures site, I show how you can reverse the names with a formula too.

在我的Contextures网站上，我展示了如何也可以使用公式来反转名称 。

3.在图表上粘贴形状 (3. Stick a Shape on a Chart)

Jon Peltier shares a simple trick for adding a shape to a point on a chart, and making it stick to that point, even when it moves.

乔恩·Perl捷(Jon Peltier)分享了一个简单的技巧，即在图表上的一个点上添加形状，并使其紧贴该点 (即使移动)。

4.享受挑战 (4. Enjoy the Challenge)

Long ago, Andrew Wulf built a spreadsheet program named Trapeze, and he still loves a good programming challenge. So, don't let those complex formulas, or that VBA code defeat you -- "The next time impossible stares you in the face, stare back."

很久以前，安德鲁·沃夫(Andrew Wulf)建立了一个名为Trapeze的电子表格程序，他仍然热爱编程方面的挑战 。 因此，不要让那些复杂的公式或VBA代码打败您-“下一次不可能的凝视您，凝视您。”

5.一点历史 (5. A Little History)

If you use Solver in Excel, and/or are interested in Excel's history, listen to Chandoo's interview with Dan Fylstra, who created Solver

如果您在Excel中使用Solver，和/或对Excel的历史感兴趣，请收听Chandoo对创建Solver的Dan Fylstra的采访

And speaking of history, Bill Kamm looks at how baseball and its statistics have changed, since his dad played for the White Sox, back in the 1920s and 30s. Fortunately, you can do the analysis in a spreadsheet now, instead of with pencil and paper.

说到历史，比尔·卡姆(Bill Kamm)回顾了自从他父亲在1920年代和30年代为白袜队踢球以来棒球及其统计数据的变化 。 幸运的是，您现在可以在电子表格中进行分析，而不用铅笔和纸进行分析。

6.创建一个Excel加载项 (6. Create an Excel Add-In)

If you've ever wanted to build your own Excel add-in, to store some of your favourite macros, Chris Newman shows you the steps.

如果您曾经想构建自己的Excel加载项来存储一些您喜欢的宏，Chris Newman会向您显示这些步骤。

7.清除错误 (7. Clear the Errors)

If you delete columns, or rows, or an entire worksheet, John Michaloudis shows how to clear the cells that might end up showing #REF! errors.

如果删除列，行或整个工作表，John Michaloudis将显示如何清除可能最终显示#REF！的单元格。 错误 。

8.编写仪表板 (8. Writing Dashboard)

Previously, we saw how Matthew Eaton uses Excel to keep track of his daily writing. Now he has created a dashboard, to summarize his progress. If you don't like purple, you can use a different colour.

以前，我们了解了Matthew Eaton如何使用Excel跟踪他的日常写作。 现在他创建了一个仪表板，以总结他的进度 。 如果您不喜欢紫色，则可以使用其他颜色。

9.推送到Excel (9. Push to Excel)

If you're working with data from a database, or another Excel file, Winston Snyder shows how to use VBA to push that data to Excel, and create a pivot table.

如果您正在使用数据库或其他Excel文件中的数据，Winston Snyder将说明如何使用VBA将数据推送到Excel并创建数据透视表。

10.新的图表类型 (10. New Chart Types)

Jorge Camoes shows the new chart types that will be in Excel 2016, and wishes there were more additions, like small multiples.

Jorge Camoes显示了将在Excel 2016中使用的新图表类型 ，并希望有更多的添加项，例如小的倍数。

If you're not sure what that means, Wikipedia explains what small multiples are. I Googled that "for a friend."

如果你不知道意思，维基百科解释了什么小倍数 。 我用Google搜索“是为了给朋友”。

翻译自: https://contexturesblog.com/archives/2015/05/25/excel-roundup-20150525/

excel组合汇总