excel组合汇总_Excel汇总20150608

excel组合汇总

In this week's roundup, build a nested IF formula, improve your dashboards, work with dates, and change a pivot table layout.

在本周的综述中，构建嵌套的IF公式，改进仪表板，使用日期，并更改数据透视表的布局。

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:

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

• Use the keyboard, or right-click menus, to move fields in a pivot table layout without dragging

  使用键盘或右键单击菜单可移动数据透视表布局中的字段而无需拖动

• 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.课堂上的Excel (2. Excel in the Classroom)

If math teacher Mohammed Ladak could only use one piece of software in his classroom, he would choose Excel. See a few examples of how he uses it in lessons.

如果数学老师穆罕默德·拉达克(Mohammed Ladak)在教室里只能使用一种软件，那么他会选择Excel。 请参阅他在课程中如何使用它的一些示例 。

3.将仪表板提升到新的水平 (3. Take Dashboard to Next Level)

Watch a video presentation by Stephen Hughes, on Taking Dashboards to the Next Level, hosted by the Excel BI Virtual Chapter of the PASS BA Conference. The video is about an hour long, and the presentation starts at the 4:00 mark.

观看斯蒂芬·休斯(Stephen Hughes)的视频演示，该视频由PASS BA大会的Excel BI虚拟分会主持，介绍了如何将仪表板提升到一个新水平 。 视频大约一个小时，演示从4:00点开始。

4.处理日期 (4. Work With Dates)

Doug Jenkins takes a detailed look at how Excel handles the display and entry of dates, and how they're affected by regional settings.

道格·詹金斯(Doug Jenkins)详细研究了Excel如何处理日期的显示和输入以及它们如何受到区域设置的影响。

5.设置Excel选项 (5. Setting Excel Options)

Sumit Bansal shares a few tips for making it easier to work in your Excel files. It's easier to change settings for #3 and #6 on the Ribbon, and use that manual calculation setting with caution!

Sumit Bansal分享了一些使您可以更轻松地在Excel文件中工作的提示。 更改功能区上的＃3和＃6设置更容易，并谨慎使用该手动计算设置！

6.建立嵌套的IF公式 (6. Build Nested IF Formulas)

Glen Feechan breaks down the steps for building a nested IF formula on the worksheet.

Glen Feechan分解了在工作表上构建嵌套IF公式的步骤。

There are simple IF and nested IF examples on my IF function page.

我的IF函数页面上有简单的IF和嵌套的IF 示例 。

7.查找最后一个表行 (7. Find Last Table Row)

Excel programming can get a bit tricky, when you're working with named tables. Zack Barresse shares his sample code to find the last row or column that is part of a named table.

使用命名表时，Excel编程可能会有些棘手。 Zack Barresse分享了他的示例代码，以查找命名表的最后一行或最后一列 。

8.修正图表差距 (8. Fix the Chart Gap)

Ann K Emery shows how to make columns in a chart closer together. It's a simple step, but can make a big improvement in the chart's appearance.

Ann K Emery展示了如何使图表中的各列更靠近 。 这是一个简单的步骤，但是可以大大改善图表的外观。

9.回答问题 (9. Answer What If Questions)

Mary Ann Richardson sets up a two-variable data table, to get the answer to a "What If" question, then adds conditional formatting, to highlight the top 10 and bottom 10 results.

玛丽·安·理查森(Mary Ann Richardson) 设置了一个两变量数据表 ，以获取“假设”问题的答案，然后添加条件格式，以突出显示前10名和后10名的结果。

You can see another example, and a one-variable data table, on my Contextures website.

您可以在Contextures网站上看到另一个示例和一个单变量数据表 。

10. Power Query中的文本函数 (10. Text Functions in Power Query)

Ken Puls builds text functions in Power Query, to match the Excel's built-in worksheet functions.

Ken Puls 在Power Query中构建文本函数 ，以匹配Excel的内置工作表函数。

翻译自: https://contexturesblog.com/archives/2015/06/08/excel-roundup-20150608/

excel组合汇总