{"id":292,"date":"2015-01-07T15:07:00","date_gmt":"2015-01-07T20:07:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/?p=292"},"modified":"2019-10-18T19:03:52","modified_gmt":"2019-10-18T23:03:52","slug":"spreadsheet-roundup-20150107","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2015\/01\/07\/spreadsheet-roundup-20150107\/","title":{"rendered":"Spreadsheet Roundup 20150107"},"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 from last month.<\/p>\n<ul>\n<li>At Macworld, Lou Hattersley <a href=\"http:\/\/www.macworld.co.uk\/review\/business\/microsoft-excel-vs-apple-numbers-review-3510107\/\">compares the iPad versions of Microsoft Excel and Apple Numbers<\/a>. Her recommendation might surprise you.<\/li>\n<\/ul>\n<ul>\n<li>Mu Lin suggests <a href=\"http:\/\/www.mulinblog.com\/three-guidelines-for-designing-data-dashboard-in-news-reports\/\">3 guidelines for designing data dashboards<\/a>. While the article focuses on news reports, the tips can be applied to other dashboard types.<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<ul>\n<li>Charlotte Utting outlines <a href=\"http:\/\/blogs.technet.com\/b\/uktechnet\/archive\/2014\/11\/28\/the-data-analysts-toolkit-why-are-excel-and-r-useful-together-and-how-do-we-connect-them.aspx\">why Excel and R are useful together<\/a>, and explains how you can connect them.<\/li>\n<\/ul>\n<ul>\n<li>To fix currency data from another region, you can <a href=\"http:\/\/blog.contextures.com\/archives\/2014\/11\/27\/convert-currency-with-different-separators\/\">quickly change currency separators<\/a> with the Text to Columns feature<\/li>\n<\/ul>\n<ul>\n<li>In Excel, you can select <a href=\"http:\/\/blog.contextures.com\/archives\/2014\/12\/11\/select-multiple-items-from-long-list-in-excel\/\">multiple items from a long drop down list<\/a>, using a popup form with a combo box and list box.<\/li>\n<\/ul>\n<ul>\n<li>Download &#8220;Communicating Data&#8221;,<a href=\"http:\/\/dataremixed.com\/2014\/12\/free-sampler-of-communicating-data-with-tableau\/\">the first chapter of Ben Jones&#8217; book<\/a>, Communication Data with Tableau. The concepts can be applied to spreadsheets too.<\/li>\n<\/ul>\n<ul>\n<li>In December, an Office update <a href=\"http:\/\/dailydoseofexcel.com\/archives\/2014\/12\/11\/recent-update-of-office-causes-problems-with-activex-controls\/\">broke the ActiveX controls in Excel<\/a>, and Jan Karel Pieterse shows how to fix the problem<\/li>\n<\/ul>\n<ul>\n<li>If a data validation list has hundreds of items, this technique can help. Type a couple of letters in one columns, and see a <a href=\"http:\/\/blog.contextures.com\/archives\/2014\/12\/04\/show-drop-down-list-with-specific-letters\/\">short drop down list<\/a> in the adjacent column, with only items that contain those specific letters.<\/li>\n<\/ul>\n<ul>\n<li>When you group dates in a pivot table, Excel creates <a href=\"http:\/\/www.pivot-table.com\/2014\/11\/26\/grouping-dates-add-extra-items-in-pivot-table-filter\/\">extra items in the pivot table filter<\/a> \u2013 see a couple of workarounds for this problem<\/li>\n<\/ul>\n<ul>\n<li>After the recent file hacking at Sony Pictures, Melanie Pinoa reminds you that you <a href=\"http:\/\/www.itworld.com\/article\/2855987\/a-lesson-from-sonys-massive-hack-dont-store-your-passwords-in-word-docs-and-excel-sheets.html\">shouldn&#8217;t store all your passwords in an Excel file<\/a>.<\/li>\n<\/ul>\n<ul>\n<li>Jordan Goldmeier takes a look at <a href=\"http:\/\/optionexplicitvba.com\/2014\/12\/02\/on-using-complex-ifs-and-chapter-3-now-free\/\">complicated Nested IF formulas<\/a>, and when you should use them.<\/li>\n<\/ul>\n<ul>\n<li>If you build a column chart, Ga\u0161per Kamen\u0161e shows how to <a href=\"http:\/\/excelunplugged.com\/2014\/12\/02\/making-your-min-max-chart-in-excel-truly-shine\/\">highlight the smallest and largest amounts<\/a>.<\/li>\n<\/ul>\n<ul>\n<li>For an in-cell chart, Chandoo explains how to include <a href=\"http:\/\/chandoo.org\/wp\/2014\/12\/03\/in-cell-charts-with-markers\/\">markers for average or a target<\/a>.<\/li>\n<\/ul>\n<ul>\n<li>Zack Barresse explains the difference between <a href=\"http:\/\/exceltables.com\/remembering-table-formulas\/\">clean and dirty columns in an Excel table<\/a>.<\/li>\n<\/ul>\n<p><strong>Links to Recent Excel Books on Amazon.com<\/strong><\/p>\n<p><a href=\"http:\/\/www.amazon.com\/gp\/product\/1500399434\/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1500399434&amp;linkCode=as2&amp;tag=ctxblog-20&amp;linkId=QNPNKQ4TOMLEQVTO\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/ws-na.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=1500399434&amp;Format=_SL110_&amp;ID=AsinImage&amp;MarketPlace=US&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=ctxblog-20\" alt=\"\" width=\"129\" height=\"159\" border=\"0\" \/><\/a><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=ctxblog-20&amp;l=as2&amp;o=1&amp;a=1500399434\" alt=\"\" width=\"1\" height=\"1\" border=\"0\" \/>\u00a0<a href=\"http:\/\/www.amazon.com\/gp\/product\/1484207351\/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1484207351&amp;linkCode=as2&amp;tag=ctxblog-20&amp;linkId=TMT52I2WDGD24WAJ\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/ws-na.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=1484207351&amp;Format=_SL110_&amp;ID=AsinImage&amp;MarketPlace=US&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=ctxblog-20\" alt=\"\" width=\"128\" height=\"158\" border=\"0\" \/><\/a><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=ctxblog-20&amp;l=as2&amp;o=1&amp;a=1484207351\" alt=\"\" width=\"1\" height=\"1\" border=\"0\" \/>\u00a0<a href=\"http:\/\/www.amazon.com\/gp\/product\/3642426204\/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=3642426204&amp;linkCode=as2&amp;tag=ctxblog-20&amp;linkId=IBOHE6GXB2FDZDYC\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/ws-na.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=3642426204&amp;Format=_SL250_&amp;ID=AsinImage&amp;MarketPlace=US&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=ctxblog-20\" alt=\"\" width=\"106\" height=\"161\" border=\"0\" \/><\/a><\/p>\n<p>__________________________-<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/01\/spreadsheetdaylogo2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/01\/spreadsheetdaylogo2016.png\" alt=\"Spreadsheet Day Logo\" width=\"378\" height=\"207\" srcset=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/01\/spreadsheetdaylogo2016.png 378w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2015\/01\/spreadsheetdaylogo2016-300x164.png 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/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 from last month. At Macworld, Lou Hattersley compares the iPad versions of Microsoft Excel and Apple Numbers. Her recommendation might surprise you. Mu Lin suggests 3&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":756,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-292","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\/292","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=292"}],"version-history":[{"count":4,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/292\/revisions"}],"predecessor-version":[{"id":758,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/292\/revisions\/758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/756"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}