{"id":764,"date":"2019-11-27T00:01:00","date_gmt":"2019-11-27T05:01:00","guid":{"rendered":"https:\/\/spreadsheet-day.com\/blog\/?p=764"},"modified":"2019-11-26T10:59:03","modified_gmt":"2019-11-26T15:59:03","slug":"spreadsheet-roundup-20191127","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2019\/11\/27\/spreadsheet-roundup-20191127\/","title":{"rendered":"Spreadsheet Roundup 20191127"},"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>Functions<\/h3>\n<ul>\n<li><strong>Formulas<\/strong>: Here&#8217;s an interesting <a href=\"https:\/\/edu.gcfglobal.org\/en\/excelformulas\/practice-reading-formulas\/1\/\">interactive lesson on reading spreadsheet formulas<\/a>, with helpful tips for understanding how they work<\/li>\n<li><strong>Modelling<\/strong>: To learn about the latest trends, listen to the <a href=\"https:\/\/financialmodellingpodcast.com\/\">financial modelling podcast<\/a>, hosted by Matthew Bernath. There are 39 episodes so far, and the site has blog posts too.<\/li>\n<li><strong>Formula Coach<\/strong>: Have you tried Microsoft&#8217;s Excel Formula Coach? You can enter numbers online, and it builds a formula that you can paste into your workbook. I found <a href=\"https:\/\/support.content.office.net\/en-us\/coach\/excelcoach_pmt.html\">PMT<\/a>, <a href=\"http:\/\/support.content.office.net\/en-us\/coach\/excelcoach_PV_PartI.html\">PV<\/a> and <a href=\"http:\/\/support.content.office.net\/en-us\/coach\/excelcoach_FV_PartI.html\">FV<\/a> coaches, and there&#8217;s a spot to suggest other functions.<\/li>\n<\/ul>\n<h3>Charts and Data Analysis<\/h3>\n<ul>\n<li><strong>Charts:<\/strong> Michelle Rial <a href=\"https:\/\/mathwithbaddrawings.com\/2019\/10\/04\/instagram-ready-graphs-made-of-bottle-caps-hairpins-and-burnt-matches\/\">makes fascinating charts<\/a>, to amuse and\/or inspire you. If you think you&#8217;re too old to learn new spreadsheet things, check out the &#8220;Is it too late to start?&#8221; chart, about halfway down the page.<\/li>\n<li><strong>Data Viz Tips:<\/strong> On GitHub, MaryJo Webster has a Data Journalism page, with a <a href=\"http:\/\/mjwebster.github.io\/DataJ\/\">long list of training resources<\/a>. Do a search for &#8220;Excel&#8221; on that page, to find Excel tip sheets and other Excel resources. Who could resist &#8220;Torturing Excel into doing statistics&#8221;?<\/li>\n<li><strong>Good Charts<\/strong>: Ideas from chart expert, Alberto Cairo on <a href=\"https:\/\/ijnet.org\/en\/story\/data-visualizations-can-be-misleading-heres-what-you-can-do\">how to prepare and interpret charts<\/a>. Good tips at the end of the article.<\/li>\n<li><strong>VisComm<\/strong>: Download <a href=\"https:\/\/viscomm.io\/\">the papers and case studies<\/a> presented at the recent Visualization for Communication (VisComm) workshop.<\/li>\n<li><strong>Data Prep:<\/strong> Detailed steps from Lisa Charlotte Rost, show <a href=\"https:\/\/blog.datawrapper.de\/prepare-and-clean-up-data-for-data-visualization\/\">how to prepare your data for analysis<\/a> and charts. Data preparation takes work, but it&#8217;s worth it!<\/li>\n<\/ul>\n<h3>Spreadsheet Tips<\/h3>\n<ul>\n<li><strong>What&#8217;s New<\/strong>: Watch 13 <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/Resources-and-Community\/Excel-session-recordings-from-Ignite-2019\/m-p\/1018298#M481\">recordings from Excel sessions<\/a> at this year&#8217;s Microsoft Ignite event. See what Office Scripts can do, use Excel with Visio and Flow, or learn 5 pivot table hacks. And for a quick overview of what&#8217;s new, check the list of <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/Excel-Blog\/Excel-Announcements-Ignite-2019\/ba-p\/964482\">Excel announcements from Ignite<\/a>.<\/li>\n<li><strong>Drop Downs:<\/strong> On the Design Smarts site, Josh Wayne explains <a href=\"https:\/\/designsmarts.co\/the-problem-with-dropdowns\/\">the pros and cons of using drop down lists<\/a>. He&#8217;s talking about web forms, but the design ideas are good if you&#8217;re using <a href=\"https:\/\/www.contextures.com\/xlDataVal01.html\">data validation drop downs in spreadsheets<\/a> too.<\/li>\n<li><strong>Shortcuts<\/strong>: Dick Kusleika shows how to <a href=\"http:\/\/dailydoseofexcel.com\/archives\/2019\/11\/04\/international-keyboard-shortcut-day-2019\/\">use a keyboard shortcut to open Excel<\/a>, or any other program, if you have its icon on your Windows Taskbar. It only works for icons 1 to 9 though.<\/li>\n<\/ul>\n<p>_________________<\/p>\n<h3>Spreadsheet Roundup 20191127<\/h3>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2019\/11\/spreadsheetroundup201911a.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"spreadsheetroundup201911a\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2019\/11\/spreadsheetroundup201911a_thumb.jpg\" alt=\"spreadsheetroundup201911a\" width=\"425\" height=\"425\" border=\"0\" \/><\/a><\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2019\/11\/spreadsheetroundup201911b.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Spreadsheet Roundup 20191127\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2019\/11\/spreadsheetroundup201911b_thumb.jpg\" alt=\"Spreadsheet Roundup 20191127\" width=\"450\" height=\"225\" 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":760,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-764","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\/764","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=764"}],"version-history":[{"count":2,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"predecessor-version":[{"id":767,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/764\/revisions\/767"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/760"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}