{"id":775,"date":"2020-02-24T00:02:00","date_gmt":"2020-02-24T05:02:00","guid":{"rendered":"https:\/\/spreadsheet-day.com\/blog\/?p=775"},"modified":"2020-02-20T12:51:51","modified_gmt":"2020-02-20T17:51:51","slug":"spreadsheet-roundup-20200224","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2020\/02\/24\/spreadsheet-roundup-20200224\/","title":{"rendered":"Spreadsheet Roundup 20200224"},"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\u2019ve read recently. You\u2019ll find interesting tips, useful sample files, 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>Expand Your Skills<\/h3>\n<p><strong>Power Query<\/strong>: Don&#8217;t let your Excel skills fall behind! To stay current, invest some time to learn more about Power Query. Mike Girvin has lots of free PQ videos on his YouTube channel (ExcelIsFun), so <a href=\"https:\/\/www.youtube.com\/playlist?list=PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK\">check out his Power Query playlist<\/a>, and get started.<\/p>\n<p><strong>Get Hired<\/strong>: If you&#8217;re looking for a new job, here are a few tips on how to <a href=\"https:\/\/www.indeed.com\/career-advice\/resumes-cover-letters\/excel-skills-on-your-resume\">include your Excel skills in your r\u00e9sum\u00e9<\/a>.<\/p>\n<p><strong>New Features<\/strong>: What&#8217;s new in Excel, and are you ready to use the new features? Chris Newman looks forward to <a href=\"https:\/\/www.thespreadsheetguru.com\/blog\/5-excel-features-im-excited-for-in-2020\">trying these 5 new Excel features<\/a> this year. And the Register looks at a <a href=\"https:\/\/www.theregister.co.uk\/2020\/02\/11\/microsoft_web_macros_excel\/\">couple of new features coming to Excel<\/a> &#8212; Office Scripts and the XLOOKUP function.<\/p>\n<p><strong>Game Plan<\/strong>: On Reddit, someone asked, &#8220;I have two weeks to master excel &#8211; what should my game plan be?&#8221; and <a href=\"https:\/\/www.reddit.com\/r\/excel\/comments\/er09mq\/i_have_two_weeks_to_master_excel_what_should_my\/\">there are lots of good suggestions<\/a>, including the <a href=\"https:\/\/www.coursera.org\/specializations\/excel\">free university-run Excel classes<\/a> at Coursera.<\/p>\n<h3>Spreadsheet Problems<\/h3>\n<p><strong>Slow Macros<\/strong>: Excel <a href=\"https:\/\/contexturesblog.com\/archives\/2020\/01\/09\/excel-custom-function-udf-causing-problems\/\">macros ran really slowly in a workbook<\/a> that someone sent to me. The problem was caused by an Excel custom function (UDF) that ran for no apparent reason, and slowed other macros down. See what I did to make things a bit faster.<\/p>\n<ul>\n<li>TIP: Charles Williams sells a FastExcel add-in, that helps you find performance problems in Excel files. Read more about in <a href=\"https:\/\/www.contextures.com\/fastexcelv3review.html\">this FastExcel review on my site<\/a>.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/contexturesblog.com\/archives\/2020\/01\/09\/excel-custom-function-udf-causing-problems\/\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/contexturesblog.com\/wp-content\/uploads\/2020\/01\/customfunctionproblem01_thumb.png\" alt=\"convert number to written words\" width=\"363\" height=\"120\" border=\"1\" \/><\/a><\/p>\n<p><strong>Confusing Charts<\/strong>: Jon Peltier takes a <a href=\"https:\/\/peltiertech.com\/bar-lengths-on-a-chart-what-do-they-even-mean\/\">look at confusing Excel bar charts<\/a>, and suggests other ways to present the data<\/p>\n<p>&nbsp;<\/p>\n<h3>Working with Data<\/h3>\n<p><strong>Data Viz<\/strong>: Evelina Judeikyte shares a li<a href=\"https:\/\/www.evelina-judeikyte.com\/home\/2019-a-year-of-data-viz\">st of the resources she used last year<\/a>, while improving her data visualization skills. And as she says, &#8220;Nothing beats learning by doing. In repetition.&#8221; via <a href=\"https:\/\/nuzzel.com\/Biff_Bruise\">David Napoli<\/a><\/p>\n<p><strong>Excel Tips<\/strong>: The FireEye blog shows a <a href=\"https:\/\/www.fireeye.com\/blog\/threat-research\/2019\/12\/tips-and-tricks-to-analyze-data-with-microsoft-excel.html\">few tricks for cleaning up data in a<\/a> spreadsheet, with lots of formula examples.<\/p>\n<p><strong>Data Analysis<\/strong>: If you ever work with messy data in Excel, you&#8217;ll <a href=\"https:\/\/laskowskilab.faculty.ucdavis.edu\/2020\/01\/29\/retractions\/\">relate to the data nightmare problems<\/a> that Dr. Kate Lakowski had, when using someone else&#8217;s data. What a tangled &#8220;web&#8221; it was!<\/p>\n<p>______________________________<\/p>\n<h3>Spreadsheet Roundup 2020-02-24<\/h3>\n<p>Clean data, new features, and more!<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/02\/spreadsheetroundup20200224a.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Spreadsheet Roundup 2020-02-24\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/02\/spreadsheetroundup20200224a_thumb.jpg\" alt=\"Spreadsheet Roundup 2020-02-24\" width=\"400\" height=\"400\" border=\"0\" \/><\/a><\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/02\/spreadsheetroundup20200224b.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Spreadsheet Roundup 2020-02-24\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/02\/spreadsheetroundup20200224b_thumb.jpg\" alt=\"Spreadsheet Roundup 2020-02-24\" 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 roundup of selected spreadsheet articles that I\u2019ve read recently. You\u2019ll find interesting tips, useful sample files, and new ideas for your own spreadsheets. For Excel tips and tutorials, visit my Contextures&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":773,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-775","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\/775","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=775"}],"version-history":[{"count":2,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/775\/revisions"}],"predecessor-version":[{"id":778,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/775\/revisions\/778"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/773"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}