excel组合汇总_Excel汇总20160307

excel组合汇总

In this week's Excel roundup, Power Map, Excel formula errors, cell references, and more.

在本周的Excel综述中，Power Map，Excel公式错误，单元格引用等。

视频：Excel综述20160307 (Video: Excel Roundup 20160307)

Watch this video to see the highlights for Excel Roundup 20160307. The details and links are below the video.

观看此视频，以查看Excel Roundup 20160307的重点内容。详细信息和链接在视频下方。

演示地址

1. Excel公式问题 (1. Excel Formula Problems)

Is your VLOOKUP formula returning the wrong results? One simple thing can cause errors that you might not notice. The same problem can affect INDEX/MATCH formulas too.

您的VLOOKUP公式返回错误的结果吗？ 一件事可能会导致您可能不会注意到的错误。 同样的问题也会影响INDEX / MATCH公式。

2.免费的业务分析网络研讨会 (2. Free Business Analytics Webinars)

If you missed the recent PASS Business Analytics webinars, there's good news. The recordings are online now, so you can watch when you have some free time.

如果您错过了最近的PASS Business Analytics网络研讨会，那么有个好消息。 录音现在在线上 ，因此您可以在空闲时间观看。

3. Excel基础 (3. Excel Basics)

Ian Green's article is for auditors, but the difference between absolute and relative references is important for all Excel users to understand.

伊恩·格林(Ian Green)的文章适用于审计人员，但是绝对引用和相对引用之间的区别对于所有Excel用户都必须理解。

Another thing that can confuse Excel beginners is a workbook with the "handcuffs" on. On the Journal of Accountancy blog, J. Carlton Collins shows how to "unlock" a workbook like that. I'm surprised that the sheets weren't protected too.

会使Excel初学者感到困惑的另一件事是带有“手铐”的工作簿 。 在《会计学杂志》博客上，J。Carlton Collins展示了如何“解锁”这样的工作簿。 我很惊讶床单也没有受到保护。

4. Power BI (4. Power BI)

In another one of his cool and useful tricks, Ken Puls shows how to create bands in Power Query. For example, group overdue accounts by 0-30 days, 31-60 days, etc.

Ken Puls在他的另一个有趣又有用的技巧中，展示了如何在Power Query中创建乐队 。 例如，将过期的帐户按0-30天，31-60天等分组。

And who knew you could use Power Map to pick concert tickets? Gašper Kamenšek shows the steps, using Mick Jagger as an example.

谁知道您可以使用Power Map挑选演唱会门票 ？ GašperKamenšek展示了步骤，以Mick Jagger为例。

5. Excel for Scientists (5. Excel for Scientists)

This short profile of Andrew Willoughby shows that Excel is an important tool for plant scientists too.

安德鲁·威洛比(Andrew Willoughby)的简短介绍表明， Excel也是植物科学家的重要工具 。

And I think it would take a scientist or engineer to understand Nathan Brink's article on using Excel formulas for bilinear interpolation. It looks fascinating, but it certainly went way over my head!

而且我认为，需要科学家或工程师来理解Nathan Brink关于使用Excel公式进行双线性插值的文章。 看起来很迷人，但肯定已经超出我的头了！

6. Excel幽默 (6. Excel Humour)

Finally, for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets. Here's one of my favourite tweets from this week's collection.

最后，对于电子表格的一些幽默，您可以在我的每周推文集中看到人们对Excel 的评价 。 这是本周收藏中我最喜欢的推文之一。

翻译自: https://contexturesblog.com/archives/2016/03/07/excel-roundup-20160307/

excel组合汇总