{"id":884,"date":"2021-02-17T00:01:00","date_gmt":"2021-02-17T05:01:00","guid":{"rendered":"https:\/\/spreadsheet-day.com\/blog\/?p=884"},"modified":"2021-02-14T13:47:41","modified_gmt":"2021-02-14T18:47:41","slug":"spreadsheet-roundup-2021-02-17","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2021\/02\/17\/spreadsheet-roundup-2021-02-17\/","title":{"rendered":"Spreadsheet Roundup 2021-02-17"},"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 Winter 2021 roundup of spreadsheet articles that I\u2019ve read recently. You\u2019ll find interesting tips, and new ideas for your own spreadsheets.<\/p>\n<p>For Excel tips and tutorials, <a href=\"https:\/\/www.contextures.com\/tiptech.html\">visit my Contextures website<\/a>.<!--more--><\/p>\n<h3>Data and Dashboards<\/h3>\n<p><b>Clean Your Data<\/b> &#8212; The worst part of working with data is cleaning it up. To help save time, use these <a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5916-excel-tips-for-data-analysts.html\">data cleanup techniques<\/a>, from the Investintech blog.<\/p>\n<p><b>Dashboard Tips<\/b> &#8212; There are lots of great tips and examples in <a href=\"https:\/\/tessellationtech.io\/dashboard-design-essentials-basics-of-design\/\">this Dashboard Design Essentials article<\/a> by Spencer Baucke<\/p>\n<h3>In the News<\/h3>\n<p><strong>Personal Finance<\/strong> \u2013 See how couples <a href=\"https:\/\/www.theguardian.com\/money\/2021\/feb\/13\/we-created-a-spreadsheet-how-couples-manage-their-cash\" target=\"_blank\" rel=\"noopener\">use spreadsheets to manage their cash<\/a>, and try to spot potential problems.<\/p>\n<p><strong>Online Spreadsheets <\/strong>\u2013 Recent <a href=\"https:\/\/www.zdnet.com\/article\/microsoft-excel-on-the-web-just-got-a-whole-lot-easier-to-use\/\" target=\"_blank\" rel=\"noopener\">updates to Google Sheets and the online version of Excel<\/a> should make your work a bit easier.<\/p>\n<p><strong>Spreadsheet Problems<\/strong> \u2013 Edward Hearn says companies need to <a href=\"https:\/\/builtin.com\/data-science\/spreadsheet-cleaning\" target=\"_blank\" rel=\"noopener\">take their spreadsheets more seriously, to avoid problems<\/a>. Fancy technical solutions won&#8217;t get rid of bad data.<\/p>\n<h3>Functions<\/h3>\n<p><strong>XLOOKUP<\/strong>: Have you tried Excel&#8217;s new XLOOKUP function yet? Chandoo has <a href=\"https:\/\/chandoo.org\/wp\/xlookup-examples\/\">13 examples that show you how XLOOKUP works<\/a>.<\/p>\n<p><strong>Spill Functions<\/strong>: Thanks to Dermot Balson, who sent me his Excel workbook with examples for all the new functions (dynamic arrays) in Excel for Office 365. To get the sample file, go to <a href=\"https:\/\/www.contextures.com\/excelspillformulaexamples.html\">the Excel Spill Functions page<\/a> on my Contextures site.<\/p>\n<h3>Spreadsheet Resources<\/h3>\n<p><strong>Spreadsheets <\/strong>&#8211; The <a href=\"https:\/\/subjectguides.york.ac.uk\/skills\/spreadsheets\">Essential Spreadsheets guide<\/a>, on the University of York site, shows how to do things in Excel and Google Sheets, with written steps, videos and sample files. It&#8217;s interesting to see the comparisons!<\/p>\n<p><b>Excel Tips<\/b> &#8212; Watch <a href=\"https:\/\/open.ed.ac.uk\/excelling-in-excel\/\">Excelling in Excel, a mini course<\/a> from the University of Edinburgh. There 3 videos &#8211; data organization, tips and tricks, data visualisation<\/p>\n<h3>Spreadsheet Tweets<\/h3>\n<p>Finally, here are a few recent spreadsheet tweets, for a bit of humour.<\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Is it weird that I don\u2019t remember what a pivot table is for? I used to have a literal certification in Excel.<\/p>\n<p>\u2014 Norman the PhDM (@metadoxy) <a href=\"https:\/\/twitter.com\/metadoxy\/status\/1361010799515492352?ref_src=twsrc%5Etfw\">February 14, 2021<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\" data-cards=\"hidden\" data-conversation=\"none\">\n<p dir=\"ltr\" lang=\"en\">I got ribbed the other day at work for circulating a spreadsheet with a large font. Kids.<\/p>\n<p>\u2014 Matt Van Tassel (@MattVanTassel) <a href=\"https:\/\/twitter.com\/MattVanTassel\/status\/1360698407975804939?ref_src=twsrc%5Etfw\">February 13, 2021<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">I&#8217;m at the &#8220;build an effigy of MS Excel&#8221; stage of a pivottable. I have a column of *only* times. The Pivot table returns months and quarters. WHY<\/p>\n<p>\u2014 Evan Beaver (@evcricket) <a href=\"https:\/\/twitter.com\/evcricket\/status\/1360724403324035075?ref_src=twsrc%5Etfw\">February 13, 2021<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">When you\u2019ve got ADD, are a spreadsheet nerd, and need to buy a new work laptop. <a href=\"https:\/\/t.co\/t6HJm2AeGz\">pic.twitter.com\/t6HJm2AeGz<\/a><\/p>\n<p>\u2014  brujabasura  (@LaBrujaBasura) <a href=\"https:\/\/twitter.com\/LaBrujaBasura\/status\/1361011443563454465?ref_src=twsrc%5Etfw\">February 14, 2021<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<h3>Spreadsheet Roundup 2021-02-17<\/h3>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2021\/02\/spreadsheetroundup20210217.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"Spreadsheet Roundup 2021-02-17\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"Spreadsheet Roundup 2021-02-17\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2021\/02\/spreadsheetroundup20210217_thumb.jpg\" width=\"400\" height=\"400\" border=\"0\"><\/a><\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2021\/02\/spreadsheetroundup20210217b.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"Spreadsheet Roundup 2021-02-17\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"Spreadsheet Roundup 2021-02-17\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2021\/02\/spreadsheetroundup20210217b_thumb.jpg\" width=\"400\" height=\"200\" border=\"0\"><\/a><\/p>\n<p>_______________________________________________<\/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 Winter 2021 roundup of spreadsheet articles that I\u2019ve read recently. You\u2019ll find interesting tips, and new ideas for your own spreadsheets. For Excel tips and tutorials, visit my Contextures website.<\/p>\n","protected":false},"author":1,"featured_media":880,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-884","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\/884","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=884"}],"version-history":[{"count":3,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":888,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions\/888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/880"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}