{"id":422,"date":"2015-09-04T10:59:00","date_gmt":"2015-09-04T14:59:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/?p=422"},"modified":"2018-06-18T10:31:08","modified_gmt":"2018-06-18T14:31:08","slug":"spreadsheet-roundup-20150904","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2015\/09\/04\/spreadsheet-roundup-20150904\/","title":{"rendered":"Spreadsheet Roundup 20150904"},"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 over the summer. You\u2019ll 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><!--more--><\/p>\n<p>If you have suggestions for next month\u2019s spreadsheet roundup, please let me know. Thanks!<\/p>\n<p>&nbsp;<\/p>\n<h4>1. Classroom Spreadsheets<\/h4>\n<p>School has started again, and if math teacher Mohammed Ladak could only use one piece of software in his classroom, he would choose Excel. <a href=\"http:\/\/www.mathedup.co.uk\/excel-geeking\/\">See a few examples<\/a> of how he uses it in lessons.<\/p>\n<h4>2. Using Logic in Formulas<\/h4>\n<p>You can add logic to a spreadsheet formula with the IF function. Use a single IF:<\/p>\n<p><strong>=IF(test something, result if true, result if false)<\/strong><\/p>\n<p>Or created a \u201cnested\u201d IF formula, with multiple IFs. Glen Feechan breaks down the steps for <a href=\"http:\/\/www.notjustnumbers.co.uk\/2015\/06\/excel-tip-nested-if-statements.html\">building a nested IF formula<\/a> on the worksheet.<\/p>\n<p>There are simple IF and nested IF <a href=\"http:\/\/www.contextures.com\/xlfunctions06_excel-if-function.html\">examples on my IF function page<\/a>.<\/p>\n<h4>3. Chart Labels<\/h4>\n<p>Jon Peltier shows 5 ways you can <a href=\"http:\/\/peltiertech.com\/apply-custom-data-labels-to-charted-points\/\">add custom labels to your Excel charts<\/a>. The methods range from quick and easy (type over the existing labels) to using programming.<\/p>\n<h4>4. What Do You Need?<\/h4>\n<p>Dan Harrison reminds us to <a href=\"http:\/\/www.wizardofexcel.com\/2015\/06\/14\/always-validate-the-business-requirements\/\">validate the real business requirements<\/a>, before building something in a spreadsheet. What someone asks for might not be what they really need!<\/p>\n<h4>5. Productivity Tips<\/h4>\n<p>Chandoo shared <a href=\"http:\/\/chandoo.org\/wp\/2015\/07\/07\/analyst-productivity-tricks\/\">25 shortcuts and tricks to boost productivity<\/a>, and they\u2019re focused on Excel, but you can apply some of them to other types of spreadsheets too.<\/p>\n<p>Tip #22 is one that I use frequently \u2013 press the F4 key to repeat the last action. It doesn&#8217;t work for everything, but it&#8217;s a real timesaver!<\/p>\n<h4>6. Designing Dashboards<\/h4>\n<p>On her Excel for Educators blog, The Science Goddess shows her steps for designing dashboards to show student performance in different grades and subjects, over 4 years. <a href=\"http:\/\/excelforeducators.blogspot.ca\/2015\/08\/anatomy-of-design-build.html\">See the different versions that she created<\/a>, for demographic and achievement data, and the final results. You&#8217;ll get good ideas for your own dashboards.<\/p>\n<h4>7. Best Tips in 40 Years of Excel<\/h4>\n<p>Bill Jelen (Mr. Excel) has just released his latest book, <a href=\"https:\/\/amzn.to\/2ynsrm6\" target=\"_blank\" rel=\"noopener\">Mr. Excel XL \u2013 The 40 Greatest Excel Tips of All Time<\/a>. This is a beautiful book, packed with great tips, colour photos, and a nice touch of humour.<\/p>\n<p>It even has 40 of my favourite tweets, from the weekly collections on my <a title=\"Excel Theatre website\" href=\"http:\/\/exceltheatre.com\/blog\/\">Excel Theatre website<\/a>. And here is one of my favourite tweets from this summer \u2013 \u201cWrote a macro to save time. Closed Excel without saving it.\u201d<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/06\/twitter20150611b.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"twitter20150611b\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/06\/twitter20150611b_thumb.png\" alt=\"twitter20150611b\" width=\"388\" height=\"194\" border=\"0\" \/><\/a><\/p>\n<p>That\u2019s it for this roundup, and remember, if you have suggestions for the next roundup, please let me know. Thanks!<\/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 over the summer. You\u2019ll find interesting tips, useful sample files, and new ideas for your own spreadsheets. For a weekly Excel Roundup, please&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-422","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\/422","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=422"}],"version-history":[{"count":3,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/422\/revisions"}],"predecessor-version":[{"id":584,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/422\/revisions\/584"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/420"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}