excel组合汇总
If you have Excel, do you even need any other programs? In this week’s video, David Buchanan, from the Chef’s Resources website, shows how to use an Excel workbook to plan every step in an event, from the idea phase, to prep and ordering, to recipes. I like his description of this process as "mental mise en place" worksheets, to help you organize tasks.
如果您有Excel,您是否还需要其他程序? 在本周的视频中,Chef's Resources网站的David Buchanan展示了如何使用Excel工作簿来计划活动的每个步骤,从构思阶段到准备和点菜,再到食谱。 我喜欢他将这一过程描述为“就地进行工作”,以帮助您组织任务。
You can download some cooking-related workbook templates from their website too.
您也可以从其网站下载一些与烹饪相关的工作簿模板 。
Or watch on YouTube: Excel Event Planning for Chefs
或在YouTube上观看: Excel Chef的活动策划
语境帖子 (Contextures Posts)
Here’s what I posted recently:
这是我最近发布的内容:
Pivot tables are awesome, but they have a few problems. I created a list of my top 5 pivot table problems; what would you add?
数据透视表很棒,但是有一些问题。 我创建了我的前5个数据透视表问题的清单; 你会添加什么?
My office looks less cluttered, now that I’ve cleared most of the old computer books from my office shelves. Do you keep old manuals too?
现在,我已经从办公室的书架上清除了大部分旧计算机书籍 ,因此办公室看起来不再那么混乱。 您也保留旧手册吗?
I had problems testing VBA code; occasionally the F8 key didn't stop at the next line when troubleshooting. A registry change seems to have fixed the problem.
我在测试VBA代码时遇到问题; 故障排除时,有时F8键不会在下一行停止 。 注册表更改似乎已解决了该问题。
Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
最后,要幽默地窥视其他人对电子表格的看法,请在我的Excel Theater博客上阅读最新的Excel推文集 。
其他Excel文章 (Other Excel Articles)
Here are a few of the Excel articles that I read recently, that you might find useful:
以下是我最近阅读的一些Excel文章,您可能会发现它们很有用:
Annie Cushing made a video to show how to use INDEX, instead of OFFSET for marketing analysis. It’s worth a visit, just to see the cat picture.
Annie Cushing制作了一个视频,展示了如何使用INDEX而不是OFFSET进行营销分析。 值得一看,只是看猫的照片。
Bill Jelen shares formulas for creating a list of the alphabet, or Roman numerals
To save time, Sara Silverstein created custom chart templates, with all her favorite settings.
为了节省时间,Sara Silverstein使用她所有喜欢的设置创建了自定义图表模板 。
Summer is almost over, but there are still a few holidays left this year. Glen Feechan explains how to calculate working days, and account for upcoming holidays.
If you import data that has numbers formatted as text, Chandoo shares a quick tip for fixing them.
如果您导入数字格式为文本的数据,那么Chandoo会提供一个快速提示以解决这些问题 。
Seán Byrne shows that some OneDrive users have been hit by Excel file corruption when editing their workbooks online
SeánByrne显示,一些OneDrive用户在在线编辑其工作簿时受到Excel文件损坏的打击
If you like both Excel and geography, take a look at Erik Svensen's analysis of the Icelandic volcano Vatnajökull activity, using Excel's Power Map.
如果您同时喜欢Excel和地理,请使用Excel的Power Map查看Erik Svensen 对冰岛火山Vatnajökull活动的分析 。
Excel公告 (Excel Announcements)
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
这是与Excel相关的一些即将发生的事件,课程,最近出版的书籍以及其他新项目。
| Beginning Power BI with Excel 2013, by Dan Clark "Guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter." |
Registration has opened for this year's ModelOff competition. Test your financial modeling skills against top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York.
Note: A video starts to play automatically on the ModelOff site – turn off your speakers, if you don’t want to alarm your co-workers. | |
”In this completely updated edition covering Excel 2013 and previous versions, Microsoft Excel Functions and Formulas 3/e demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. A comprehensive CD-ROM accompanies the book with tips, video tutorials, shortcuts, and ready-made Excel formulas.” | |
101 Ready-to-Use Excel Formulas by Mike Alexander and Dick Kusleika ”The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented.” | |
”This is the first book to show the capabilities of Microsoft Excel to teach health services management statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical health services management problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you." |
| 用Excel 2013开始Power BI ,作者Dan Clark “指导您逐步完成分析和可视化数据的过程。BI培训专家,有关这些主题的定期演讲者Daniel R. Clark,将通过动手实践来逐步指导您使用各种工具,以巩固您的工作目标。您在每一章中都学到了。” |
今年的ModelOff竞赛已开始报名。 与来自世界各地的顶尖建模师一起测试您的财务建模技巧。 来自100多个国家/地区的参与者参加了两场在线资格赛,并在纽约举行了现场决赛活动。
注意:在ModelOff网站上,视频会自动开始播放–如果您不想使同事惊恐,请关闭扬声器。 | |
Microsoft Excel 2013函数和公式第三版。 由Bernd Held “在涵盖Excel 2013和以前版本的此完全更新的版本中,Microsoft Excel Functions and Formulas 3 / e通过使用实用且有用的示例以快速参考格式演示了Excel的秘密。 本书随附完整的CD-ROM,其中包含提示,视频教程,快捷方式和现成的Excel公式。” | |
“本书中的食谱经过结构设计,首先提出问题,然后提供公式解决方案,最后展示其工作原理,以便可以对其进行定制以满足您的需求。 本书的配套网站使读者可以轻松地测试公式,并视觉确认所提出的概念。” | |
Excel 2010 for Health Services Management Statistics ”这是第一本展示Microsoft Excel有效教授健康服务管理统计信息功能的书。 它是针对需要精通Excel解决实际卫生服务管理问题的学生和从业人员的循序渐进的练习指导。 如果理解统计数据不是您的最佳选择,或者您对数学的偏爱不是特别高,或者如果您对计算机保持警惕,那么这是适合您的书。” |
分享您的活动和文章 (Share Your Events and Articles)
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
如果您最近阅读或撰写了其他有趣的Excel文章,或者即将举行Excel活动,请在下面的评论中共享一个链接,并提供简要说明。 谢谢!
翻译自: https://contexturesblog.com/archives/2014/09/08/excel-roundup-20140908/
excel组合汇总