{"id":2268,"date":"2014-10-17T00:01:00","date_gmt":"2014-10-17T04:01:00","guid":{"rendered":"http:\/\/exceltheatre.com\/blog\/?p=2268"},"modified":"2021-03-17T14:16:23","modified_gmt":"2021-03-17T18:16:23","slug":"excel-twitter-20141017","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2014\/10\/17\/excel-twitter-20141017\/","title":{"rendered":"Excel Twitter 20141017"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; float: right; padding-top: 0px; padding-left: 0px; margin: 0px 0px 10px 10px; display: inline; padding-right: 0px; border: 0px;\" title=\"I don't do spreadsheets, but when I do...they are gonna be pretty http:\/\/exceltheatre.com\/blog\/\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2014\/10\/image4.png\" alt=\"I don't do spreadsheets, but when I do...they are gonna be pretty http:\/\/exceltheatre.com\/blog\/\" width=\"84\" height=\"88\" border=\"0\" align=\"right\">Have you committed any Excel crimes this week, or achieved a victory, even if it\u2019s just a technical knockout?<\/p>\n<p>Thanks to Bill Jelen for his contribution this week! If you see any Excel tweets that should be included next week, please let me know \u2013&nbsp; @ddalgleish on Twitter.<\/p>\n<p><!--more--><\/p>\n<p>One of this week&#8217;s tweets is about Excel date formats, and this short video shows how to fix dates that won&#8217;t change format.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/PJ200RCVHpg?rel=0\" allow=\"autoplay; encrypted-media\" allowfullscreen=\"\" width=\"450\" height=\"283\" frameborder=\"0\"><\/iframe><\/p>\n<ul>\n<li>At some point, the pivot table that I was working on achieved sentience. Time for a beer.<\/li>\n<li>I was born on 41897.1319444, if you use MS Excel serial date code. No word on the appropriate star date.<\/li>\n<li>Excel is mighty boring when your mind is in creative overdrive. Would work notice if i wrote a poem in the cells that nobody sees?<\/li>\n<li>I know I&#8217;m a dork because the thing I&#8217;m most excited for at work is making the date formats all same in excel. It&#8217;s bugged me for months.<\/li>\n<li>I&#8217;ve made 73 charts in excel in the last 2 days #youknowyoureaninternwhen<\/li>\n<li>Man, the extent to which knowing a couple-three stupid Excel tricks has saved me from having to learn how to code\u2026<\/li>\n<li>I don&#8217;t do spreadsheets, but when I do&#8230;they are gonna be pretty #excel #color #spreadsheet #data<\/li>\n<li>Ppl who make a chart in Excel with default settings, then post a screenshot with the &#8220;Plot Area&#8221; tooltip still showing &#8211; drawn &amp; quartered<\/li>\n<li>i&#8217;ve had so many people offer to teach me how to use excel &amp; then I show them the functions I have to graph and they never talk to me again<\/li>\n<li>Will you send me a blank excel sheet? Yes youre an idiot lol just pull up excel. I cant do stupid today.<\/li>\n<li>Soo Boss is making suggestions on how Excel &amp; Quickbooks can work together. Boss doesn&#8217;t know how to use either program.<\/li>\n<li>I&#8217;ve been wrestling with Excel&#8217;s dynamic range names &amp; charts. After 12 rounds and 2 x 8 seconds for me got a technical victory, not a KO ;(<\/li>\n<li>The excel spreadsheet I just worked on for the past 2 hours just disappeared without a trace. So that&#8217;s enough work for today.<\/li>\n<li>Wrote a code tonight from scratch in Excel 2013 that was a foot long. The feeling was probably similar to that of a very, very proud parent.<\/li>\n<li>Such a computer nerd that voluntarily customizing an excel workbook excites me<\/li>\n<li>Spending the whole morning trying to fix a pivot table and then finally cracking it is the most satisfying thing! #sad #simplethings<\/li>\n<li>Getting my formula right in my pivot table generates the same reaction I used to have when scoring a goal playing sports. #AdultLifeSucksAss<\/li>\n<li>&#8220;I know how to create a pivot table, but it doesn&#8217;t mean I want to!&#8221; \ud83d\ude09 #SPSRed<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; margin: 0px 0px 10px 10px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"I don't do spreadsheets, but when I do...they are gonna be pretty http:\/\/exceltheatre.com\/blog\/\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2014\/10\/twitter20141017.png\" alt=\"I don't do spreadsheets, but when I do...they are gonna be pretty http:\/\/exceltheatre.com\/blog\/\" width=\"353\" height=\"353\" border=\"0\"><\/p>\n<p>______________________<\/p>\n<p><span style=\"border-radius: 2px; text-indent: 20px; width: auto; padding: 0px 4px 0px 0px; text-align: center; font: bold 11px\/20px 'Helvetica Neue',Helvetica,sans-serif; color: #ffffff; background: #bd081c  no-repeat scroll 3px 50% \/ 14px 14px; position: absolute; opacity: 0.85; z-index: 8675309; display: none; cursor: pointer; top: 1004px; left: 30px;\">Save<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you committed any Excel crimes this week, or achieved a victory, even if it\u2019s just a technical knockout? Thanks to Bill Jelen for his contribution this week! If you see any Excel tweets that should be included next week, please let me know \u2013&nbsp; @ddalgleish on Twitter.<\/p>\n","protected":false},"author":2,"featured_media":2267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-2268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-humor"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/2268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=2268"}],"version-history":[{"count":8,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/2268\/revisions"}],"predecessor-version":[{"id":4176,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/2268\/revisions\/4176"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/2267"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=2268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=2268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=2268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}