{"id":339,"date":"2015-06-03T00:01:00","date_gmt":"2015-06-03T04:01:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/?p=339"},"modified":"2016-09-02T09:16:11","modified_gmt":"2016-09-02T13:16:11","slug":"spreadsheet-roundup-20150603","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2015\/06\/03\/spreadsheet-roundup-20150603\/","title":{"rendered":"Spreadsheet Roundup 20150603"},"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>For a weekly Excel Roundup, please <a title=\"Contextures Blog\" href=\"http:\/\/blog.contextures.com\/\" rel=\"nofollow\">visit my Contextures blog<\/a>.<\/p>\n<p>If you have suggestions for next month&#8217;s spreadsheet roundup, please let me know. Thanks!<\/p>\n<p><!--more--><\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/06\/spreadsheetroundup20150603b.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 -- June 2015  http:\/\/spreadsheet-day.com\/blog\/\/\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/06\/spreadsheetroundup20150603b_thumb.png\" alt=\"Spreadsheet Roundup -- June 2015  http:\/\/spreadsheet-day.com\/blog\/\/\" width=\"390\" height=\"197\" border=\"0\" \/><\/a><\/p>\n<h4>1. Spreadsheets For Journalists<\/h4>\n<p>Journalist Patrick Garvin uses <a title=\"spreadsheets to make his job easier\" href=\"http:\/\/patrickgarvin.com\/blog\/?p=1818\" rel=\"nofollow\">spreadsheets to make his job easier<\/a><\/p>\n<h4>2. Choose a Chart Type<\/h4>\n<p>To select a chart type will work best for your data, use Ann Emery&#8217;s <a href=\"http:\/\/annkemery.com\/essentials\/\">Chart Choosing Tool<\/a>. Click a filter at the top, such as &#8220;Do-able in Excel&#8221;, to see the chart types in that category.<\/p>\n<h4>3. Better Spreadsheet Models<\/h4>\n<p>Jordan Goldmeier explains how to create better spreadsheet models.\u00a0 The article is a summary of one of his presentations at the recent PASS BA Conference.<\/p>\n<h4>4. How To Count<\/h4>\n<p>This short <a href=\"http:\/\/blog.contextures.com\/archives\/2015\/05\/21\/counting-in-excel\/\">video shows 7 ways to count in Excel<\/a>\u00a0 &#8212; count numbers, all data, based on criteria, and other things.<\/p>\n<h4>5. Dot Graphs<\/h4>\n<p>If you rarely, or never, make dot graphs, Maarten Lambrechts shares <a href=\"http:\/\/www.maartenlambrechts.be\/to-the-point-7-reasons-you-should-use-dot-graphs\/\">7 reasons why you should<\/a>.<\/p>\n<h4>6. Create Pixel Art<\/h4>\n<p>Alice Keeler shows how students can <a title=\"create pixel art in Google sheets\" href=\"http:\/\/www.alicekeeler.com\/teachertech\/2015\/05\/24\/google-sheets-create-pixel-art\/\" rel=\"nofollow\">create pixel art in Google sheets<\/a>, either with fill color or conditional formatting<\/p>\n<h4>7. Excel Book Sampler<\/h4>\n<p>Que Publishing has a <a href=\"http:\/\/www.quepublishing.com\/promotions\/mrexcel-series-from-que-publishing-139834\">free sampler of Excel books<\/a> that you can download. The book is over 200 pages, and contains chapters from 8 books, for a range of skills levels, from beginner to advanced.<\/p>\n<h4>8. Design First<\/h4>\n<p>Paul Mireault advocates <a title=\"designing a spreadsheet first\" href=\"http:\/\/www.felienne.com\/archives\/3870\" rel=\"nofollow\">designing a spreadsheet first<\/a>, before you start building it.<\/p>\n<h4>9. Enjoy the Challenge<\/h4>\n<p>Many years ago, Andrew Wulf built the Trapeze spreadsheet program, and he still <a href=\"http:\/\/thecodist.com\/article\/programming_without_a_net\">loves a good programming challenge<\/a>. So, don&#8217;t let those complex formulas defeat you &#8212; &#8220;The next time impossible stares you in the face, stare back.&#8221;<\/p>\n<p>________________<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/06\/spreadsheetroundup20150603a.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 -- June 2015  http:\/\/spreadsheet-day.com\/blog\/\/\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/06\/spreadsheetroundup20150603a_thumb.png\" alt=\"Spreadsheet Roundup -- June 2015  http:\/\/spreadsheet-day.com\/blog\/\/\" width=\"320\" height=\"319\" 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. For a weekly Excel Roundup,&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":338,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-339","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\/339","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=339"}],"version-history":[{"count":3,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/339\/revisions"}],"predecessor-version":[{"id":442,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/339\/revisions\/442"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/338"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}