{"id":4024,"date":"2020-01-31T00:01:00","date_gmt":"2020-01-31T05:01:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4024"},"modified":"2020-08-16T13:57:06","modified_gmt":"2020-08-16T17:57:06","slug":"excel-tweets-roundup-20200131","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2020\/01\/31\/excel-tweets-roundup-20200131\/","title":{"rendered":"Excel Tweets Roundup 20200131"},"content":{"rendered":"<p style=\"text-align: left;\"><!--more-->Do your Excel formulas work on the first try?\u00a0Are pivot tables the high-water mark of Excel skills?\u00a0Don&#8217;t use too many Excel brain waves trying to answer those questions! And watch the video below, if you too want to make a VLOOKUP formula work on the first try.<\/p>\n<p><!--more--><\/p>\n<h3>This Week\u2019s Tweets<\/h3>\n<p>Here are my favourite Excel tweets, from all the ones that I saw on Twitter this week.<\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Today I intend to make work more exciting by announcing every action with &#8220;COMPUTER!&#8221;<\/p>\n<p>&#8220;COMPUTER, OPEN EXCEL AND LOAD THE COURSE LIST FILE!&#8221;<\/p>\n<p>*Moves mouse, clicks on Excel icon, loads file, cries in his cubicle*<\/p>\n<p>\u2014 Canovaccio (@Canovaccio) <a href=\"https:\/\/twitter.com\/Canovaccio\/status\/1222505286071660545?ref_src=twsrc%5Etfw\">January 29, 2020<\/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\">Bought a new monitor, using expanded to work between excel docs and my cursor keeps vanishing now. My cursor is cursed.<\/p>\n<p>\u2014 Kate of Kate Hall \u2615 (@erstkate) <a href=\"https:\/\/twitter.com\/erstkate\/status\/1222831925972176896?ref_src=twsrc%5Etfw\">January 30, 2020<\/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 have to use excel a lot at work and today I wrote a if(isna(vlookup))) that WORKED ON THE FIRST TRY I\u2019m aware this is a niche tweet but I finally have a job that I like and that appreciates my work. My coworker actually applauded this<\/p>\n<p>\u2014 B (@insomniamemoirs) <a href=\"https:\/\/twitter.com\/insomniamemoirs\/status\/1222706471802040320?ref_src=twsrc%5Etfw\">January 30, 2020<\/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\">Is there a reason Pivot Tables are considered the high-water mark of Excel knowledge? Is it short hand for &#8220;If you&#8217;ve used a Pivot Table, presumably you&#8217;ve gotten to the point where you needed one?&#8221;<\/p>\n<p>\u2014 Brennan Molina (@bmolinaboston) <a href=\"https:\/\/twitter.com\/bmolinaboston\/status\/1222585684357263361?ref_src=twsrc%5Etfw\">January 29, 2020<\/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\">Last day of Power BI training. Workshop day. I&#8217;m going to work on converting a monster Excel file with lots of VLOOKUPs. <a href=\"https:\/\/t.co\/rGr2NBUoKQ\">pic.twitter.com\/rGr2NBUoKQ<\/a><\/p>\n<p>\u2014 Marshall MSP (@MyNextAct) <a href=\"https:\/\/twitter.com\/MyNextAct\/status\/1222896428613132294?ref_src=twsrc%5Etfw\">January 30, 2020<\/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 always assumed that critical parts of the Excel code were written in uncommented 8086 assembler language by a recent college graduate in the late 1980s.<\/p>\n<p>\u2014 Steven Schumacher (@muckledger) <a href=\"https:\/\/twitter.com\/muckledger\/status\/1222879211741945856?ref_src=twsrc%5Etfw\">January 30, 2020<\/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\">Gamers that work:<\/p>\n<p>Do you find yourself reading a document or doing something and notice that you&#8217;ve naturally rested your left hand on WASD?<\/p>\n<p>It&#8217;s like I want to strafe on Excel.<\/p>\n<p>\u2014 Frolicols (@frolicols) <a href=\"https:\/\/twitter.com\/frolicols\/status\/1222838306469302275?ref_src=twsrc%5Etfw\">January 30, 2020<\/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\">You ever come across a problem task at work, realize your in for a real long and bad time with it, then suddenly have a brain wave and triumphantly come up with a quick fix? Cuz I just did and I feel like an Excel Spreadsheet King!<\/p>\n<p>\u2014 Kranky Kobold (@MenaceFromSpace) <a href=\"https:\/\/twitter.com\/MenaceFromSpace\/status\/1222653261888524288?ref_src=twsrc%5Etfw\">January 29, 2020<\/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\">You know you&#8217;re a working adult when you get excited to use an Excel spreadsheet you made, because it&#8217;ll make your work that much more organized.<\/p>\n<p>\u2014 BubbleberryVII (@BubbleberryVII) <a href=\"https:\/\/twitter.com\/BubbleberryVII\/status\/1222537201201950721?ref_src=twsrc%5Etfw\">January 29, 2020<\/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\">Me: Just about done with this thing I\u2019ve been working on all day and I can go home at a reasonable hour for a change.<\/p>\n<p>Excel: LOLOLOLOL no. ::crashes for literally no reason::<\/p>\n<p>Me: ::tears computer in half through sheer rage and throws both halves across the office::<\/p>\n<p>\u2014 Patrick (@UprootedTexan99) <a href=\"https:\/\/twitter.com\/UprootedTexan99\/status\/1222686938441797633?ref_src=twsrc%5Etfw\">January 30, 2020<\/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\">If your answer isn&#8217;t pivot tables do you really love <a href=\"https:\/\/twitter.com\/hashtag\/Excel?src=hash&amp;ref_src=twsrc%5Etfw\">#Excel<\/a>? <a href=\"https:\/\/t.co\/SvBu80RGXu\">https:\/\/t.co\/SvBu80RGXu<\/a><\/p>\n<p>\u2014 Alex Carter (@AlexEdCarter) <a href=\"https:\/\/twitter.com\/AlexEdCarter\/status\/1222899728641212416?ref_src=twsrc%5Etfw\">January 30, 2020<\/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 used to think running a report was this thing that took a lot of work and concentration. Turns out it\u2019s basically a fancy way of saying you\u2019re opening an excel spreadsheet <a href=\"https:\/\/twitter.com\/hashtag\/adulthoodsham?src=hash&amp;ref_src=twsrc%5Etfw\">#adulthoodsham<\/a><\/p>\n<p>\u2014 cheese (@k_so_queso) <a href=\"https:\/\/twitter.com\/k_so_queso\/status\/1222886579267690496?ref_src=twsrc%5Etfw\">January 30, 2020<\/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\">my boss is making me a medal to celebrate my new job title of &#8216;excel legend&#8217; for essentially knowing the COUNTIF function exists, they think I am a real life wizard <a href=\"https:\/\/t.co\/rLuOIYUCBH\">pic.twitter.com\/rLuOIYUCBH<\/a><\/p>\n<p>\u2014 al (@jllyf1sh) <a href=\"https:\/\/twitter.com\/jllyf1sh\/status\/1222568916590956544?ref_src=twsrc%5Etfw\">January 29, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<h3>Find Product Price with Excel VLOOKUP<\/h3>\n<p>Learn more about the Excel <a href=\"https:\/\/www.contextures.com\/xlFunctions02.html\">VLOOKUP<\/a> function<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/boec-ZlGQV8?rel=0\" width=\"450\" height=\"283\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>________________________________________________<\/p>\n<h3>Excel Tweets Roundup<\/h3>\n<p>Thanks for reading this week&#8217;s Excel tweets roundup, and did you have a favourite?<\/p>\n<p>And then Excel crashed!<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200131a.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"exceltwitter20200131a\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200131a_thumb.jpg\" alt=\"exceltwitter20200131a\" width=\"400\" height=\"400\" border=\"0\" \/><\/a><\/p>\n<p>________________________________________________<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200131b.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"And then Excel crashed!\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200131b_thumb.jpg\" alt=\"And then Excel crashed!\" width=\"400\" height=\"200\" border=\"0\" \/><\/a><\/p>\n<p>________________________________________________<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":4022,"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-4024","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\/4024","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=4024"}],"version-history":[{"count":3,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4024\/revisions"}],"predecessor-version":[{"id":4158,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4024\/revisions\/4158"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4022"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}