excel组合汇总
In The Guardian's Data Blog column, where the tagline is "Facts are Sacred", things took a less lofty turn last week. You can go back to the good old days in math class, where you entertained your friends by writing words on your calculator.
在《卫报》的“数据博客”一栏中,标语是“事实是神圣的”,上周情况有所好转。 您可以回到数学课堂上的美好时光,在那里您可以通过在计算器上书写文字来招待朋友。
In the screen shot below, you can see the cheerful greeting from our Sharp Compet CS-1130 financial calculator. I’m not sure how old it is, but it’s probably from the 1980s, and still working well. Are you still using an old school calculator?
在下面的屏幕截图中,您可以看到我们的Sharp Compet CS-1130金融计算器发出的欢快问候。 我不确定它的年龄,但它可能是1980年代的,并且仍然运行良好。 您还在使用旧式计算器吗?
语境帖子 (Contextures Posts)
Here’s what I posted last week:
这是我上周发布的内容:
Calculate upcoming anniversaries for employee hire dates, and highlight them with Excel conditional formatting.
计算员工雇用日期的即将到来的周年纪念日 ,并使用Excel条件格式突出显示它们。
Dynamic date range filters aren't available in pivot table Report Filters -- only in Row and Column filters. Use this workaround show a date range, without the date details.
动态日期范围过滤器在数据透视表报表过滤器中不可用-仅在行和列过滤器中可用。 使用此替代方法可显示日期范围,而不包含日期详细信息。
There’s a new sample file in my Excel UserForm course, with search boxes that let you find specific records, then update or delete them.
我的Excel UserForm课程中有一个新的示例文件,带有搜索框,可让您查找特定的记录,然后进行更新或删除。
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文章 (More Excel Articles)
Here are a few of the Excel articles that I read last week, that you might find useful:
以下是我上周阅读的一些Excel文章,您可能会发现它们很有用:
Apparently there is a problem with promiscuous spreadsheet headings, especially in the government. Were you aware of this? Are you guilty of this bad behaviour?
显然, 电子表格标题混杂不清 ,尤其是在政府中。 你意识到这点了吗? 您对这种不良行为有罪吗?
On the Data Scopic blog, Oz du Soleil asks a few spreadsheet experts, where are Excel & Google Spreadsheet Headed? You can read Part 1 and Part 2
在Data Scopic博客上,Oz du Soleil问了一些电子表格专家,Excel和Google Spreadsheet的标题在哪里? 您可以阅读第1 部分和第2部分
Mike Alexander shares a handy tip for copying just the data from a website into Excel, without all the hyperlinks, icons, and other junk.
Mike Alexander分享了一个方便的技巧,可以将网站中的数据仅复制到Excel中 ,而无需所有超链接,图标和其他垃圾。
I saw this Balance Baltimore's Budget link in Jeff Leek's Simply Statistics blog. Maybe could could build something similar in Excel, for your company budget.
我在Jeff Leek的Simply Statistics博客中看到了Bal Balmoremore的Budget链接。 也许可以为您的公司预算在Excel中构建类似的内容。
Power BI文章 (Power BI Articles)
It was a busy week for articles about Microsoft’s Power BI tools, so I’ve given them a separate section. Also, see the 24 Hour PASS webinars in the Upcoming Courses section, below.
这是有关Microsoft Power BI工具的文章的忙碌一周,因此我给了他们一个单独的部分。 另外,请参阅下面“即将上线的课程”部分中的“ 24小时通行证”在线讲座。
Maybe this is what prompted all the articles -- Microsoft announced its Power BI pricing last week, and you can see the plans and prices here.
Chris Webb comments on the Power BI costs, and compares them with other BI tools.
克里斯·韦伯(Chris Webb) 对Power BI成本进行了评论 ,并将其与其他BI工具进行了比较。
Dick Moffatt describes the challenges and satisfaction of moving a high-maintenance Excel solution to a zero-maintenance PowerPivot model. Take a minute and leave a comment, to let Dick know what you think.
Dick Moffatt描述了将高维护性Excel解决方案移至零维护PowerPivot模型的挑战和满意度。 花一点时间发表评论,让Dick知道您的想法。
即将开设的课程 (Upcoming Courses)
No matter how long you’ve been using Excel, there’s always something new to learn.
不管您使用Excel多久,总会有一些新东西要学习。
Sign up for one or more of the free Business Analytics webinars offered in the 24 Hour PASS series, sponsored by Microsoft, Cisco and Dell. Topics inlclude: "Advanced Analytics in Excel 2013", "Querying in DAX", and"Predictive Analytics for Absolute Beginners". The online sessions run on Feb 5th and 6th, and you can see the schedule here: 24 Hour PASS Schedule
报名参加由微软,思科和戴尔赞助的24小时通行证系列中提供的一项或多项免费的Business Analytics网络研讨会。 主题包括:“ Excel 2013中的高级分析”,“ DAX中的查询”和“绝对初学者的预测性分析”。 在线会议于2月5日和6日举行,您可以在此处查看时间表: 24小时通行证时间表
- Mynda Treacy’s Excel Dashboard course opens for registration tomorrow, Jan 14th. I highly recommend this online course, which has excellent content, and great student support from Mynda. Click the banner below, for more information. Mynda Treacy的Excel Dashboard课程将于1月14日明天开始注册。 我强烈推荐此在线课程,该课程内容丰富,并获得了Mynda的大力支持。 单击下面的横幅,以获取更多信息。
你读了什么? (What Did You Read?)
If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below. Please include a brief description, and a link to the article. __________________________________
如果您想在上周阅读其他有趣的Excel文章,请在下面添加评论。 请提供简短说明和文章链接。 __________________________________
翻译自: https://contexturesblog.com/archives/2014/01/13/excel-roundup-2014013/
excel组合汇总