excel组合汇总_Excel汇总20140224

最新推荐文章于 2024-09-24 10:50:41 发布

culiao2169

最新推荐文章于 2024-09-24 10:50:41 发布

阅读量117

点赞数

文章标签： java python linux excel 大数据

原文链接：https://contexturesblog.com/archives/2014/02/24/excel-roundup-20140224/

版权

excel组合汇总

If your laptop screen is too small, maybe you’re ready for an 82” touch screen, or start a bit smaller (and maybe cheaper) with a 55” version.

如果您的笔记本电脑屏幕太小，则可能已经准备好安装82英寸的触摸屏，或者使用55英寸的触摸屏开始变小(也许更便宜)。

You can see Power Map in Excel on this giant screen, at the 7:15 mark, in the video below. My favourite moment is at 9:10, when the presenter says, “This is not the Excel spreadsheet I grew up with, that’s for sure.”

在下面的视频中，您可以在7:15标记处在这个巨大的屏幕上看到Excel中的Power Map。我最喜欢的时刻是9:10，演示者说：“可以肯定，这不是我长大的Excel电子表格。”

True! Excel was black and white only, with one sheet, when I started using it.

真正！当我开始使用Excel时，它仅是黑白的，只有一张纸。

VIDEO NO LONGER AVAILALBE

语境帖子 (Contextures Posts)

Here’s what I posted last week:

这是我上周发布的内容：

Shape Styles are flat in #Excel 2013, but you can change a setting to see rounded options, like the ones in Excel 2010.
形状样式在#Excel 2013中是平坦的，但是您可以更改设置以查看舍入的选项，例如Excel 2010中的选项。

After deleting items from a pivot table's source data, they can still appear in the pivot field drop downs. See how to remove them.
从数据透视表的源数据中删除项目后，它们仍可以出现在数据透视表字段下拉列表中。了解如何删除它们。

If an Excel file is linked to another workbook, you can break the links. If the Break Link button is not available, this might be why.
如果一个Excel文件链接到另一个工作簿，则可以断开链接。如果“断开链接”按钮不可用，这可能是原因。

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文章，您可能会发现它们很有用：

Are you an Excel Ninja? On the Lifehacker blog, Eric Ravenscraft shows you Four Skills That Will Turn You Into a Spreadsheet Ninja. The article links to my page on how to build a simple Order Form in Excel – so it must be good!
您是Excel忍者吗？在Lifehacker博客上，Eric Ravenscraft向您展示了将您变成电子表格忍者的四项技能。这篇文章链接到我的页面，该页面介绍了如何在Excel中构建简单的订购单 -一定很棒！

Winston Snyder shares his code for turning the field captions on and off in a pivot table. Tip: If it’s just the headings, “Row Labels” and “Column Labels” that you don’t like, change from Compact Layout to Tabular Layout.
温斯顿·斯奈德(Winston Snyder)共享他的代码，用于在数据透视表中打开和关闭字段字幕。提示：如果仅不喜欢标题，“行标签”和“列标签”，请从“紧凑布局”更改为“表格布局”。

Office 365 is one year old now, and Ed Bott finds that it has improved steadily since it was introduced.
Office 365 已有一年的历史了，Ed Bott发现自引入以来，它一直在稳步改进。

Annie Cushing gives us 18 real life examples of when and why you’d want to combine text from multiple cells.
Annie Cushing为我们提供了18个现实生活中的示例，说明了何时以及为什么要合并多个单元格中的文本。

Should they teach Excel programming in primary schools, instead of text based programming? Miles Berry explains why he likes the idea.
他们应该在小学教授Excel编程，而不是基于文本的编程吗？ Miles Berry解释了为什么他喜欢这个主意。

If you do any programming in Excel, you might discover a few new tips, as Colin Legg takes us on a guided tour of the VBA IDE’s options.
如果您在Excel中进行任何编程，则可能会发现一些新提示，因为Colin Legg带领我们参观了VBA IDE的选项。

I use Feedly for my RSS feeds, to find and read Excel articles. If you’re using it too, remember to download your OPML file, to create a backup of all your feeds. You never know when a reader will suddenly disappear (Yes, I mean you, Google Reader.)
我将Feedly用于我的RSS feed，以查找和阅读Excel文章。如果还使用它，请记住下载OPML文件，以创建所有提要的备份。您永远不会知道阅读器何时会突然消失(是的，我是说您，Google阅读器。)

Excel资源 (Excel Resources)

Here are some upcoming events, courses and new books, related to Excel.

以下是一些与Excel相关的活动，课程和新书。

Registration is open for the Amsterdam Excel Summit. The one-day event runs on May 14, 2014, and features sessions by several Excel MVPs, such as Bill Jelen (Mr. Excel), Ken Puls and Charles Williams. All the sessions are in English.
阿姆斯特丹Excel峰会现已开放注册。为期一天的活动于2014年5月14日开始，由多个Excel MVP(例如Excel先生的Bill Jelen，Ken Puls和Charles Williams)主持。所有会议均以英语进行。

Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP by Julitta Korol

Julitta Korol的Microsoft Excel 2013编程示例(使用VBA，XML和ASP)

The Amazon listing doesn’t have a “Look Inside” feature, and there aren’t any reviews yet, so I’m not sure what topics are covered. The book blurb says, “a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects.”

亚马逊列表中没有“向内看”功能，并且还没有任何评论，因此我不确定所涉及的主题。这本书脱口说，“一本有关Excel编程的实用指南，适合已经熟悉Excel用户界面的读者。本书通过许多多步的，有插图的动手练习来介绍编程概念。通过自定义项目介绍了更多高级主题。”