excel组合汇总
Forget that old-fashioned mouse! Now you can control Excel during a presentation, by using your phone. Well, assuming that you have Excel 2013, and a Windows phone.
忘了那只老式鼠标！ 现在，您可以使用手机在演示过程中控制Excel。 好吧，假设您拥有Excel 2013和Windows Phone。
There is a link to the Office Remote app download page in the Excel Articles section below.
在下面的“ Excel文章”部分中有指向Office Remote应用程序下载页面的链接。
语境帖子 (Contextures Posts)
Here’s what I posted last week:
这是我上周发布的内容：
Use MAX and IF with multiple criteria, to find the latest date that a product price was changed, for a specific customer.
将MAX和IF与多个条件一起使用 ，以查找特定客户的产品价格更改的最新日期。
Set up a pivot table so it shows missing items, and add temporary data, if necessary.
设置数据透视表，以显示丢失的项目 ，并在必要时添加临时数据。
No, it’s not the best way to present data, but if you have to make a pie chart, keep it simple and easy to read.
不，这不是呈现数据的最佳方法，但是如果您必须制作饼图 ，请使其简单易读。
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文章，您可能会发现它们很有用：
The IT Faculty of the Institute of Chartered Accountants in England & Wales has posted a draft version of their Twenty Principles for Good Spreadsheet Practice, and they would like your feedback.
英格兰和威尔士特许会计师协会的IT学院发布了他们的“电子表格良好行为二十项原则”的草稿，希望收到您的反馈。
Microsoft Research just released its Office Remote application, which lets you use your Windows phone to navigate through an Excel 2013 workbook during a presentation.
Microsoft Research刚刚发布了其Office Remote应用程序 ，该应用程序可让您在演示过程中使用Windows Phone浏览Excel 2013工作簿。
On the Visual.ly blog, someone shared their map of Australia and a column chart, both created by colouring worksheet cells.
在Visual.ly博客上，有人共享了他们的澳大利亚地图和柱形图 ，它们都是通过为工作表单元格着色而创建的。
It doesn’t have to be complicated! Learn an easy way to make bullet charts and boxplots in Excel, on the Excel Charts Blog
不必太复杂！ 在Excel Charts Blog上学习在Excel中制作项目符号图表和箱形图的简便方法
If you’re using APIs to pull data for Excel apps, be sure to format the numbers correctly. The Office Developer Team shares some sample code.
如果您使用API提取Excel应用程序的数据 ，请确保正确设置数字的格式。 Office开发人员团队共享一些示例代码。
Instead of using macros, add a hyperlink to a shape, for workbook navigation. Mynda Treacy shows the steps.
代替使用宏，而是将超链接添加到shape ，以进行工作簿导航。 Mynda Treacy显示了步骤。
When you’re programming an Excel file, it’s nice to have a quick way to open the workbook, with everything unlocked and ready to edit. Scott Lyerly shares his trick for adding a back door to your Excel files
在对Excel文件进行编程时，很高兴有一种快速的方法来打开工作簿，所有内容都已解锁并可以进行编辑。 斯科特·莱利(Scott Lyerly)分享了为Excel文件添加后门的技巧
Do you love pivot tables? Data journalist, Nassos Stylianou loves them too, and shares a few tips on the Digitally Focused blog.
你喜欢枢纽表吗？ 数据记者Nassos Stylianou也非常喜欢它们，并在Digitally Focused博客上分享了一些技巧 。
If you need to calculate the last day of any month, you can use Chandoo’s simple formula.
如果需要计算每个月的最后一天 ，则可以使用Chandoo的简单公式。
亚马逊上的新Excel图书 (New Excel Books on Amazon)
Here are the latest Excel books on Amazon. I did a technical edit on one of Conrad Carlberg’s books, long ago, and he always covers a topic clearly and completely.
这是亚马逊上最新的Excel书籍。 很久以前，我对康拉德·卡尔伯格(Conrad Carlberg)的其中一本书进行了技术编辑，而他始终清楚，完整地涵盖了一个主题。
I read the first chapter of Data Smart online, and was impressed that the author introduced INDEX and MATCH as key formulas. Then, a few paragraphs later, he touted VLOOKUP as “like MATCH on steroids”, so I’ll have to read more, to see where this ends up!
我在线阅读了Data Smart的第一章，并为笔者介绍了INDEX和MATCH作为关键公式而印象深刻。 然后，在几段之后，他吹捧VLOOKUP为“就像类固醇的MATCH”一样，所以我将不得不阅读更多内容，以了解最终结果！
“Carlberg guides you through using decision analytics to segment customers (or anything else) into sensible and actionable groups and clusters. Next, you’ll learn practical ways to optimize a wide spectrum of decisions in business and beyond—from pricing to cross-selling, hiring to investments—even facial recognition software uses the techniques discussed in this book!”
“卡尔伯格会指导您使用决策分析将客户(或其他任何对象)划分为明智且可行的群体和集群。 接下来，您将学习实用的方法来优化业务中的各种决策，从定价到交叉销售，从雇用到投资，甚至是面部识别软件都将使用本书中讨论的技术！”
Data Smart, by John W. Foreman
Data Smart ，作者：John W. Foreman
“Not to disillusion you, but data scientists are not mystical practitioners of magical arts. Data science is something you can do. Really. This book shows you the significant data science techniques, how they work, how to use them, and how they benefit your business, large or small. It's not about coding or database technologies. It's about turning raw data into insight you can act upon, and doing it as quickly and painlessly as possible.”
“不要幻灭你，但数据科学家不是魔术艺术的神秘实践者。 数据科学是您可以做的事情。 真。 本书向您展示了重要的数据科学技术，它们如何工作，如何使用它们以及它们如何使您的企业受益(无论大小)。 这与编码或数据库技术无关。 这是关于将原始数据转化为您可以采取行动的见解，并尽可能快速而轻松地完成。”
“This textbook, “Descriptive Statistics and Modern Data Analysis”, aims to familiarise students of economics and business as well as practitioners in firms with the basic principles, techniques, and applications of descriptive statistics and data analysis. Drawing on practical examples from business settings, it demonstrates the basic descriptive methods of univariate and bivariate analysis.”
“这本教科书“描述性统计和现代数据分析”旨在使经济学和商业专业的学生以及公司从业人员熟悉描述性统计和数据分析的基本原理，技术和应用。 借鉴业务环境中的实际示例，它演示了单变量和双变量分析的基本描述方法。”
你读了什么？ (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/2013/11/25/excel-roundup-20131125/
excel组合汇总