excel组合汇总
Mike Alexander is having a contest on his Bacon Bits blog – create an Excel meme, and you have a chance to win a couple of Mike’s books. The deadline is April 16th, and the rules are on Mike’s blog.
迈克·亚历山大(Mike Alexander)在他的“培根钻头(Bacon Bits)”博客上有一个竞赛- 创建一个Excel meme ，您就有机会赢得迈克的几本书。 截止日期是4月16日，规则在Mike的博客上发布。
If you aren’t sure what a meme is, Wikipedia describes it as an idea or picture that is shared on the internet. Mike posted a couple of examples on his blog, and here is my contribution. I’m sure you’ve met someone like this guy!
如果不确定模因是什么，Wikipedia会将其描述为在互联网上共享的想法或图片。 迈克在他的博客上发布了一些示例，这是我的贡献。 我敢肯定你已经遇到了像这样的人！
I made this in Excel, using the Insert Online Pictures command, and the text in WordArt. What can you come up with?
我在Excel中使用“插入在线图片”命令在文字艺术中创建了此文字。 你能拿出什么？
语境帖子 (Contextures Posts)
Here’s what I posted last week:
这是我上周发布的内容：
There's no superscript shortcut in #Excel, but you can use a macro to change marked text to superscript.
#Excel中没有上标快捷方式，但是您可以使用宏将标记的文本更改为上标 。
You can fix the date format in pivot table subtotals, so they match the other dates in the field..
Instead of merging cells, use formatting to centre headings over multiple columns.
与其合并单元格，不如使用格式将标题居中于多列。
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文章，您可能会发现它们很有用：
Chandoo reviewed the Excel for the iPad app, and you can watch his video to see his comments. If you don’t have an iPad, follow the link to the data visualization contest, and you could win one!
Chandoo检查了iPad应用程序的Excel ，您可以观看他的视频以查看他的评论。 如果您没有iPad，请点击数据可视化竞赛的链接，然后赢取一个！
Jon Acampora explains how to keep consistent formatting in a pivot chart, when filtering it with slicers.
There’s was lots of hype about this Excel replacement last week. One of the creators did quantum entanglement research, but thinks Excel is too complicated, and has too many functions.
上周有关此Excel替代品的宣传很多。 其中一位创造者进行了量子纠缠研究，但认为Excel太复杂，功能太多。
Ron de Bruin discovered that Excel 2013 will crash if you put the Paste and Transpose icon in the Quick Access Toolbar, then copy and use that button to paste into a new document.
罗恩·德·布鲁因(Ron de Bruin)发现，如果将“ 粘贴和转置”图标放在快速访问工具栏中，然后复制并使用该按钮粘贴到新文档中，则Excel 2013将崩溃。
- Jeff Rollins outlines the steps that a small company can take to move to a BI system in Microsoft Office, instead of using multi-colored Excel spreadsheets. 杰夫·罗林斯(Jeff Rollins)概述了小型公司可以采取的步骤，以迁移到Microsoft Office中的BI系统，而不是使用彩色Excel电子表格。
On Microsoft’s MVP blog, Glenna Shaw shows how to insert an Excel Table in a PowerPoint presentation, and use its advanced features there – even sparklines (a little choppy-looking) and conditional formatting.
在Microsoft的MVP博客上，Glenna Shaw展示了如何在PowerPoint演示文稿中插入Excel Table ，以及如何在其中使用其高级功能-甚至是迷你图(看起来有些断断续续)和条件格式。
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人，因此，如果您有兴趣，请立即注册。
The European Spreadsheet Risks Interest Group – EuSpRIG –has announced the preliminary program for Eursprig 2014. This event will be held in Delft (Netherlands) on July 3, 2104.
欧洲电子表格风险兴趣小组-EuSpRIG-宣布了2014年Eursprig的初步计划 。 这项活动将于2104年7月3日在荷兰代尔夫特举行。
Microsoft Excel 2013 Step By Step, by Curtis Frye. 512 pages, published April 10, 2014 Experience learning made easy—and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.
Microsoft Excel 2013 Step by Step (作者Curtis Frye)。 512页，发布于2014年4月10日轻松轻松地体验学习-并快速地教会自己如何使用Excel 2013进行数据的管理，分析和呈现。通过逐步，您可以设置步伐-在所需时间建立和练习所需的技能你他们！ 包括可下载的练习文件和配套的电子书。
Excel Dashboards and Reports for Dummies, by Mike Alexander. 336 pages, published March 31, 2014 Learn to: Analyze data and report it in a way that makes sense; slice and dice data from different perspectives; create eye-catching and understandable reports, visualizations, and dashboards; automate redundant reporting
Excel仪表板和假人报告 ，作者：Mike Alexander。 336页，发布于2014年3月31日了解如何：以有意义的方式分析和报告数据； 从不同角度对数据进行切片和切块； 创建醒目的且易于理解的报告，可视化效果和仪表板； 自动执行冗余报告
Dashboarding and Reporting with Power Pivot and Excel, by Kasper de Jonge. 195 pages, published April 1, 2014 This book, written by a member of Microsoft’s Power Pivot team, provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Excel, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports.
Kasper de Jonge撰写的Power Pivot和Excel仪表板和报告 。 195页，出版于2014年4月1日，该书由Microsoft Power Pivot团队的成员撰写，提供了有关创建财务仪表盘的实用分步指南。 本书详细介绍了如何合并和成形相关数据，如何在Excel中构建仪表板，提供布局和设计技巧与窍门，准备模型以使用会计日期以及如何显示许多财务报告中使用的值。
您读或写了什么？ (What Did You Read or Write?)
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文章，并希望与他人分享，请在下面添加评论，或给我发送电子邮件。 请提供简短说明和文章链接。
翻译自: https://contexturesblog.com/archives/2014/04/14/excel-roundup-20140414/
excel组合汇总
扫一扫
41
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
