{"id":317,"date":"2015-04-08T15:14:00","date_gmt":"2015-04-08T19:14:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/?p=317"},"modified":"2015-04-08T16:07:49","modified_gmt":"2015-04-08T20:07:49","slug":"spreadsheet-roundup-20150408","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2015\/04\/08\/spreadsheet-roundup-20150408\/","title":{"rendered":"Spreadsheet Roundup 20150408"},"content":{"rendered":"<div class=\"d942c2121bfbd137a3b44056a000f09c\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- Responsive Top -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9531091850463532\"\r\n     data-ad-slot=\"6574318169\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>Here is a roundup of selected spreadsheet articles that I&#8217;ve read in the past month. You&#8217;ll find interesting tips, useful sample files, and new ideas for your own spreadsheets.<\/p>\n<p>If you have suggestions for next month&#8217;s roundup, please let me know. Thanks!<\/p>\n<p><!--more--><\/p>\n<h4>1. Progress Bar<\/h4>\n<p>On the Teacher Tech blog, Alice Keeler shows how to <a title=\"create a progress bar in Google Sheets\" href=\"http:\/\/www.alicekeeler.com\/teachertech\/2015\/04\/02\/progress-bar-in-google-sheets-minecraft-example\/\" rel=\"nofollow\">create a progress bar in Google Sheets<\/a>. She uses the Minecraft Challenge for her example.<\/p>\n<h4>2. Clustered Column Chart Alternatives<\/h4>\n<p>If you&#8217;re tired of seeing clustered column charts, especially the 3-D kind, you&#8217;ll get 6 new ideas from Ann K. Emery. She helped a colleague overhaul a chart, and wants to know <a href=\"http:\/\/annkemery.com\/clustered-bar-chart\/\" rel=\"nofollow\">which alternative you like the best<\/a>.<\/p>\n<h4>3. Spreadsheets in Education<\/h4>\n<p>In the <a title=\"Spreadsheets in Education journal\" href=\"http:\/\/epublications.bond.edu.au\/ejsie\/all_issues.html\" rel=\"nofollow\">Spreadsheets in Education journal<\/a>, you can read a variety of interesting articles, including &#8220;Divination: Using Excel to explore Ethnomathematics&#8221; (Vol. 8, Issue 1). Some of the articles have workbooks that you can download.<\/p>\n<h4>4. 7 Ways to Count<\/h4>\n<p>There are many functions for counting in Excel. I covered 7 ways to <a href=\"http:\/\/blog.contextures.com\/archives\/2015\/03\/26\/how-to-count-in-excel\/\">count in Excel<\/a>, with function tips and tricks.<\/p>\n<h4>5. New DAX formulas<\/h4>\n<p>Chris Webb shows <a href=\"https:\/\/cwebbbi.wordpress.com\/2015\/03\/19\/concatenatex-dax-function-in-excel-2016\/\">how to use CONCATENATEX<\/a> \u2013 one of the new DAX functions that you can use with Power Pivot in Excel 2016. If you sold apples to three customers, it will show all the names, separated by commas \u2013 Fred, Chris, Joe.<\/p>\n<h4><a name=\"announce\"><\/a>6. Best Excel forums<\/h4>\n<p><a href=\"http:\/\/dailydoseofexcel.com\/archives\/2015\/03\/27\/what-help-forum-would-you-recommend-and-why\/\">Which Excel forums do you use<\/a>, when you need help? Jeff Weir looks at some favourites, and the comments have great suggestions too. I still miss the old Microsoft newsgroups.<\/p>\n<h4>7. Pareto Chart to Track Habits<\/h4>\n<p>Matthew Eaton uses a simple table, and a <a href=\"http:\/\/www.mattheweatonwriter.com\/how-to-improve-writing-habits-with-one-easy-excel-chart\/\">Pareto chart, to track his personal habits<\/a>, and calculate his success rate.<\/p>\n<h4>8. Spreadsheet Bully<\/h4>\n<p>Is your <a href=\"http:\/\/www.businessinsider.in\/How-Im-learning-to-conquer-my-budget-the-monster-that-I-created\/articleshow\/46519826.cms\">budget spreadsheet a bully<\/a>? Kathleen Elkins, at Business Insider, found a way to conquer hers, and find a bit of happiness.<\/p>\n<h4>9. Visualize Data Without Excel<\/h4>\n<p>On LifeHacker, Rick Delgado shows 7 ways to <a href=\"http:\/\/www.lifehack.org\/articles\/productivity\/7-ways-visualize-data-without-excel.html\">visualize data without Excel<\/a>. How many of them really are &#8220;a better way&#8221;?<\/p>\n<h4>10. Pick a School<\/h4>\n<p>You might have seen college selection spreadsheets before, but Scott Gaul used a spreadsheet, and his data analysis skills, to <a title=\"select a kindergarten for his daughter\" href=\"http:\/\/trendct.org\/2015\/04\/07\/data-in-practice-i-made-a-kindergarten-spreadsheet-to-find-the-best-school-for-my-daughter\/\" rel=\"nofollow\">select a kindergarten for his daughter<\/a>.<\/p>\n<p>________________<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/04\/spreadsheetroundup20150408a.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"Spreadsheet Roundup -- April 2015  http:\/\/spreadsheet-day.com\/blog\/\/\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/04\/spreadsheetroundup20150408a_thumb.png\" alt=\"Spreadsheet Roundup -- April 2015  http:\/\/spreadsheet-day.com\/blog\/\/\" width=\"428\" height=\"428\" border=\"0\" \/><\/a><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Here is a roundup of selected spreadsheet articles that I&#8217;ve read in the past month. You&#8217;ll find interesting tips, useful sample files, and new ideas for your own spreadsheets. If you have suggestions for&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":316,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-317","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/comments?post=317"}],"version-history":[{"count":4,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/317\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/317\/revisions\/322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/316"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}