excel组合汇总_Excel汇总20140317

最新推荐文章于 2024-09-15 22:31:42 发布

culiao2169

最新推荐文章于 2024-09-15 22:31:42 发布

阅读量73

点赞数

文章标签： python java 编程语言 github android

原文链接：https://contexturesblog.com/archives/2014/03/17/excel-roundup-20140317/

版权

excel组合汇总

Excel汇总20140317 (Excel Roundup 20140317)

Happy St. Patrick’s Day! Four years ago, we celebrated by

creating Ireland’s flag in Excel.

在Excel中创建爱尔兰的国旗来庆祝。

The flag is a simple column chart, with the 3 columns coloured to match the flag’s design. It’s an easy project, so you’ll be done in time to go out to celebrate.

该标志是一个简单的柱形图，其3列的颜色与标志的设计相匹配。这是一个简单的项目，所以您会及时完成庆祝活动。

Irish flag in Excel blog.contextures.com/

The blog post also has a video of some festive Canadian Irish music, featuring Great Big Sea, playing with The Chieftains.

博客文章中还包含一段与加拿大酋长队一起演奏的加拿大节日音乐的视频，其中包括大大海(Great Big Sea)。

I’ve linked to it again this year, at the end of this post. The music will get your toes tapping, while you work on Excel projects today.

我在这篇文章的结尾处再次链接到了它。当您今天处理Excel项目时，音乐将使您的脚趾轻拍。

语境帖子 (Contextures Posts)

Here’s what I posted last week:

这是我上周发布的内容：

After applying an AutoFilter, use this trick to show the top 10 values in the visible rows.
应用自动筛选后，请使用此技巧在可见的行中显示前10个值。

If the items in a pivot table Report Filter drop down are out of order, here's how to sort them.
如果数据透视表“报表过滤器”下拉列表中的项目乱序，请按以下步骤进行排序。

Roger Govier shared his technique for creating multiple dependent drop downs, based on Excel tables.
Roger Govier分享了他基于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文章，您可能会发现它们有用：

Did you read any of the articles that explained how Steve Ballmer, Microsoft’s former CEO, used Excel to balance his work and family time? He said “a spreadsheet”, but I’m sure he meant Excel. Or could he still be using MultiPlan?
您是否阅读过任何说明Microsoft前首席执行官史蒂夫·鲍尔默(Steve Ballmer)如何利用Excel平衡工作和家庭时间的文章？他说“电子表格”，但我确定他的意思是Excel。还是他仍然可以使用MultiPlan？

The FrankensTeam did a guest post on Jon Peltier’s blog, showing their approach to plotting gaps in Excel charts.
FrankensTeam在Jon Peltier的博客上做客座文章，展示了他们在Excel图表中绘制差距的方法。

Jon Acampora recommends the best keyboards if you like to use Excel's keyboard shortcuts. My laptop looks like most of the "bad" pictures in the article.
如果您想使用Excel的键盘快捷键，Jon Acampora建议使用最好的键盘。我的笔记本电脑看起来像文章中的大多数“坏”图片一样。

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, and the limit is 100 participants, so sign up now, if you’re interested.
阿姆斯特丹Excel峰会现已开放注册。为期一天的活动于2014年5月14日开始，由多个Excel MVP(例如Excel先生的Bill Jelen，Ken Puls和Charles Williams)主持。所有课程均以英语授课，参加人数上限为100人，如果您有兴趣，请立即注册。

你读了什么？ (What Did You Read?)

If you read (or wrote) any other interesting Excel articles recently, that you’d like to share, please add a comment below, or send me an email. Please include a brief description, and a link to the article.

如果您最近想阅读(或写过)您想分享的其他有趣的Excel文章，请在下面添加评论，或给我发送电子邮件。请提供简短说明和文章链接。